Monthly Archives: November 2014

Be careful with CASE and NULL statement

Checking NULL values in database can be a little tricky. It is very easy to trickle those if you do not provide correct syntax. The recommend way to check null is ISNULL(myfieldname,”). When using NULL in case statement, it might … Continue reading

Posted in Tutorials/Tips | Tagged , , | Leave a comment

How to create dates reference table in SQL

I needed to create date reerences as needed in my sql report. I stumbled upon this link which create dates in sql on the fly but there was a typo because of which my function did not run. The following … Continue reading

Posted in Uncategorized | Leave a comment