Search results
15 mar 2013 · Starting with SQL Server 2022 you can use the IS [NOT] DISTINCT FROM predicate (see here) and you could re-write the OP's statement like so: SELECT first_name + CASE when last_name is not distinct from null THEN '' ELSE ' ' + last_name END AS Name FROM dbo.person
26 lip 2013 · select distinct b.[id], max(a.[start date]), b.[stat], c.[post date], case when (c.[post date] between c.[event date]+10 and c.[event date]+30) then 'good' end as [better visit], case when b.[stat] is null then (c.[event date]+10) else '-' end as [date] from #temp1 a full outer join #temp2 b on a.[id]=b.[id] full outer join #temp3 c on a.[id]=c ...
29 sty 2016 · It seems like in each case when the divisor is zero, the OP is happy to store NULL. With this in mind, you could avoid the extra checks for 0 in your CASEs if you used this trick to avoid division by zero: A / NULLIF(B, 0) .
11 lip 2012 · Is there any better way to write the lines below in SQL Server 2005? CASE WHEN (ID IS NULL) THEN 'YES' WHEN (ID IS NOT NULL) THEN 'NO' END AS ID_Value, sql-server
CASE can be used in any statement or clause that allows a valid expression. For example, you can use CASE in statements such as SELECT, UPDATE, DELETE and SET, and in clauses such as <select_list>, IN, WHERE, ORDER BY, and HAVING. Transact-SQL syntax conventions.
According to the above, another way to solve it would be to change the expressions to comply with how SQL-Server executes the CASE and all 10 cases have the same probability:
The SQL CASE Expression. The CASEexpression goes through conditions and returns a value when the first condition is met (like an if-then-else statement). So, once a condition is true, it will stop reading and return the result. If no conditions are true, it returns the value in the ELSEclause.
