Calculating Running Totals in SQL Server: A Step-by-Step Guide

Automating Unique Auto-Increment Values in SQL Server Using Stored Procedures, Table-Valued Functions, and Common Table Expressions

Finding Equal Row Sets Across Different Tables in SQL Server Using the FOR XML Trick or Alternative Approaches

Inserting Data from a Subquery into a New Table Using the INSERT INTO SELECT Statement