RE: Query Help - difference between last and current year

SSC Guru

Points: 90252

February 11, 2010 at 3:21 pm

On the query I provided, did you change the table reference back to your original table? I modified it to use a temp table instead. Here is the full sample:

Drop Table #dim1;

--create

CREATE TABLE [dbo].[#dim1](

[varchar](5) NULL,

[DATE] [datetime] NULL,

[ACCOUNT_NO] [char](10) NULL,

[FILTER_CODE] [varchar](50) NULL,

[SRC] [varchar](50) NULL

)

--insert

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 20 2010 10:20AM', 'SS10000623', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 1 2010 6:47PM', 'SS10000010', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 20 2010 4:19PM', 'SS10000472', '2M', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 2 2010 2:06PM', 'AS10000046', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 7:42AM', 'AS10000676', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 9:17AM', 'AS10000683', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 1 2010 6:47PM', 'SS10000010', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 20 2010 10:20AM', 'SS10000623', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 2:00AM', 'AS10000003', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 4:35PM', 'AS10000017', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 10:32PM', 'AS10000034', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 2 2010 2:06PM', 'AS10000046', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 3:25PM', 'AS10000698', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 9:00PM', 'AS10000715', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 1 2010 9:45PM', 'SS10000015', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 4:42PM', 'AS10000703', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 4:45PM', 'AS10000704', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 1 2010 8:57AM', 'AS10000002', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 3:30PM', 'AS10000699', '2', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 7:22PM', 'AS10000713', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 10:42AM', 'AS10000005', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 1 2010 9:39AM', 'SS10000001', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 4:42PM', 'AS10000703', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 4:45PM', 'AS10000704', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 4:42PM', 'AS10000703', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 4:45PM', 'AS10000704', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 1 2010 11:21AM', 'SS10000003', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 1 2010 3:08PM', 'SS10000007', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 2 2010 1:51PM', 'SS10000021', '2', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 2:00AM', 'AS10000003', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 4:42PM', 'AS10000703', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 4:45PM', 'AS10000704', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 2 2010 11:19AM', 'AS10000019', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 1 2010 6:37AM', 'SS10000007', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 12:47AM', 'AS10000002', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 11:13AM', 'AS10000006', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 7:00PM', 'AS10000025', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 4:42PM', 'AS10000703', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 4:45PM', 'AS10000704', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 1 2010 3:47PM', 'SS10000008', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 6:44PM', 'AS10000708', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 4:42PM', 'AS10000703', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 4:45PM', 'AS10000704', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 3 2010 1:40PM', 'SS10000036', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 4:42PM', 'AS10000703', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 4:45PM', 'AS10000704', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 9:56PM', 'AS10000717', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 20 2010 1:37PM', 'SS10000466', '2', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 20 2010 2:37PM', 'SS10000468', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 4:42PM', 'AS10000703', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 4:45PM', 'AS10000704', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 7:20PM', 'AS10000712', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 1 2009 10:34AM', 'SS09000005', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 1 2009 1:02PM', 'SS09000010', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 1 2009 8:04PM', 'SS09000018', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 2 2009 1:17PM', 'SS09000031', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 2 2009 11:56PM', 'SS09000050', '2A', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 3 2009 4:30PM', 'SS09000062', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 3 2009 4:55PM', 'SS09000064', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 3 2009 10:43PM', 'SS09000070', '2A', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 4 2009 8:50AM', 'SS09000075', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 4 2009 5:05PM', 'SS09000084', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 4 2009 5:22PM', 'SS09000085', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 4 2009 9:26PM', 'SS09000090', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 21 2009 10:16AM', 'SS09000648', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 21 2009 10:24AM', 'SS09000649', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 21 2009 10:36AM', 'SS09000650', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 21 2009 1:19PM', 'SS09000655', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 21 2009 2:03PM', 'SS09000657', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 21 2009 2:26PM', 'SS09000659', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 21 2009 2:54PM', 'SS09000661', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 21 2009 7:43PM', 'SS09000670', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 21 2009 9:21PM', 'SS09000673', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 25 2009 12:39AM', 'SS09000778', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 25 2009 2:37AM', 'SS09000781', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 25 2009 11:03AM', 'SS09000785', '2A', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 25 2009 3:10PM', 'SS09000799', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 25 2009 6:52PM', 'SS09000805', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 25 2009 8:08PM', 'SS09000807', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 26 2009 2:08AM', 'SS09000814', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 26 2009 8:06AM', 'SS09000816', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 26 2009 2:38PM', 'SS09000841', '9', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 26 2009 3:34PM', 'SS09000846', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 26 2009 4:08PM', 'SS09000849', '2A', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 26 2009 5:14PM', 'SS09000852', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 26 2009 8:55PM', 'SS09000859', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 27 2009 1:34AM', 'SS09000863', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 27 2009 8:55AM', 'SS09000870', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 27 2009 7:41PM', 'SS09000898', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 27 2009 9:50PM', 'SS09000902', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 28 2009 9:57AM', 'SS09000905', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 28 2009 11:49AM', 'SS09000910', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 28 2009 2:45PM', 'SS09000920', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 28 2009 4:06PM', 'SS09000921', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 28 2009 5:06PM', 'SS09000922', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 29 2009 9:59AM', 'SS09000934', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 29 2009 11:04AM', 'SS09000936', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 29 2009 1:01PM', 'SS09000941', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 30 2009 11:17AM', 'SS09000959', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 30 2009 2:10PM', 'SS09000967', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 30 2009 2:50PM', 'SS09000968', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 30 2009 3:28PM', 'SS09000969', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 30 2009 4:53PM', 'SS09000972', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 30 2009 6:25PM', 'SS09000976', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 31 2009 12:46PM', 'SS09000986', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 31 2009 4:45PM', 'SS09000995', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 1 2009 12:06PM', 'SS09001005', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 2 2009 7:47AM', 'SS09001017', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 2 2009 3:52PM', 'SS09001034', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 3 2009 9:14AM', 'SS09001052', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 3 2009 11:03AM', 'SS09001059', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 3 2009 1:21PM', 'SS09001065', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 3 2009 4:24PM', 'SS09001071', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 4 2009 9:18AM', 'SS09001084', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 4 2009 12:30PM', 'SS09001091', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 4 2009 2:30PM', 'SS09001096', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 4 2009 6:26PM', 'SS09001100', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 4 2009 8:28PM', 'SS09001105', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 4 2009 9:59PM', 'SS09001107', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 5 2009 10:37AM', 'SS09001120', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 5 2009 2:18PM', 'SS09001127', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 6 2009 3:48PM', 'SS09001151', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 6 2009 7:10PM', 'SS09001155', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 6 2009 9:25PM', 'SS09001158', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 7 2009 10:38AM', 'SS09001163', '2A', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 7 2009 10:54AM', 'SS09001164', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 7 2009 11:02AM', 'SS09001165', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 7 2009 4:22PM', 'SS09001181', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 7 2009 8:16PM', 'SS09001190', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 8 2009 1:23PM', 'SS09001196', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 8 2009 7:33PM', 'SS09001200', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 8 2009 7:45PM', 'SS09001201', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 9 2009 8:40AM', 'SS09001204', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 9 2009 1:33PM', 'SS09001213', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 9 2009 2:56PM', 'SS09001216', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 9 2009 8:14PM', 'SS09001220', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 10 2009 10:03AM', 'SS09001233', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 10 2009 10:28AM', 'SS09001234', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 10 2009 10:39AM', 'SS09001236', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 10 2009 2:06PM', 'SS09001246', '9', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 10 2009 2:13PM', 'SS09001247', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 10 2009 5:48PM', 'SS09001254', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 10 2009 11:04PM', 'SS09001258', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 11 2009 12:40PM', 'SS09001268', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Feb 11 2009 1:46PM', 'SS09001269', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 2 2010 4:52PM', 'SS10000023', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 1 2010 12:02AM', 'SS10000001', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 1 2010 5:10PM', 'SS10000014', '9', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 2 2010 12:42PM', 'SS10000027', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 2 2010 4:26PM', 'SS10000036', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 2 2010 8:32PM', 'SS10000040', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 1 2009 9:41AM', 'SS09000003', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 1 2009 11:45PM', 'SS09000015', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 2 2009 11:18AM', 'SS09000018', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 2 2009 12:05PM', 'SS09000020', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 2 2009 2:09PM', 'SS09000023', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 2 2009 2:12PM', 'SS09000024', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 2 2009 2:16PM', 'SS09000025', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 2 2009 2:28PM', 'SS09000028', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 2 2009 2:42PM', 'SS09000030', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 2 2009 2:56PM', 'SS09000031', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 2 2009 5:07PM', 'SS09000035', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 3 2009 1:53AM', 'SS09000038', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 4 2009 2:20PM', 'SS09000057', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 4 2009 5:23PM', 'SS09000060', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 11 2009 11:17AM', 'SS09000203', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 11 2009 10:22PM', 'SS09000213', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 21 2009 3:01AM', 'SS09000450', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 21 2009 9:07AM', 'SS09000455', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 21 2009 10:52AM', 'SS09000460', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 21 2009 4:40PM', 'SS09000466', '2A', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 21 2009 5:51PM', 'SS09000468', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 25 2009 10:35AM', 'SS09000540', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 25 2009 11:27AM', 'SS09000542', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 25 2009 12:31PM', 'SS09000543', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 25 2009 12:32PM', 'SS09000544', '9', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 25 2009 2:01PM', 'SS09000546', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 25 2009 5:11PM', 'SS09000549', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 26 2009 12:32PM', 'SS09000563', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 26 2009 2:34PM', 'SS09000565', '2M', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 26 2009 4:48PM', 'SS09000569', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 26 2009 4:55PM', 'SS09000570', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 26 2009 6:37PM', 'SS09000576', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 26 2009 9:53PM', 'SS09000584', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 26 2009 10:00PM', 'SS09000585', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 27 2009 7:56AM', 'SS09000586', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 27 2009 11:15AM', 'SS09000592', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 27 2009 12:18PM', 'SS09000593', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 27 2009 12:56PM', 'SS09000594', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 27 2009 1:53PM', 'SS09000597', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 27 2009 2:03PM', 'SS09000601', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 27 2009 7:46PM', 'SS09000610', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 27 2009 8:12PM', 'SS09000611', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 27 2009 9:30PM', 'SS09000612', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 28 2009 6:51AM', 'SS09000613', '9', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 28 2009 8:51AM', 'SS09000615', '2A', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 28 2009 12:54PM', 'SS09000619', '9', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 28 2009 3:14PM', 'SS09000622', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 28 2009 4:20PM', 'SS09000623', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 28 2009 4:43PM', 'SS09000625', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 28 2009 5:03PM', 'SS09000628', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 28 2009 5:54PM', 'SS09000631', '2A', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 29 2009 9:03AM', 'SS09000635', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 29 2009 9:16AM', 'SS09000636', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 29 2009 9:21AM', 'SS09000637', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 29 2009 10:05AM', 'SS09000638', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 29 2009 10:30AM', 'SS09000639', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 29 2009 11:12AM', 'SS09000641', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 29 2009 11:33AM', 'SS09000642', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 29 2009 12:40PM', 'SS09000644', '2M', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 29 2009 2:52PM', 'SS09000649', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 29 2009 3:47PM', 'SS09000650', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 29 2009 6:13PM', 'SS09000653', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 30 2009 5:28AM', 'SS09000661', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 30 2009 9:50AM', 'SS09000669', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 30 2009 10:33AM', 'SS09000672', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 30 2009 10:47AM', 'SS09000673', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 30 2009 11:55AM', 'SS09000680', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 30 2009 1:58PM', 'SS09000684', '2A', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 30 2009 2:13PM', 'SS09000685', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 31 2009 10:11AM', 'SS09000692', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 31 2009 2:43PM', 'SS09000696', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 31 2009 2:59PM', 'SS09000697', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 31 2009 4:23PM', 'SS09000698', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 1 2009 4:35PM', 'SS09000710', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 1 2009 5:06PM', 'SS09000711', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 1 2009 11:18PM', 'SS09000715', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 2 2009 9:36AM', 'SS09000728', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 2 2009 11:50AM', 'SS09000732', '9', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 2 2009 1:01PM', 'SS09000734', '2M', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 2 2009 2:55PM', 'SS09000737', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 2 2009 3:24PM', 'SS09000738', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 2 2009 3:43PM', 'SS09000740', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 3 2009 7:52AM', 'SS09000753', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 3 2009 9:50AM', 'SS09000756', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 3 2009 10:58AM', 'SS09000759', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 3 2009 12:30PM', 'SS09000763', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 3 2009 4:46PM', 'SS09000767', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 3 2009 9:04PM', 'SS09000768', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 4 2009 10:28AM', 'SS09000775', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 4 2009 12:30PM', 'SS09000778', '2', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 4 2009 1:12PM', 'SS09000781', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 4 2009 2:02PM', 'SS09000784', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 4 2009 3:22PM', 'SS09000787', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 4 2009 9:19PM', 'SS09000792', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 5 2009 10:11AM', 'SS09000796', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 5 2009 12:14PM', 'SS09000801', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 6 2009 11:14AM', 'SS09000823', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 6 2009 4:08PM', 'SS09000830', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 6 2009 6:07PM', 'SS09000835', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 6 2009 7:40PM', 'SS09000837', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 7 2009 12:44AM', 'SS09000840', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 7 2009 8:40AM', 'SS09000842', '2', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 7 2009 4:25PM', 'SS09000851', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 8 2009 2:58AM', 'SS09000860', '2A', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 8 2009 10:40AM', 'SS09000862', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 8 2009 10:51AM', 'SS09000863', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 8 2009 1:52PM', 'SS09000866', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 8 2009 4:52PM', 'SS09000870', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 8 2009 7:37PM', 'SS09000873', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 9 2009 11:52AM', 'SS09000882', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 9 2009 12:07PM', 'SS09000884', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 9 2009 3:46PM', 'SS09000891', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 9 2009 4:30PM', 'SS09000893', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 10 2009 9:51AM', 'SS09000909', '9', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 10 2009 10:04AM', 'SS09000911', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 10 2009 10:58AM', 'SS09000915', '9', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 10 2009 11:09AM', 'SS09000917', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 10 2009 5:40PM', 'SS09000925', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 10 2009 5:46PM', 'SS09000926', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 10 2009 5:46PM', 'SS09000927', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 10 2009 8:12PM', 'SS09000932', '2', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 11 2009 7:50AM', 'SS09000938', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 11 2009 7:59AM', 'SS09000939', '2M', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 11 2009 8:42AM', 'SS09000941', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 11 2009 9:08AM', 'SS09000944', '2', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 11 2009 11:19AM', 'SS09000947', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 11 2009 11:34AM', 'SS09000949', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 11 2009 12:04PM', 'SS09000952', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Feb 11 2009 12:26PM', 'SS09000954', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 1 2010 9:39AM', 'SS10000001', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 1 2010 11:21AM', 'SS10000003', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 1 2010 3:08PM', 'SS10000007', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 1 2010 3:47PM', 'SS10000008', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 1 2010 10:34PM', 'SS10000017', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 2 2010 1:51PM', 'SS10000021', '2', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 2 2010 4:52PM', 'SS10000023', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 2 2010 5:56PM', 'SS10000025', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 3 2010 4:59PM', 'SS10000039', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 1 2010 10:34PM', 'SS10000017', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 20 2010 2:37PM', 'SS10000468', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2009 9:57AM', 'AS09000003', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 2 2009 8:35AM', 'AS09000017', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 2 2009 8:43AM', 'AS09000018', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 2 2009 9:33AM', 'AS09000023', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 2 2009 9:43PM', 'AS09000041', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 2 2009 11:10PM', 'AS09000042', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 3 2009 8:45AM', 'AS09000044', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 3 2009 11:07AM', 'AS09000050', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 3 2009 1:44PM', 'AS09000054', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 4 2009 9:58AM', 'AS09000057', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 4 2009 10:38AM', 'AS09000058', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 4 2009 4:55PM', 'AS09000065', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 4 2009 5:38PM', 'AS09000066', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 4 2009 5:41PM', 'AS09000068', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 4 2009 5:56PM', 'AS09000070', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 4 2009 5:59PM', 'AS09000071', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 4 2009 6:05PM', 'AS09000072', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 4 2009 6:12PM', 'AS09000073', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 4 2009 7:00PM', 'AS09000074', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 4 2009 9:32PM', 'AS09000078', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 4 2009 9:34PM', 'AS09000079', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 11 2009 9:19AM', 'AS09000272', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 11 2009 10:06AM', 'AS09000273', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 11 2009 10:24AM', 'AS09000274', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 11 2009 10:29PM', 'AS09000283', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 11 2009 10:29PM', 'AS09000284', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 21 2009 8:54AM', 'AS09000569', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 21 2009 8:54AM', 'AS09000570', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 21 2009 10:08AM', 'AS09000572', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 21 2009 12:47PM', 'AS09000580', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 21 2009 1:28PM', 'AS09000584', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 21 2009 3:19PM', 'AS09000588', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 21 2009 3:59PM', 'AS09000591', '2A', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 21 2009 4:07PM', 'AS09000593', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 21 2009 8:55PM', 'AS09000596', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 21 2009 9:02PM', 'AS09000597', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 21 2009 9:45PM', 'AS09000598', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 25 2009 7:42AM', 'AS09000700', '2A', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 25 2009 8:02AM', 'AS09000701', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 25 2009 11:17AM', 'AS09000709', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 25 2009 12:14PM', 'AS09000710', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 25 2009 1:41PM', 'AS09000712', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 25 2009 8:44PM', 'AS09000717', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 26 2009 8:00AM', 'AS09000719', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 26 2009 8:20AM', 'AS09000720', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 26 2009 9:00AM', 'AS09000721', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 26 2009 11:42AM', 'AS09000730', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 26 2009 12:03PM', 'AS09000733', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 26 2009 3:29PM', 'AS09000743', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 26 2009 4:44PM', 'AS09000746', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 26 2009 5:14PM', 'AS09000749', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 26 2009 5:46PM', 'AS09000751', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 26 2009 6:44PM', 'AS09000753', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 26 2009 6:53PM', 'AS09000754', '2A', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 26 2009 7:04PM', 'AS09000755', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 27 2009 12:05PM', 'AS09000773', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 27 2009 1:23PM', 'AS09000774', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 27 2009 1:23PM', 'AS09000775', '9', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 27 2009 1:45PM', 'AS09000777', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 27 2009 4:57PM', 'AS09000781', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 27 2009 6:46PM', 'AS09000783', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 27 2009 8:47PM', 'AS09000789', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 28 2009 5:23AM', 'AS09000792', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 28 2009 10:28AM', 'AS09000795', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 28 2009 11:28AM', 'AS09000796', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 28 2009 1:42PM', 'AS09000799', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 28 2009 2:15PM', 'AS09000803', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 28 2009 3:13PM', 'AS09000804', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 28 2009 3:18PM', 'AS09000805', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 28 2009 3:50PM', 'AS09000807', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 28 2009 4:59PM', 'AS09000809', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 28 2009 8:24PM', 'AS09000812', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 28 2009 11:26PM', 'AS09000814', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 29 2009 8:10AM', 'AS09000815', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 29 2009 9:07AM', 'AS09000818', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 29 2009 10:23AM', 'AS09000823', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 29 2009 10:28AM', 'AS09000824', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 29 2009 11:48AM', 'AS09000829', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 29 2009 12:32PM', 'AS09000831', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 29 2009 2:14PM', 'AS09000836', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 29 2009 2:34PM', 'AS09000837', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 29 2009 5:01PM', 'AS09000841', '2A', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 29 2009 5:40PM', 'AS09000843', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 29 2009 6:39PM', 'AS09000845', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 29 2009 9:13PM', 'AS09000849', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 30 2009 10:43AM', 'AS09000855', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 30 2009 10:50AM', 'AS09000856', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 30 2009 12:55PM', 'AS09000862', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 30 2009 3:12PM', 'AS09000868', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 30 2009 4:17PM', 'AS09000872', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 30 2009 4:32PM', 'AS09000873', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 30 2009 4:36PM', 'AS09000874', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 30 2009 4:38PM', 'AS09000875', '9', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 31 2009 9:06AM', 'AS09000880', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 31 2009 11:51AM', 'AS09000883', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 31 2009 3:46PM', 'AS09000889', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 31 2009 3:59PM', 'AS09000890', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 31 2009 5:50PM', 'AS09000893', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 31 2009 8:12PM', 'AS09000895', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 31 2009 8:16PM', 'AS09000896', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 1 2009 11:31AM', 'AS09000900', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 1 2009 1:25PM', 'AS09000902', '2A', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 1 2009 3:14PM', 'AS09000905', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 1 2009 5:18PM', 'AS09000907', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 1 2009 7:07PM', 'AS09000911', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 1 2009 8:31PM', 'AS09000914', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 1 2009 8:34PM', 'AS09000915', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 1 2009 8:34PM', 'AS09000916', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 1 2009 9:12PM', 'AS09000918', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 2 2009 3:39AM', 'AS09000920', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 2 2009 7:33AM', 'AS09000921', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 2 2009 7:51AM', 'AS09000924', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 2 2009 9:00AM', 'AS09000929', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 2 2009 9:04AM', 'AS09000930', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 2 2009 9:34AM', 'AS09000932', '9', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 2 2009 10:18AM', 'AS09000934', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 2 2009 10:25AM', 'AS09000935', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 2 2009 10:30AM', 'AS09000937', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 2 2009 10:34AM', 'AS09000938', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 2 2009 10:56AM', 'AS09000941', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 2 2009 12:58PM', 'AS09000946', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 2 2009 1:20PM', 'AS09000949', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 2 2009 1:35PM', 'AS09000950', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 2 2009 1:41PM', 'AS09000951', '9', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 2 2009 1:46PM', 'AS09000952', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 2 2009 2:37PM', 'AS09000953', '2', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 2 2009 5:31PM', 'AS09000955', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 2 2009 8:13PM', 'AS09000960', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 3 2009 7:54AM', 'AS09000968', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 3 2009 8:42AM', 'AS09000970', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 3 2009 9:50AM', 'AS09000972', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 3 2009 11:10AM', 'AS09000976', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 3 2009 12:31PM', 'AS09000979', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 31 2009 12:33PM', 'AS09000981', '9', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 3 2009 1:39PM', 'AS09000983', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 3 2009 1:46PM', 'AS09000984', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 3 2009 2:10PM', 'AS09000986', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 3 2009 3:59PM', 'AS09000990', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 3 2009 4:55PM', 'AS09000991', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 3 2009 5:14PM', 'AS09000992', '9', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 31 2009 10:45AM', 'AS09000995', '9', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 3 2009 7:01PM', 'AS09000997', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 3 2009 8:35PM', 'AS09000998', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 4 2009 9:58AM', 'AS09001002', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 4 2009 11:07AM', 'AS09001004', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 4 2009 11:16AM', 'AS09001005', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 4 2009 11:37AM', 'AS09001007', '2A', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 4 2009 11:42AM', 'AS09001009', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 4 2009 1:29PM', 'AS09001012', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 4 2009 1:53PM', 'AS09001014', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 5 2009 5:56AM', 'AS09001029', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 5 2009 7:50AM', 'AS09001031', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 5 2009 8:06AM', 'AS09001032', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 5 2009 8:37AM', 'AS09001034', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 5 2009 9:07AM', 'AS09001035', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 5 2009 10:55AM', 'AS09001038', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 5 2009 10:59AM', 'AS09001039', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 5 2009 12:16PM', 'AS09001041', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 5 2009 8:47PM', 'AS09001050', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 8:35AM', 'AS09001054', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 10:15AM', 'AS09001060', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 11:06AM', 'AS09001062', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 11:29AM', 'AS09001063', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 12:55PM', 'AS09001070', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 12:58PM', 'AS09001071', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 2:30PM', 'AS09001075', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 3:31PM', 'AS09001077', '9', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 3:47PM', 'AS09001079', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 4:21PM', 'AS09001080', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 4:33PM', 'AS09001081', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 4:49PM', 'AS09001082', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 6:43PM', 'AS09001086', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 6:54PM', 'AS09001087', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 7:19PM', 'AS09001088', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 7:21PM', 'AS09001089', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 7:37PM', 'AS09001090', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 8:22PM', 'AS09001092', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 9:06PM', 'AS09001095', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 9:15PM', 'AS09001096', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 9:41PM', 'AS09001097', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 6 2009 11:55PM', 'AS09001101', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 7 2009 10:10AM', 'AS09001105', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 7 2009 10:23AM', 'AS09001106', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 7 2009 2:11PM', 'AS09001115', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 7 2009 3:50PM', 'AS09001119', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 7 2009 5:16PM', 'AS09001121', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 7 2009 6:27PM', 'AS09001124', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 7 2009 6:28PM', 'AS09001125', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 7 2009 8:12PM', 'AS09001126', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 8 2009 10:24AM', 'AS09001128', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 8 2009 10:40AM', 'AS09001129', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 8 2009 11:35AM', 'AS09001130', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 8 2009 4:14PM', 'AS09001132', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 8 2009 4:17PM', 'AS09001133', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 9 2009 7:13AM', 'AS09001136', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 9 2009 7:26AM', 'AS09001137', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 9 2009 8:27AM', 'AS09001140', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 9 2009 10:12AM', 'AS09001142', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 9 2009 11:19AM', 'AS09001145', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 9 2009 12:15PM', 'AS09001147', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 9 2009 4:30PM', 'AS09001153', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 9 2009 4:30PM', 'AS09001154', '9', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 9 2009 6:49PM', 'AS09001160', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 9 2009 9:36PM', 'AS09001165', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 9 2009 11:08PM', 'AS09001167', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 10 2009 8:42AM', 'AS09001174', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 10 2009 8:55AM', 'AS09001177', '2A', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 10 2009 9:05AM', 'AS09001178', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 10 2009 9:23AM', 'AS09001181', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 10 2009 10:11AM', 'AS09001186', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 10 2009 10:51AM', 'AS09001188', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 10 2009 3:18PM', 'AS09001192', '2A', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 10 2009 4:17PM', 'AS09001195', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 10 2009 5:45PM', 'AS09001198', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 10 2009 5:45PM', 'AS09001199', '9', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 10 2009 6:23PM', 'AS09001202', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 11 2009 4:41AM', 'AS09001205', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 11 2009 6:47AM', 'AS09001206', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 11 2009 7:45AM', 'AS09001208', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 11 2009 8:59AM', 'AS09001209', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 11 2009 9:20AM', 'AS09001211', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 11 2009 12:41PM', 'AS09001225', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 11 2009 1:16PM', 'AS09001228', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 11 2009 3:10PM', 'AS09001232', '2A', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 11 2009 3:12PM', 'AS09001233', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Feb 11 2009 3:23PM', 'AS09001235', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 3 2010 4:59PM', 'SS10000039', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 12:20AM', 'AS10000001', '9', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 12:47AM', 'AS10000002', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 10:42AM', 'AS10000005', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 11:13AM', 'AS10000006', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 12:14PM', 'AS10000008', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 12:49PM', 'AS10000009', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 3:31PM', 'AS10000012', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 4:03PM', 'AS10000013', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 4:42PM', 'AS10000018', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 5:19PM', 'AS10000019', '2', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 5:59PM', 'AS10000021', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 6:29PM', 'AS10000023', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 6:44PM', 'AS10000024', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 7:09PM', 'AS10000026', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 7:09PM', 'AS10000027', '9', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 7:58PM', 'AS10000028', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 8:42PM', 'AS10000031', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 8:57PM', 'AS10000032', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 9:28PM', 'AS10000033', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 2 2010 1:56AM', 'AS10000037', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 2 2010 1:49PM', 'AS10000045', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 3 2010 11:31PM', 'AS10000060', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 1 2010 6:37AM', 'SS10000007', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 1 2009 9:27AM', 'AS09000005', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 1 2009 12:07PM', 'AS09000009', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 2 2009 10:14AM', 'AS09000022', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 2 2009 3:08PM', 'AS09000037', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 2 2009 3:12PM', 'AS09000038', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 4 2009 5:48PM', 'AS09000074', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 11 2009 10:34AM', 'AS09000250', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 11 2009 2:35PM', 'AS09000257', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 21 2009 9:37AM', 'AS09000543', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 21 2009 9:57AM', 'AS09000544', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 21 2009 7:24PM', 'AS09000564', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 25 2009 3:25AM', 'AS09000651', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 25 2009 3:29PM', 'AS09000664', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 26 2009 8:09AM', 'AS09000674', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 26 2009 9:39AM', 'AS09000675', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 26 2009 11:37AM', 'AS09000681', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 26 2009 6:13PM', 'AS09000698', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 26 2009 8:31PM', 'AS09000701', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 26 2009 10:28PM', 'AS09000704', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 27 2009 1:12PM', 'AS09000717', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 27 2009 4:21PM', 'AS09000726', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 27 2009 4:27PM', 'AS09000727', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 28 2009 2:30PM', 'AS09000755', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 28 2009 3:00PM', 'AS09000757', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 28 2009 4:11PM', 'AS09000758', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 28 2009 4:23PM', 'AS09000759', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 29 2009 9:13AM', 'AS09000774', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 29 2009 4:03PM', 'AS09000783', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 30 2009 12:38PM', 'AS09000809', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 30 2009 3:13PM', 'AS09000812', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 30 2009 3:18PM', 'AS09000813', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 31 2009 5:21PM', 'AS09000835', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 31 2009 6:54PM', 'AS09000838', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 31 2009 6:56PM', 'AS09000839', '9', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 31 2009 7:17PM', 'AS09000842', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 1 2009 8:03AM', 'AS09000847', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 1 2009 9:28AM', 'AS09000851', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 1 2009 10:47AM', 'AS09000853', '9', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 1 2009 7:37PM', 'AS09000861', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 2 2009 10:12AM', 'AS09000870', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 2 2009 2:12PM', 'AS09000877', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 3 2009 3:15PM', 'AS09000914', '9', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 3 2009 3:16PM', 'AS09000915', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 3 2009 7:18PM', 'AS09000922', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 4 2009 10:31AM', 'AS09000934', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 4 2009 11:32AM', 'AS09000936', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 4 2009 12:08PM', 'AS09000939', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 4 2009 3:20PM', 'AS09000947', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 4 2009 4:06PM', 'AS09000952', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 4 2009 6:18PM', 'AS09000954', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 4 2009 8:36PM', 'AS09000958', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 5 2009 12:05AM', 'AS09000964', '9', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 5 2009 1:53PM', 'AS09000976', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 5 2009 7:18PM', 'AS09000981', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 6 2009 10:09AM', 'AS09000995', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 6 2009 5:10PM', 'AS09001011', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 7 2009 12:42PM', 'AS09001025', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 8 2009 3:52PM', 'AS09001038', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 9 2009 8:21AM', 'AS09001045', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 9 2009 11:24AM', 'AS09001054', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 9 2009 11:05PM', 'AS09001066', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 10 2009 12:42AM', 'AS09001068', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 10 2009 8:45AM', 'AS09001071', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 10 2009 9:20AM', 'AS09001073', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 10 2009 9:29AM', 'AS09001074', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 10 2009 10:59AM', 'AS09001077', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 10 2009 2:46PM', 'AS09001081', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 10 2009 2:59PM', 'AS09001083', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 10 2009 3:43PM', 'AS09001085', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 10 2009 9:53PM', 'AS09001094', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 10 2009 10:31PM', 'AS09001095', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 10 2009 10:48PM', 'AS09001096', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 11 2009 10:25AM', 'AS09001104', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 11 2009 11:20AM', 'AS09001106', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Feb 11 2009 1:07PM', 'AS09001109', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 1 2010 12:06PM', 'AS10000003', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 1 2010 5:33PM', 'AS10000009', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 2 2010 11:19AM', 'AS10000019', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 2 2010 9:09PM', 'AS10000026', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 1 2010 6:37AM', 'SS10000007', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 2 2010 4:57PM', 'SS10000037', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 1 2010 9:45PM', 'SS10000015', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 3 2010 1:40PM', 'SS10000036', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 1 2010 6:37AM', 'SS10000007', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 5:19PM', 'AS10000019', '2', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 1 2010 7:00PM', 'AS10000025', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 27 2009 8:18PM', 'AS09000734', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 1 2010 8:57AM', 'AS10000002', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 1 2010 6:37AM', 'SS10000007', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 20 2010 2:05AM', 'SS10000613', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 20 2010 10:20AM', 'SS10000623', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 20 2010 11:44AM', 'SS10000628', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 20 2010 1:41PM', 'SS10000634', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 20 2010 1:54PM', 'SS10000635', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 20 2010 5:30PM', 'SS10000642', '4', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 20 2010 12:57PM', 'SS10000464', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 20 2010 1:37PM', 'SS10000466', '2', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 9:56PM', 'AS10000717', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 20 2010 10:20AM', 'SS10000623', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 1 2010 12:02AM', 'SS10000001', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 20 2010 4:19PM', 'SS10000472', '2M', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 20 2010 8:47PM', 'SS10000481', 'UNKNOWN', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 3:56AM', 'AS10000674', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 7:26AM', 'AS10000675', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 7:42AM', 'AS10000676', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 8:16AM', 'AS10000677', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 8:56AM', 'AS10000679', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 9:04AM', 'AS10000680', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 9:05AM', 'AS10000681', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 9:17AM', 'AS10000683', '1', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 10:57AM', 'AS10000687', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 11:45AM', 'AS10000690', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 3:25PM', 'AS10000698', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 3:30PM', 'AS10000699', '2', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 4:00PM', 'AS10000702', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 4:42PM', 'AS10000703', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 4:45PM', 'AS10000704', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 6:38PM', 'AS10000707', '2', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 6:44PM', 'AS10000708', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 6:50PM', 'AS10000709', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 7:16PM', 'AS10000710', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 7:20PM', 'AS10000712', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 7:22PM', 'AS10000713', 'UNKNOWN', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 7:36PM', 'AS10000714', '4', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 9:00PM', 'AS10000715', 'UNKNOWN', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 20 2010 12:05AM', 'AS10000480', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 20 2010 2:20PM', 'AS10000493', 'UNKNOWN', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'MA', 'Jan 2 2010 4:57PM', 'SS10000037', '3', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 20 2010 1:37PM', 'SS10000466', '2', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'LA', 'Jan 20 2010 8:47PM', 'SS10000481', '3', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 8:16AM', 'AS10000677', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 6:38PM', 'AS10000707', '2', 'Source1')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 7:22PM', 'AS10000713', '2', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'NJ', 'Jan 20 2010 9:00PM', 'AS10000715', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 20 2010 12:05AM', 'AS10000480', '1', 'Source3')

INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( 'PA', 'Jan 20 2010 2:20PM', 'AS10000493', '1', 'Source3')

Go

Declare @curYearStart datetime

,@prevYearStart datetime;

Set @curYearStart = dateadd(year, datediff(year, 0, getdate()), 0);

Set @prevYearStart = dateadd(year, -1, @curYearStart);

;With currentYTD (Area, Source, Total)

As (Select Area

,Src

,count(Distinct Account_No)

From #dim1

Where Filter_Code Not In ('4', '9', 'Unknown')

And [Date] >= @curYearStart

And [Date] < dateadd(day, datediff(day, 0, getdate()), 0)

Group By Area

,Src

), previousYTD (Area, Source, Total)

As (Select Area

,Src

,count(Distinct Account_No)

From #dim1

Where Filter_Code Not In ('4', '9', 'Unknown')

And [Date] >= @prevYearStart

And [Date] < @curYearStart

Group By Area

,Src

)

Select curYTD.Area

,curYTD.Source

,curYTD.Total As 'YTD 2010'

,prevYTD.Total As 'YTD 2009'

,(curYTD.Total - prevYTD.Total) As Variance

From currentYTD curYTD

Join previousYTD prevYTD On prevYTD.Area = curYTD.Area

And prevYTD.Source = curYTD.Source;

And here are the results:

AreaSourceYTD 2010YTD 2009Variance
LASource1440-36
LASource31052-42
MASource1334-31
NJSource1837-29
NJSource32699-73
PASource3422-18

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs