SQL 8
- Simple Common table expression using WITH keyword Mar 1, 2016
- Dynamic PIVOT query Mar 1, 2016
- Using NULLIF function Feb 1, 2016
- Generate sequential number using row_number function May 1, 2015
- Insert results of stored procedure into a temporary table Apr 12, 2014
- Insert with EXISTS condition Mar 15, 2014
- Using COALESCE Apr 5, 2012
- Update with transaction and error handling Jun 1, 2011