declare @sql nvarchar(4000)
declare @i int
declare @date t_date
declare @date1 t_date
select @i=1
select @date='20100101'
select @date1='20101010'select @sql='update'+'wd8103_'+cast(@i as nvarchar(2))+'=select sum(fgrd_qty) from wo_mstr join fgrd_det on fgrd_nbr=wo_nbr and fgrd_lot=wo_lot
join fgr_mstr on fgr_fgr=fgrd_fgr
where left(wo_nbr,2)=''DW'' and wo_line<>''1367''
and fgr_loc=''1803'' and left(wo_part,1)=''8'' and fgr_date between '+ @date + 'and' +@date1''
print @sql
我这个写的错在哪。。大伙指教。。
declare @i int
declare @date varchar(10)
declare @date1 varchar(10)
select @i=1
select @date='2010-01-01'
select @date1='2010-10-10'select @sql='update'+'wd8103_'+cast(@i as nvarchar(2))+'=select sum(fgrd_qty) from wo_mstr join fgrd_det on fgrd_nbr=wo_nbr and fgrd_lot=wo_lot
join fgr_mstr on fgr_fgr=fgrd_fgr
where left(wo_nbr,2)=''DW'' and wo_line<>''1367''
and fgr_loc=''1803'' and left(wo_part,1)=''8'' and fgr_date between '''+ @date + ''' and ''' +@date1+''''
print @sql