Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Case Then Multiple results

Author  Topic 

masteripper
Starting Member

25 Posts

Posted - 2009-07-22 : 01:27:28
Hello to everybody.I hope i wrote the subject but here is what i need ...if it can been done.
In the normal Case we have
CASE.....WHEN....THEN Result
is it possible and logical to have something like
CASE.....WHEN....THEN Result1,Result2
I hope it is not too dumb as a question

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-07-22 : 01:40:53
no. you can't do that. Case when can only return 1 value


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

masteripper
Starting Member

25 Posts

Posted - 2009-07-22 : 02:55:01
Well i knew it but there is always a 'maybe'.
Thanks anyway.
Any idea how i could do something like that
Go to Top of Page
   

- Advertisement -