quote:

---

Originally posted by datachick

I am having issues when trying to run this query. Not sure if it has to do with the Case statement or not.

ERROR MESSAGE:
Msg 245, Level 16, State 1, Line 2
Conversion failed when converting the varchar value 'Age' to data type int.


SELECT table1.CL_ID,
table2.EX_ID,
table1.C_STAT,
table1.C_M_REAS,
table1.CL_R_DT,
table1.PR_ID,
DateDiff(d, table1.CL_R_DT, GETDATE())as Age,
CASE
WHEN 'Age'DateDiff(d, table1.CL_R_DT, GETDATE()) < 11
THEN '00 - 10 Days'
WHEN ('Age' >= 11 AND 'Age' <= 20)DateDiff(d, table1.CL_R_DT, GETDATE()) < 21
THEN '11 - 20 Days'
WHEN ('Age' >= 21 AND 'Age' <= 30)DateDiff(d, table1.CL_R_DT, GETDATE()) < 31
THEN '21 - 30 Days'
ELSE '31+ Days'
END AS 'AgingBucket'
FROM dbo.Table4
INNER JOIN (
dbo.table2 INNER JOIN (
dbo.table1 INNER JOIN dbo.table3 ON dbo.table1.M_CK = dbo.table3.M_CK
) ON dbo.table2.CL_ID = dbo.table1.CL_ID
) ON dbo.Table4.BS_CK= dbo.table1.BS_CK
WHERE (
((dbo.table1.C_STAT) IN
('01','11','15'))
AND
((dbo.table1.PR_ID) IN
('1078910','1545410', '1243547','0085410')
AND((dbo.table2.ID_OR) = 'PD')
AND ((dbo.table1.RG_CK) = 33568)
AND ((dbo.table3.RG_CK) = 33568)
AND ((dbo.Table4.RG_CK) = 33568)
GROUP BY table1.CL_ID,
table2.EX_ID,
table1.C_STAT,
table1.C_M_REAS,
table1.CL_R_DT,
table1.PR_ID,
DateDiff(d, table1.CL_R_DT, GETDATE())as Age

---