|
BEGIN
select @StkDelDate = min(deldate), @StkUPP =min(upp)
from #Stknwip
Where Partnum = @StkPartnum and Revision = @StkRevision
Update t1 Set t1.DelDate = @StkDelDate , t1.UPP = @StkUPP From #Stknwip t1
Where t1.Partnum = @StkPartnum and t1.Revision = @StkRevision
and (isnull(t1.DelDate,''''01/01/1900'''')= ''''01/01/1900'''' or isnull(t1.UPP,''''-'''') = ''''-'''')
FETCH NEXT FROM CU_StknWip INTO @StkPartnum , @StkRevision
END
END
CLOSE CU_StknWip
DEALLOCATE CU_StknWip
Declare @s varchar(8000)
Set @s=''''''''
Select @s=@s+'''',[''''+rtrim(proccode)+''''] = max(case proccode when ''''''''''''+rtrim(proccode)+'''''''''''' then Qnty else '''''''''''''''' end)''''
From #Stknwip Group By proccode , Id Order By Id
if exists (select * from dbo.sysobjects where id = object_id(N' << 上一页 [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] ... 下一页 >> | 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 