合计在制品数量*/
Select Partnum, Revision , Qnty = sum(Qnty) ,
DelDate , UPP , ProcCode = Name , Id
Into #Stknwip
From #tmpStknwip
Group By Partnum, Revision , DelDate , UPP , Id , Name
Order By ID
/*判断完整性*/
IF (( Not Exists( Select * from #WeekConfig )) and (Not Exists( Select * from #Stknwip )) )
Begin
Insert Into #Stknwip( Partnum, Revision , Qnty, ProcCode , Id)
Select ''''not data'''' , ''''no'''' , 0 , ProcCode = Name , Id
From PDL_ProcGroup
Insert Into #WeekConfig(PartNum , Revision , Qnty ,WeekDate , Com)
Select ''''not data'''' , ''''no'''' , 0 , @BDateTime, ''''A9''''
End
Else
Begin
IF Not Exists( Select * from #Stknwip )
Insert Into #Stknwip( Partnum, Revision , Qnty, ProcCode , Id)
Select ''''not data'''' , ''''no'''' , 0 , ProcCode = Name , Id
From PDL_ProcGroup
IF Not Exists ( Select * From #WeekConfig )
Insert Into #WeekConfig(PartNum , Revision , Qnty ,WeekDate, Com)
Select Top 1 t1.Partnum, t1.Revision , Qnty = 0 , @BDateTime , ''''A9''''
From Stknwip t1(nolock), LotInfo t2(nolock)
Where t1.LotNum=t2.LotNum &nb << 上一页 [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命令?
|