Search results
17 lis 2015 · I am running a SELECT on two tables. I'll simplify it to the part where I'm having trouble. I need to modify the SELECT results to a certain format for a data import. My CASE statement works fine until I get to the point that I need to base the WHEN ... THEN... on a different table column.
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.
20 paź 2017 · If they are all different tables then this may be your best case scenario. UNLESS Table1.column1 values can be repeated (multiple rows='1', etc). In that case you may want to move from subqueries to joins.
You can use below example of case when with multiple conditions. SELECT id,stud_name, CASE WHEN marks <= 40 THEN 'Bad' WHEN (marks >= 40 AND marks <= 100) THEN 'good' ELSE 'best' END AS Grade FROM 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.
23 sie 2024 · Multiple CASE WHEN statements allow you to implement conditional logic in SQL queries, allowing for the evaluation of multiple conditions and the execution of different actions based on those conditions. Here is the basic syntax of a Multiple CASE WHEN statement:
In the T-SQL scripting language, you can use the SQL CASE statement to evaluate a condition and return one or more result expressions. This SQL Tutorial will teach you when and how you can use CASE in T-SQL statements.
