Case statement

Anonymous — Tue, 10 Feb 2015 12:47:38 GMT

Hi guys,

I have a case statement in SQL

sum(CASE WHEN datediff(dd,due_date,getdate()) < = '0' then T1.unall_amount end) as 'Current',

sum(CASE WHEN datediff(dd,due_date,getdate()) between '1' and '30' then T1.unall_amount end) as '0-30',

sum(CASE WHEN datediff(dd,due_date,getdate()) between '31' and '60' then T1.unall_amount end) as '31-60',

sum(CASE WHEN datediff(dd,due_date,getdate()) between '61' and '90' then T1.unall_amount end) as '61-90',

sum(CASE WHEN datediff(dd,due_date,getdate()) between '91' and '120' then T1.unall_amount end) as '91-120',

sum(CASE WHEN datediff(dd,due_date,getdate()) >= '121' then T1.unall_amount end) as '121+'

Can this be done via the QV load script or as an expression?

It might be easier to load this in via a SQL statement..

Thanks

Re: Case statement

Peter_Cammaert — Tue, 10 Feb 2015 15:11:19 GMT

Duplicate discussion here: Case statement