He had 2 SPs originally and wanted to combine them. I'll tell he needs to keep it as two separate entities.

Thanks.

>>Hi everybody,
>>
>>I beleive this is impossible to have something like this
>>
>>select ..., CASE When SomeCondition THEN some complex programming logic ... etc.
>>
>>Here is the query that someone tries and it looks to me like a completely wrong, but is it possible to somehow solve this?
>>