Sql Syntax conversion for a report formula 1

[Jcfx]

I am converting some crystal reports over to reporting services and have to have some of the formulas results done on the sql side.

what would be my syntax for the following conditional statement?
//@Location
if {stops.stp_event} = "LLD" and {stops.stp_status} = "OPN" then "On Way"
Else
if {stops.stp_event} = "LLD" and {stops.stp_status} = "DNE" then "Romulus"
Else
if {stops.stp_event} = "HCT" and {stops.stp_status} = "DNE" then "Woodstock"


Thank you






Julie
CRXI CE10 / RS2005 Sql DB

 

[sunila7]

Take a look at CASE statement in Books Online. Here is a link on msdn.

http://msdn2.microsoft.com/en-us/library/aa258235(sql.80).aspx

The query would look like this

SELECT 
CASE 
WHEN stops.stp_event = 'LLD' and stops.stp_status = 'OPN' then 'On Way'
WHEN stops.stp_event = 'LLD' and stops.stp_status = 'DNE' then 'Romulus'
WHEN stops.stp_event = 'HCT' and stops.stp_status = 'DNE' then 'Woodstock'
END
FROM TBL

Sunil

 

[Jcfx]

Thank you

I've seen a couple different ways to format case and wasnt sure of the standard.

Appreciate the assistance.

Julie
CRXI CE10 / RS2005 Sql DB