set @sql='insert into '+@ltable+'(ywyID,ywymc,bmmc,deptpath,sjbmmc,iysSum) select ywyID,ywymc,bmmc,deptpath,sjbmmc,sum(iSum) iSum from (select ywyID,ywymc,bmmc,deptpath,sjbmmc,isnull(ycye,0) iSum from '+@TEMP_ysmxtb+' where xdqr<'''+@nextdate+''' union all select ywyID,ywymc,bmmc,deptpath,sjbmmc,isnull(bqxs,0) iSum from '+@TEMP_ysmxtb
set @strSql=' where zq =0 and year(CONVERT(datetime,xdqr))= '+CONVERT(varchar(4),@iyear)+' and month(CONVERT(datetime,xdqr))='+CONVERT(varchar(4),@imonth)+') a group by ywyID,ywymc,bmmc,deptpath,sjbmmc'
print (@sql+@strSql)
exec(@sql+@strSql)--@iyear和@imonth传的都是int 拼字符串时，必须先转成字符串，不然会报错
--and year(CONVERT(datetime,xdqr))='+@iyear+' and month(CONVERT(datetime,xdqr))='+@imonth+'
