0.00.0100005050NY50000YN1000100-2019/07/17 16:55:33.177-2019/07/17 16:55:33.177H4sIAAAAAAAAAAMAAAAAAAAAAAA=Nmall192.168.50.32MSSQLNATIVENativeMall1433saEncrypted 2be98afc86aa7f297aa15a478c7d38f99FORCE_IDENTIFIERS_TO_LOWERCASENFORCE_IDENTIFIERS_TO_UPPERCASENINITIAL_POOL_SIZE30IS_CLUSTEREDNMAXIMUM_POOL_SIZE1000MSSQLUseIntegratedSecurityfalseMSSQL_DOUBLE_DECIMAL_SEPARATORNPORT_NUMBER1433PRESERVE_RESERVED_WORD_CASEYQUOTE_ALL_FIELDSNSUPPORTS_BOOLEAN_DATA_TYPEYSUPPORTS_TIMESTAMP_DATA_TYPEYUSE_POOLINGY表输入 2复制记录到结果 2Y复制记录到结果 2RowsToResultY1none32096Y表输入 2TableInputY1nonemallselect (
SELECT count(1)/50 as count1
FROM Orders a
where 1=1 and (AconsigneePhone1!='' and AconsigneePhone1 is not null)
and OrderTime > '2019-05-01 00:00:01'
--and datediff(day,DATEADD(d,0,DATEDIFF(d,0,getdate())-90),OrderTime )>0
) as count1,
(SELECT count(1)/50 as count2
FROM Orders a
where 1=1 and (AconsigneePhone2!='' and AconsigneePhone2 is not null)
and OrderTime > '2019-05-01 00:00:01'
--and datediff(day,DATEADD(d,0,DATEDIFF(d,0,getdate())-90),OrderTime )>0
) as count2,
(SELECT count(1)/50 as count3
FROM Orders a
where 1=1 and (AconsigneePhone3!='' and AconsigneePhone3 is not null)
and OrderTime > '2019-05-01 00:00:01'
--and datediff(day,DATEADD(d,0,DATEDIFF(d,0,getdate())-90),OrderTime )>0
) as count30NNN11280YN