执行动态SQL时出错!
declare @fmdate datetime,@todate datetime,@mysql varchar(1000)
select @fmdate = '2005-11-01'
select @todate = '2005-11-14'
while @fmdate < @todate
begin
set @mysql = 'sum(case x_wk_pdate when '+@fmdate+' then x_wk_time else 0 end) as '+@fmdate+' ,' + isnull(@mysql,'')
set @fmdate = DATEADD(day, 1, @fmdate)
end
set @mysql = 'select x_gro_id,x_wk_id,' + @mysql + ' from xy_wk_wage group by x_gro_id,x_wk_id '
exec @mysql
go
服务器: 消息 241,级别 16,状态 1,行 10
从字符串转换为 datetime 时发生语法错误。