Link to home
Start Free TrialLog in
Avatar of plucenko
plucenkoFlag for Afghanistan

asked on

SQL Parameter group by 30,60,90 120 days...

How would I implement this with Parameters where the query set the date, and 30,60,90 and 120 are parameters that would have to go off of the date set by the query?


select Billing.Bill.AccountNo,
       sum(case when DATEDIFF(DD, Billing.Bill.DueDate, GETDATE()) < 30 then Billing.Bill.CurrAmt else 0 end) ['0 - 30'],
       sum(case when DATEDIFF(DD, Billing.Bill.DueDate, GETDATE()) > 30 and DATEDIFF(DD, Billing.Bill.DueDate, GETDATE()) < 60 then Billing.Bill.CurrAmt else 0 end) ['31 - 60'],
       sum(case when DATEDIFF(DD, Billing.Bill.DueDate, GETDATE()) > 60 and DATEDIFF(DD, Billing.Bill.DueDate, GETDATE()) < 90 then Billing.Bill.CurrAmt else 0 end) ['61 - 90'],
       sum(case when DATEDIFF(DD, Billing.Bill.DueDate, GETDATE()) > 90 and DATEDIFF(DD, Billing.Bill.DueDate, GETDATE()) < 120 then Billing.Bill.CurrAmt else 0 end) ['91 - 120'],      
       sum(case when DATEDIFF(DD, Billing.Bill.DueDate, GETDATE()) > 120 then Billing.Bill.CurrAmt else 0 end) ['Over 120']
from Billing.Bill
group by Billing.Bill.AccountNo
ASKER CERTIFIED SOLUTION
Avatar of kmslogic
kmslogic
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial