'''[dbo].[X_tmpWeekProc]'''') and OBJECTPROPERTY(id, N''''IsUserTable'''') = 1)
drop table [dbo].[X_tmpWeekProc]
Exec(''''select Partnum, Revision , DelDate=min(DelDate) ,UPP ''''+@s+'''' Into X_tmpWeekProc from #Stknwip group by Partnum , Revision, UPP '''')
Select * Into #StknWipTotal From X_tmpWeekProc
Drop Table X_tmpWeekProc
Select t2.PartNum,t2.Revision, PQnty = Sum(t2.PQnty)
Into #InWarehouse
From PDL_PassBas t1(nolock),
PDL_PassDtl t2(nolock),
LotInfo t3(nolock)
Where t1.PaperNo = t2.PaperNo
and (t1.PaperDate >= @BDateTime)
and (t1.PaperDate <= @EDateTime)
and t2.AftProc >= ''''800''''
and t2.LotNum = t3.LotNum
and t1.finished = 1
and t1.IsCancel = 0
Group By t2.PartNum,t2.Revision
------------------------------------增加仓位字段------------------------------
Exec(''''ALTER TABLE #StknWipTotal add [InWarehouse] int not NULL DEFAULT(0)'''')
---------修改入库数----------
Update t1 Set t1.InWarehouse = isnull(t2.PQnty,0) From #StknWipTotal t1 , #InWarehouse t2
Where t1.Partnum = t2.Partnum
<< 上一页 [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] ... 下一页 >> [Access]sql随机抽取记录 [Access]ASP&SQL让select查询结果随机排序的实现方法 [系统软件]SQL语句性能优化--LECCO SQL Expert [C语言系列]SQL Server到DB2连接服务器的实现 [C语言系列]SQL Server到SYBASE连接服务器的实现 [C语言系列]SQL Server到SQLBASE连接服务器的实现 [C语言系列]SQL Server连接VFP数据库的实现 [C语言系列]ASP+SQL Server之图象数据处理 [C语言系列]SQL Server连接ACCESS数据库的实现 [C语言系列]DBA的最佳选择—图形界面还是T-SQL命令?
|