using access query into sql view HELP!

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 1

There is no immediate if statement in TSQL. You'll need to create some other mechanism, probably a CASE statement to get the same effect.

SELECT CASE WHEN CurrentSickTerm= 'LT'

THEN 'Long Term'

ELSE 'Short Term' END AS ColumnName

FROM dbo.ViewName

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

ritesh-385882 Mr or Mrs. 500 Points: 533 More actions · Answer 2

this works but i need to add another condition !

SELECT CASE WHEN CurrentSickTerm= 'LT'THEN 'Long Term' ELSE if CurrentSickTerm= 'ST'THEN 'Short Term' else 'NULL' END AS ColumnNameFROM dbo.ViewName

This does not work I need another way to write this

Thanks Ritz

jfmccabe SSCrazy Points: 2547 More actions · Answer 3

Check BOl for the CASE syntax. Try:

SELECT

CASE CurrentSickTerm

WHEN 'LT' THEN 'Long Term'

WHEN 'ST' THEN 'Short Term'

WHEN 'MT' THEN 'Medium Term'

ELSE 'Healthy'

END AS SickTerm

FROM dbo.ViewName