SQL Server 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