Listing 1: Code to create temporary table


CREATE TABLE #tmpTable
(record_num int identity,DAY1 smalldatetime,DAY2 smalldatetime)

INSERT INTO #tmpTable VALUES('01/17/2006','01/20/2006')
INSERT INTO #tmpTable VALUES ('01/10/2006','01/20/2006')
INSERT INTO #tmpTable VALUES('01/7/2006','01/29/2006')
INSERT INTO #tmpTable VALUES('01/8/2006','01/28/2006')
INSERT INTO #tmpTable VALUES('01/31/2006','02/19/2006')
INSERT INTO #tmpTable VALUES('02/02/2006','03/20/2006')
INSERT INTO #tmpTable VALUES('02/27/2006','04/22/2006')
INSERT INTO #tmpTable VALUES('04/17/2006','04/20/2006')
INSERT INTO #tmpTable VALUES('04/18/2006','04/19/2006')

SELECT * FROM #tmpTable