asp能执行动态T-SQL吗？

原帖子：http://topic.csdn.net/u/20090910/12/813a40a2-922d-4f6a-b30b-a16b9a608f81.html?seed=1336087098&r=59699368#r_59699368

下面的代码有错误吗？sql语句在Query中是可以执行出结果的。
Set CONN = server.createobject("adodb.connection")
CONN.open "driver={sql server};server=ACN-SERVERDB;uid=eoadb;pwd=bellasia;database=eprocessDB"
sql= " declare @1 nvarchar(max),@2 nvarchar(max) "&_
"select @1=isnull(@1+',','')+name from syscolumns where id=object_id('QDR') and name like '%DUTY_UNIT%' "&_
"select @2=isnull(@2+',','')+quotename(convert(varchar(2),month(TASK_CreateTime))+'月','[')  "&_
"from QDR a inner join dbo.SYS_INST_TASKS b on a.taskid=b.task_id "&_
" where TASK_ApproveReject <>2 "&_
" and year(TASK_CreateTime)=year(getdate()) "&_
" group by month(TASK_CreateTime) "&_
" exec(' "&_
"select 责任单位,'+@2+' "&_
"from  "&_
"( "&_
"select convert(varchar(2),month(TASK_CreateTime))+''月'' as bt,  "&_
"DUTY_UNIT1,DUTY_UNIT2,DUTY_UNIT3,DUTY_UNIT4,DUTY_UNIT5,DUTY_UNIT6,DUTY_UNIT7,DUTY_UNIT8, "&_
"DUTY_UNIT10,DUTY_UNIT11,DUTY_UNIT