smalldatetime – Tarik Billa

check for null date in CASE statement, where have I gone wrong?

August 5, 2023 by Tarik

Try: select id, StartDate, CASE WHEN StartDate IS NULL THEN ‘Awaiting’ ELSE ‘Approved’ END AS StartDateStatus FROM myTable You code would have been doing a When StartDate = NULL, I think. NULL is never equal to NULL (as NULL is the absence of a value). NULL is also never not equal to NULL. The syntax … Read more

How to select data from 30 days?

May 11, 2023 by Tarik

You should be using DATEADD is Sql server so if try this simple select you will see the affect Select DATEADD(Month, -1, getdate()) Result 2013-04-20 14:08:07.177 in your case try this query SELECT name FROM ( SELECT name FROM Hist_answer WHERE id_city=’34324′ AND datetime >= DATEADD(month,-1,GETDATE()) UNION ALL SELECT name FROM Hist_internet WHERE id_city=’34324′ AND … Read more