Search results
You can do CASE with many WHEN as; CASE WHEN Col1 = 1 OR Col3 = 1 THEN 1 WHEN Col1 = 2 THEN 2 ... ELSE 0 END as Qty Or a Simple CASE expression. CASE Col1 WHEN 1 THEN 11 WHEN 2 THEN 21 ELSE 13 END Or CASE within CASE as; CASE WHEN Col1 < 2 THEN CASE Col2 WHEN 'X' THEN 10 ELSE 11 END WHEN Col1 = 2 THEN 2 ...
30 mar 2023 · In SQL Server, there are 3 main ways to use CASE with multiple WHEN conditions: 1. Use CASE WHEN with multiple conditions. You can use the SQL CASE WHEN statement for multiple conditions by chaining additional WHEN clauses separated by spaces or newlines.
22 lis 2016 · Here is the example of my query: SELECT ActivityID, Hours = (CASE WHEN ActivityTypeID <> 2 THEN FieldName = (Some Aggregate Sub Query), FieldName2 = (Some other aggregate sub query) WHEN ActivityTypeID = 2 THEN FieldName = (Some Aggregate Sub Query with diff result), FieldName2 = (Some Other Aggregate Sub Query with diff result) END)
3 wrz 2024 · Evaluates a list of conditions and returns one of multiple possible result expressions. The CASE expression has two formats: The simple CASE expression compares an expression to a set of simple expressions to determine the result. The searched CASE expression evaluates a set of Boolean expressions to determine the result.
12 lis 2014 · I need to change returned value, from select statement, based on several conditions. I tried something like that: ,CASE i.DocValue. WHEN 'F2' AND c.CondCode IN ('ZPR0','ZT10','Z305') THEN c.CondVal. ELSE 0.
SQL Server CASE expression evaluates a list of conditions and returns one of the multiple specified results. The CASE expression has two formats: simple CASE expression and searched CASE expression. Both of CASE expression formats support an optional ELSE statement.
26 cze 2023 · You can combine multiple conditions with a nested CASE statement in the WHERE clause. For example, we want records from the [SalesOrderHeader] table where the orderdate is between specified dates. If this condition is satisfied, check for orders with a value 1 for column [OnlineOrderFlag]: