Hi -
I have two queries that I'm looking to rewrite into one but not that good with sql.
Ideally what I am looking for would be an out put like
pastDueRepl | pastDueInsp
46----------- 65
here are the two queries
SELECT
count(*) as pastDueRepl
FROM TBLPTS_APPDATA
WHERE APPV_PTSSTATUS = '2'
AND (APPD_NEXTREPLDATE IS NOT NULL)
AND APPD_NEXTINSPDATE between DATEADD(Day,-30,GETDATE()) and GETDATE()
SELECT
count(*) as pastDueInsp
FROM TBLPTS_APPDATA
WHERE APPV_PTSSTATUS = '2'
AND (APPD_NEXTINSPDATE IS NOT NULL)
AND APPD_NEXTINSPDATE between DATEADD(Day,-30,GETDATE()) and GETDATE()
Thanks