23 lines
1.4 KiB
Transact-SQL
23 lines
1.4 KiB
Transact-SQL
/****** Script for SelectTopNRows command from SSMS ******/
|
||
|
||
---待分播亮灯
|
||
|
||
SELECT *
|
||
FROM [wmsuzhou2].[dbo].[v_stockSeedsDeskLight] where flowno ='55550'
|
||
order by lightid
|
||
|
||
|
||
SELECT * FROM t_wmsInRequestDetail a where 1=1
|
||
and preinorder='PE250960363035500'--'PE2509R08RJ035619'
|
||
--and STATE = 10
|
||
|
||
and isnull( lastmodified,createtime) +5 > getdate()
|
||
and not exists(select 1 from t_wmsInUpPort where orderno =a.preInOrder and state =1)
|
||
|
||
|
||
select * from v_tmsPickrequest where transno ='TR2509C13CS007458' and customerName='四明店' order by id desc
|
||
|
||
select * from v_tmsTranReqest where viechleno='000'
|
||
--and transno='TR2509C13CS007458'
|
||
|
||
order by id desc |