Case Statement Trouble - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Case Statement Trouble

Author

Topic

werhardt
Constraint Violating Yak Guru

270 Posts

Posted - 2009-08-25 : 12:50:37

I have this case statement below and I would like to label it as TAT Details, but for some reason it will not let me. The label that is coming out is.....
"DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10), hst_back, 110))"

How can I change that in this statement below?

"DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10), hst_back, 110))" =

Case
WHEN DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10), hst_back, 110)) >='0' and DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10), hst_back, 110)) <= '1' THEN 'A: Equal to 1 Day'

WHEN DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10), hst_back, 110)) > '1' and DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10),hst_back, 110)) <= '3' THEN 'B: Greater than 1 day to 3 Days'
WHEN DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10), hst_back, 110)) > '3' and DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10), hst_back, 110)) <= '5' THEN 'C: Greater than 3 day to 5 Days'
WHEN DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10), hst_back, 110)) > '5' and DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10), hst_back, 110)) <= '10' THEN 'D: Greater than 5 day to 10 Days'
WHEN DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10), hst_back, 110)) > '10' THEN 'G: Greater than 10 Days'
end

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-08-25 : 12:57:32

~~"DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10), hst_back, 110))" =~~

Case
WHEN DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10), hst_back, 110)) >='0' and DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10), hst_back, 110)) <= '1' THEN 'A: Equal to 1 Day'

WHEN DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10), hst_back, 110)) > '1' and DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10),hst_back, 110)) <= '3' THEN 'B: Greater than 1 day to 3 Days'
WHEN DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10), hst_back, 110)) > '3' and DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10), hst_back, 110)) <= '5' THEN 'C: Greater than 3 day to 5 Days'
WHEN DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10), hst_back, 110)) > '5' and DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10), hst_back, 110)) <= '10' THEN 'D: Greater than 5 day to 10 Days'
WHEN DATEDIFF(day, CONVERT(CHAR(10), hst_epis, 110), CONVERT(CHAR(10), hst_back, 110)) > '10' THEN 'G: Greater than 10 Days'
end as [wanted label here]

No, you're never too old to Yak'n'Roll if you're too young to die.