ByronOne (9/17/2012)

---

Hi Sean

Thanks for getting back to me and I hope you'll be able to help.

Ok, here is the DDL you were looking for:

IF OBJECT_ID('TempDB..#MyTable') IS NOT NULL

BEGIN

DROP TABLE #MyTable

END

CREATE TABLE [dbo].[#MyTable]

(

[WeekEndDate] [date] NULL,

[site] [varchar](5) NULL,

[ItemDescription] [varchar](75) NULL,

[PlanItemsSold] [int] NULL,

[ActualItemsSold] [int] NULL

)

SET IDENTITY_INSERT #mytable ON

--===== Insert the test data into the test table

INSERT INTO #MyTable (WeekEndDate, [site], ItemDescription, PlanItemsSold, ActualItemsSold)

SELECT 'Aug 12 2012 12:00AM', 'Central', 'Item1', '10', '7'

UNION ALL SELECT 'Aug 12 2012 12:00AM', 'Central', 'Item2', '5', '3'

UNION ALL SELECT 'Aug 12 2012 12:00AM', 'Central', 'Item3', '21', '7'

UNION ALL SELECT 'Aug 12 2012 12:00AM', 'South', 'Item1', '14', '3'

UNION ALL SELECT 'Aug 12 2012 12:00AM', 'West', 'Item2', '11', '7'

UNION ALL SELECT 'Aug 19 2012 12:00AM', 'West', 'Item1', '17', '9'

UNION ALL SELECT 'Aug 19 2012 12:00AM', 'North', 'Item1', '21', '32'

UNION ALL SELECT 'Aug 19 2012 12:00AM', 'East', 'Item1', '13', '19'

--===== Set the identity insert back to normal

SET IDENTITY_INSERT #MyTable OFF