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.
| Author |
Topic |
|
craigmacca
Posting Yak Master
142 Posts |
 Posted - 2011-06-16 : 08:05:05
|
| Hi i need to check if a Id is in a list of Ids, not sure how to do this??DECLARE @SelectedList nvarchar(100)set @SelectedList = '13, 17'SELECTCASE WHEN t.Id IN @SelectedList THEN 1ELSE 0ENDAS IsOpen |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-06-16 : 08:23:37
|
| try using thisDECLARE @A TABLE (COL INT)INSERT INTO @A SELECT 13INSERT INTO @A SELECT 17SELECTCASE WHEN t.Id IN (SELECT COL FROM @A) THEN1ELSE 0ENDAS IsOpen |
 |
|
|
|
|
|
select in list