I am trying to combine 2 big SQL queries into one datatable, so I can load it on the webpage.
Query #1:
select
isnull(SALES_NUM4, '') SalesNo,
count(CUS_ID) NumOfCust,
count(distinct sales_num) NumOfRep
from
(select
SALES_NUM4, CUS_ID, SLS_TYPE, SALES_NUM
from customer
union
select
SALES_NUM4, CUS_ID, SLS_TYPE, SALES_NUM
from omsdata7.dbo.customer) a
where
SALES_NUM4 != '' and SLS_TYPE = '1'
group by
SALES_NUM4
order by
SALES_NUM4
Query #2:
select
isnull(SALES_NUM4, '') SalesNo,
count(ORD_NUM) MTD_Ord,
convert(decimal(10, 2), sum(ORD_AMT)) MTD_Amt
from
(select
SALES_NUM4, ORD_DT, ORD_NUM, ORD_AMT
from orders
union
select
SALES_NUM4, ORD_DT, ORD_NUM, ORD_AMT
from omsdata7.dbo.orders) a
where
DATEADD(day, ORD_DT-4, '1801-01-01') >= DATEADD(m, DATEDIFF(m, 0, GETDATE()), 0)
and DATEADD(day, ORD_DT-4, '1801-01-01') < getdate()
and SALES_NUM4 != ''
group by
SALES_NUM4
order by
SALES_NUM4
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire