Is it possible to use CASE with IN?

Posted by dkackman on Stack Overflow See other posts from Stack Overflow or by dkackman
Published on 2010-05-27T19:41:06Z Indexed on 2010/05/27 20:21 UTC
Read the original article Hit count: 194

Filed under:

tsql

|

parameter

|

case

I'm trying to construct a T-SQL statement with a WHERE clause determined by an input parameter. Something like:

SELECT * FROM table
WHERE id IN
CASE WHEN @param THEN
(1,2,4,5,8)
ELSE
(9,7,3)
END

I've tried all combination of moving the IN, CASE etc around that I can think of. Is this (or something like it) possible?

© Stack Overflow or respective owner

Related posts about tsql

TSQL Challenge 30 - A Matrix Transposition challenge in TSQL

as seen on SQL Server Central - Search for 'SQL Server Central'
This is a matrix transposition challenge. Your job is to change the position of the numbres in a 5x5 matrix. SQL Server monitoring made easy "Keeping an eye on our many SQL Server instances is much easier with SQL Response." Mike Lile.Download a free trial of SQL Response… >>> More
Will TSQL become useless because of new ORMs? [closed]

as seen on Programmers - Search for 'Programmers'
By introducing LINQ to SQL, I found myself and my .NET developer colleagues gradually moving from TSQL to C# to create queries on the database. Entity Framework made that shift almost permanent. Now it's nearly 2 years that I use LINQ to SQL and LINQ to Entities and haven't used TSQL that much. Yesterday… >>> More
Issue Creating SQL Login for AppPoolIdentity on Windows Server 2008

as seen on Johnny Coder - Search for 'Johnny Coder'
IIS7 introduced the option to run your application pool as AppPoolIdentity. With the release of IIS7.5, AppPoolIdentity was promoted to the default option. You see this change if you’re running Windows 7 or Windows Server 2008 R2. On my Windows 7 machine, I’m able to define my Application… >>> More
The best, in the West

as seen on Simple Talk - Search for 'Simple Talk'
As many of you know, I run the SQL South West user group and we are currently in full flow preparing to stage the UK’s second SQL Saturday. The SQL Saturday spotlight is going to fall on Exeter in March 2013. We have full-day session on Friday 8th with some truly amazing speakers giving their… >>> More
Something for the weekend - Whats the most complex query?

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Whenever I teach about SQL Server performance tuning I try can get across the message that there is no such thing as a table. Does that sound odd, well it isn't, trust me. Rather than tables you need to consider structures. You have 1. Heaps 2. Indexes (b-trees) Some people split indexes… >>> More

Related posts about parameter

How to associate jquery validation when only one button if there are many??

as seen on Stack Overflow - Search for 'Stack Overflow'
Greetings, In my current project, I have gridview, search button, text box for search, text box, and submit button. -I should input string in the search box then click search button. -when click search button, it will retrieve all matches records then bind them to the view grid. -then when I click… >>> More
How to associate jquery validation with only one button if there are many?

as seen on Stack Overflow - Search for 'Stack Overflow'
Greetings, In my current project, I have gridview, search button, text box for search, text box, and submit button. -I should input string in the search box then click search button. -when click search button, it will retrieve all matches records then bind them to the view grid. -then when I click… >>> More
Mono 2.11 on nginx using fastcgi-mono-server4 will not work

as seen on Server Fault - Search for 'Server Fault'
I have mono 2.11 set up with my nginx 1.0.15 webserver running on centos 6.2. I built it from source and xps2, xps4 and fastcgi-mono-server2 work as expected. The problem is when I try and run fastcgi-mono-server4. When I run: fastcgi-mono-server4 /applications=site:/:/srv/www/html/ /socket=tcp:127… >>> More
ASP.Net How to enforce the HTTP get URL format?

as seen on Stack Overflow - Search for 'Stack Overflow'
[Sorry about a messy question. I believe I am targeting .Net 2.0 (for now)] Hi, I am an ASP.NET noob. For starters I am building a page that parses a URL string and populates a table in a database. I want that string to be strictly of the form: http://<server>:<port>/PageName.aspx?A=1&B=2&C=3&D=4&E=5 The… >>> More
Use a stored procedure parameter for unit parameter of DATE_SUB

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to know if it's possible to pass a parameter to a mysql stored procedure and use this parameter as the unit parameter of the DATE_SUB function. It seems that the unit parameter is a reserved word so I don't know if there's a type for unit. Exemple of what I'm trying to do : DELIMITER… >>> More