哦,不是这个问题是引号的问题select @str='insert #tem1 select WTLY,sum(CJSL),sum(CJJE),sum(S1),sum(S2),' +'sum(S3),sum(S4),sum(S5),sum(YSJE) FROM '+@tab +' where S1>0.005 and WTLY!='' '' and convert(char(10),CJSJ,102) between '''+@ksrq+''' and '''+@jsrq+'''' 日期比较最好改一下:select @str='insert #tem1 select WTLY,sum(CJSL),sum(CJJE),sum(S1),sum(S2),' +'sum(S3),sum(S4),sum(S5),sum(YSJE) FROM '+@tab +' where S1>0.005 and WTLY!='' '' and CJSJ >= '''+@ksrq+''' and CJSJ <= '''+@jsrq+''''
+'sum(S3),sum(S4),sum(S5),sum(YSJE) FROM '+@tab
+' where S1>0.005 and WTLY!='' '' and convert(char(10),CJSJ,102) between '''+@ksrq+''' and '''+@jsrq+''''
日期比较最好改一下:select @str='insert #tem1 select WTLY,sum(CJSL),sum(CJJE),sum(S1),sum(S2),'
+'sum(S3),sum(S4),sum(S5),sum(YSJE) FROM '+@tab
+' where S1>0.005 and WTLY!='' '' and CJSJ >= '''+@ksrq+''' and CJSJ <= '''+@jsrq+''''
SET QUOTED_IDENTIFIER OFF
go在运行你的语句,不要改