Case Statement - 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

Author

Topic

stumbling
Posting Yak Master

104 Posts

Posted - 2008-08-11 : 20:23:09

Hi ALL
can someone tell me why this will not work
Thanx in advance.

CASE
When SELECT LTRIM(RIGHT(CONVERT(VARCHAR(20),min(EV802_BKG_end_Time), 0), 7))FROM EV802_SPACE_BKD
where convert(varchar(12), ev802_bkg_end_date, 103)=(SELECT CONVERT(varchar(12), GETDATE(), 103))
and EV802_SPACE_BKD.EV802_EVT_ID = EV200_EVT_ID
AND EV802_BKG_STATUS = '30' is NULL
Then LTRIM(RIGHT(CONVERT(VARCHAR(20),(EV802_BKG_end_Time), 0), 7))Else '12:00AM'
END,

stumbling
Posting Yak Master

104 Posts

Posted - 2008-08-11 : 22:03:38

I think i got it but feel free to correct me.
Case When CONVERT(VARCHAR(10), EV802_BKG_End_Date, 103) = CONVERT(VARCHAR(10), GETDATE(), 103)Then
(SELECT LTRIM(RIGHT(CONVERT(VARCHAR(20),max(EV802_BKG_end_Time), 0), 7))FROM EV802_SPACE_BKD
where convert(varchar(12), ev802_bkg_end_date, 103)=(SELECT CONVERT(varchar(12), GETDATE(), 103))
and EV802_SPACE_BKD.EV802_EVT_ID = EV200_EVT_ID
AND EV802_BKG_STATUS = '30')
When CONVERT(VARCHAR(10), EV802_BKG_End_Date, 103) = CONVERT(VARCHAR(10), getdate()+1, 103)Then
(SELECT LTRIM(RIGHT(CONVERT(VARCHAR(20),max(EV802_BKG_end_Time), 0), 7))FROM EV802_SPACE_BKD
where convert(varchar(12), ev802_bkg_end_date, 103)=(SELECT CONVERT(varchar(12), GETDATE()+1, 103))
and EV802_SPACE_BKD.EV802_EVT_ID = EV200_EVT_ID
AND EV802_BKG_STATUS = '30')
Else '1:00am'

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-11 : 23:47:24

you're missing an END clause. also why are you using subquery inside case?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources