How do I do multiple CASE WHEN conditions using SQL Server 2008? Asked 12 years, 10 months ago Modified 3 years, 5 months ago Viewed 1.7m times

Oct 20, 2017 · The key is that the CASE expression is only ever going to return 3 (or 30) unique values if it finds a match. You can save off the results into local variables and just use those in the query.

Nov 12, 2014 · There are two types of CASE statement, SIMPLE and SEARCHED. You cannot evaluate multiple expressions in a Simple case expression, which is what you were attempting to do.

Sep 16, 2011 · 3 The question is specific to SQL Server, but I would like to extend Martin Smith's answer. SQL:2003 standard allows to define multiple values for simple case expression:

Nov 6, 2020 · Here UserFlag, QtyAvailable and OrderStatus are three different columns and Im trying to create a two additional columns named "BackOrder Status" and "Shipped …

I'm writing an SQL Query, where a few of the columns returned need to be calculated depending on quite a lot of conditions. I'm currently using nested case statements, but its getting messy. Is th...

Nov 22, 2016 · ( SELECT CASE WHEN 1 = 1 THEN '2%3' END MergedColumns ) AS MyCase ON 1 = 1 This will insert the values (1, 2, 3) for each record in the table T1. This uses a delimiter '%' to split …

Aug 7, 2008 · Link: CASE (Transact-SQL) Also note that the ordering of the WHEN statements is important. You can easily write multiple WHEN clauses that overlap, and the first one that matches is …

Aug 22, 2018 · Can you please tell me if SQL code below makes sense. I am using multiple ANDs and OR in CASE WHEN. Thanks for your help! SELECT id, period, CASE WHEN state = 'group8' AND …

Following on from my earlier question here Case statement for Order By clause with Desc/Asc sort I have a statement like this: SELECT * FROM TableName WHERE ORDER BY CASE @OrderByCol...