Welcome to
Sign in
|
Help
Search
Home
Blogs
External Feeds
Forums
Photos
Downloads
About Us
»
Romanian Section
»
Intrebari
»
T-SQL
»
CASE in WHERE
CASE in WHERE
07-03-2008, 10:51 AM
ssandu
Joined on 04-27-2006
db_owner
CASE in WHERE
Reply
Quote
Cum pot sa fac urmatorul select (acum da eroare)
SELECT * from tabel
WHERE utilizator IN
CASE
WHEN USER_NAME() = 'user1' THEN ('user1', 'user2')
WHEN USER_NAME() = 'user3' THEN ('user3', 'user2')
DEFAULT USER_NAME()
END
Se poate ?
Sorin Sandu
Report abuse
View Complete Thread