Hi everybody,
Is there a DO CASE equavalent in Transact-SQL for procedural code, e.g.
CASE @PersonType = ' '
One select statement
case ...
Different select statement
etc.
Thanks in advance.
Creating different strings and using sp_executesql doesn't sound like a good approach to me. I'm guessing I need to use IF statements since there seems to be no CASE alternative for procedural code in T-SQL.
If it's not broken, fix it until it is.
My Blog