>>>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.
>>
>>No. T-SQL CASE is used in a select statement to conditionally evaluate field results.
>>
>>IF..ELSE is ugly but it does work.
>
>Yes, I see that I don't have other choice except for creating multiple SPs for each type. I'm wondering which way would be better. From code maintenance point of view one procedure is definitely better.
What's wrong with one SP. You always can use structure like this:
IF @Something1
BEGIN
END
ELSE IF @Something2
BEGIN
END
ELSE IF @Something3
BEGIN
END
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.