A CTE or Common Table Expression specifies a tempoary named result set for the current session, a …

Sometimes you will come across a dataset that contains two or more rows of the same data, in a data …

In SQL Server it is possible to insert data from one table into another using a select within the …

Recently I needed to export some data from a table that was being used to hold information from a …

Contents Part One – Project Overview Part Two – Database Schema Part Three – Stored Procedures …