sql

select TableVar from ACC_eLogistics..ACCfn_split('0371,021',',')


select (stuff((select distinct ',' + TableVar from (
                                                   select TableVar from ACC_eLogistics..ACCfn_split('0371,021',',') 
                                                   ) as ee  for xml path('')),1,1,''))

 

select (stuff((select distinct ',' + TableVar from (
                                                   select ''''+TableVar+'''' as TableVar from ACC_eLogistics..ACCfn_split('0371,021',',') 
                                                   ) as ee  for xml path('')),1,1,''))

 2019-05-24 00:00:00.000

2019-06-22 00:00:00.000

 

select SerialNumber from tms_SODTermDetail 
inner join tms_SOHead on tms_SOHead.SONumber=tms_SODTermDetail.DeliveryNumber
where convert(datetime,convert(varchar(10),tms_SODTermDetail.CreateDateTime,120)) between dateadd(day,-8,convert(datetime,'2019'+'-'+'6'+'-'+'1',120)) and dateadd(day,-9,dateadd(month,1,convert(datetime,'2019'+'-'+'6'+'-'+'1',120))) 
AND 
tms_SOHead.CarrierCode in (
                                select * from ACC_eLogistics..ACCfn_split(@Carrier,',')
                                                   
                          )


--    select SerialNumber from tms_SODTermDetail 
--inner join tms_SOHead on tms_SOHead.SONumber=tms_SODTermDetail.DeliveryNumber
--where convert(datetime,convert(varchar(10),tms_SODTermDetail.CreateDateTime,120)) between dateadd(day,-8,convert(datetime,'2019'+'-'+'6'+'-'+'1',120)) and dateadd(day,-9,dateadd(month,1,convert(datetime,'2019'+'-'+'6'+'-'+'1',120))) 
--AND 
--tms_SOHead.CarrierCode in ('021','0371')


--select (stuff((select distinct ',' + TableVar from (
--                                                   select TableVar as TableVar from ACC_eLogistics..ACCfn_split('0371,021',',') 
--                                                   ) as ee  for xml path('')),1,1,''))

 

转载于:https://www.cnblogs.com/ZkbFighting/p/11442564.html