Conditional Returns in SQL 1

[hegartyjp]

Hi,

Would really appreciate some help with this query. I am moving an access database on to SQL Server and need to reproduce some reports.

The reports are mostly based on Bands that are created during running the query behind the report.


So if the field being reported was value and the bands are 1-29, 30 - 60, and >60,

The query uses a simple IIF statement in Access but I can not figure out how to do this in a stored procedure.

i.e

BAND: Iif (value < 30, "BAND A", Iif( value < 61, "BAND B", BANDC)))

Is this sort of thing possible in a stored procedure or do I need to make a table and update it or something?

Any advice greatly appreciated.

Thanks

JP

 

[ca8msm]

You can use the CASE statement e.g.

case when band > 60 then ...

[!]
-------------------------------------------------------

Mark,

Join me at the new IT Community of the 21st Century: [!][URL unfurl="true"]http://lessthandot.com[/!][/url]

[/!]

 

[hegartyjp]

Oh cheers mate. As easy as that.

Really do appreciate it.

Exactly what I need.

Thanks

JP