Patient Count CTE - Cacher Snippet

9/25/2016 - 1:11 AM

Patient Count CTE

Patient Count CTE

Patient CTE.sql

WITH NEW_PT_CTE
AS
(
select count(distinct orderid) New
from orderitems
where description like '%92004%'
and orderitemsdate between @DateFrom and @DateTo
),
EST_PT_CTE
AS 
(
select count(distinct orderid) New
from orderitems
where description like '%92014%'
and orderitemsdate between @DateFrom and @DateTo
)
SELECT * FROM NEW_PT_CTE, EST_PT_CTE