You can also write this without the case statement. Another option is dynamic SQL, where you actually create a string with the SQL statement and then execute it. However, dynamic SQL seems like overkill in this case.

Oct 18, 2009 · SELECT col1 as a, CASE WHEN a = 'test' THEN 'yes' END as value FROM table; I am trying to alias the column because actually my CASE statement would be generated programmatically, and I want the column that the case statement uses to be specified in the SQL instead of having to pass another parameter to the program.

Oct 9, 2013 · According to my Scenario, I did "use CASE statement in WHERE IN clause" like following @AdjType varchar(20) = 'Value', @Base varchar(20) = 'Common' where (select CASE WHEN SA.IsPersentage = 0 THEN 'Value' WHEN SA.IsPersentage = 1 THEN 'Presentage' END) Like @AdjType and (Select CASE WHEN SA.IsDependOnBasicSalary = 0 THEN …

Sep 15, 2008 · Both IIF() and CASE resolve as expressions within a SQL statement and can only be used in well-defined places. The CASE expression cannot be used to control the flow of execution of Transact-SQL statements, statement blocks, …

Apr 26, 2014 · I'm not sure what you want to do with the statement. In a select statement, it would be: SELECT (CASE WHEN (condition1 = 1 or 2) AND condition2 = 3 THEN 'Result' END) as result You don't need the else because NULL is returned by the statement automatically if none of the when conditions are met. In a where, it would be:

Apr 14, 2012 · Assuming SQL Server: You would need to use dynamic SQL. Build the string and then call sp_executesql with the string. Edit: Better yet, just use if statements to execute the appropriate statement and assign the value to a variable. You should avoid dynamic SQL if …

Dec 15, 2015 · This is also an alternate use of case-when... UPDATE [dbo].[JobTemplates] SET [CycleId] = CASE [Id] WHEN 1376 THEN 44 --ACE1 FX1 WHEN 1385 THEN 44 --ACE1 FX2 WHEN 1574 THEN 43 --ACE1 ELEM1 WHEN 1576 THEN 43 --ACE1 ELEM2 WHEN 1581 THEN 41 --ACE1 FS1 WHEN 1585 THEN 42 --ACE1 HS1 WHEN 1588 THEN 43 --ACE1 RS1 WHEN 1589 THEN 44 --ACE1 RM1 WHEN 1590 THEN 43 --ACE1 ELEM3 WHEN 1591 THEN 43 - …

Feb 9, 2010 · Is it possible to use case statement within an update query? I need to do something like this: If person name starts with 'S' then append '1', else append '2'. I tried this in sql server and it di...

Nov 27, 2013 · As stated by the question, I'm trying to formulate a query that has a case statement in the column results, and then I want to include that column in the query's group by statement. To give a concrete example, here is all little of what my query looks like:

What I'm trying to do is use more than one CASE WHEN condition for the same column. Here is my code for the query: SELECT Url='', p.ArtNo, p.[Description], p.Specification, CASE WHEN 1 = 1 or 1 = 1 THEN 1 ELSE 0 END as Qty, p.NetPrice, [Status] = 0 FROM Product p (NOLOCK)