34,587
社区成员
发帖
与我相关
我的任务
分享
if object_id('[gx]') is not null drop table [gx]
declare @sql text --varchar(8000)
declare @mcount datetime--月天数
declare @i datetime --计数
select @i=min(交货日期) from schedule_1
select @mcount=max(交货日期) from schedule_1
set @sql='select 客户编号,产品编号,社内品番,工序名称,工时'
while @i<=@mcount
begin
set @sql=isnull(@sql+',','')+'max(case convert(char(10),交货日期,121) when '+''''+convert(char(10),@i,121)+''''+' then cast([计划数量] as int) else '''' end) as ['+convert(char(10),@i,121)+']'
set @i=@i+1
end
print @sql
set @sql=@sql+' into gx from schedule_1 group by 客户编号,产品编号,社内品番,工序名称,工时 order by 客户编号,产品编号,case 工序名称 when ''切断'' then 1 when ''仕上'' then 2 when ''嵌压入'' then 3
when ''研磨'' then 4 when ''QC'' then 5 end'
print len(@sql)
exec(@sql)
while @i<=@mcount
begin
set @sql=isnull(@sql+',','')+'max(case convert(char(10),交货日期,121) when '+''''+convert(char(10),@i,121)+''''+' then cast([计划数量] as int) else '''' end) as ['+convert(char(10),@i,121)+']'
set @i=@i+1
end