May 5, 2017 · Hi Friends, I am trying to wirte a filter condition in WHERE clause like CASE WHEN GETDATE () = 'first of this month' THEN 'DATE column' between 'first day of last month' and …

Feb 19, 2021 · I want to update the contents of a variable using a CASE Statement; for example: I declare the variable and set the initial value, then I want to use a CASE Statement to append …

Oct 20, 2022 · Home Forums SQL Server 2012 SQL Server 2012 - T-SQL How to put a case statement in a where clause Post reply

Jan 8, 2018 · If i comment out the case statement in this query, it takes less than a second. With the case statement, it takes almost a minute. Any ideas?

Oct 15, 2009 · Hi, I've a query that I'd like to order by 14 different clauses, so I send a variable @order and use the ORDER BY with a CASE clause: DECLARE @order INT= 1 SELECT …

Mar 25, 2004 · Hi, I want to use CASE statement in FROM clause, for example DECLARE @I INT SET @I = 1 SELECT * FROM TABLE_A A, CASE WHEN @I = 1 THEN TABLE_B ELSE …

Mar 22, 2021 · Also, there is no CASE statement in SQL! In this language, CASE is an expression; expressions return a single value of a known data type, I would assume you want …

May 8, 2012 · How is it possible to use WHEN EXISTS inside a CASE Statement? Currently I am using SELECT TOP 1 as per code below but the query is taking some time to run and wonder …

May 1, 2012 · Hi, I've created a query that, because of the last 3 items in the select statement (canceled date, new order status and disbactiondate), returns every file in the system. When …

Apr 7, 2022 · Home Forums SQL Server 2019 SQL Server 2019 - Development Having a case or if statement in where clause on Max Date Post reply