InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 17:27:32 GMT20http://www.sqlservercentral.com/Forums/Topic864256-338-1.aspxGreat. Now, keep an eye on this thread as you may find others that may show you another way to accomplish the task as well. This will give you something to compare against your solution.Fri, 12 Feb 2010 07:23:05 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic864256-338-1.aspxHey [b]Thanks Jeffery ...[/b]:-):-)I just used unpivot in the query you provided and got it the way I wanted in one column....Thanks again:-)[code="sql"]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 area,source,heading, cnt FROM (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) pUNPIVOT (cnt FOR heading IN ([YTD 2010],[YTD 2009],Variance))AS unpvt[/code]Fri, 12 Feb 2010 07:12:15 GMTLearner1http://www.sqlservercentral.com/Forums/Topic864256-338-1.aspxok let me try, anyways thanx a lotFri, 12 Feb 2010 06:36:32 GMTLearner1http://www.sqlservercentral.com/Forums/Topic864256-338-1.aspxNot to be a kill joy, but don't you think you should look at the code provided and see if you can make the necessary changes to format the output to your requirements.We don't mind helping, but, you need to remember that most of us are volunteers giving of our own time and effort to help you. You really shouldn't treat as free contract labor.If you have problems making the changes, show us what you have done and we will be glad to assist you.Thu, 11 Feb 2010 18:43:02 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic864256-338-1.aspxhiThanx a lot, I can see the variance now, but every count is shown in a different column I want everything YTD2009 / YTD2010 / and Variance in same Column, As I have to use it in a group column, Can you make it all in same column ....Thanks againThu, 11 Feb 2010 18:08:09 GMTLearner1http://www.sqlservercentral.com/Forums/Topic864256-338-1.aspxOn 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:[code]Drop Table #dim1; --createCREATE TABLE [dbo].[#dim1]( [AREA] [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 ( '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 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')GoDeclare @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;[/code]And here are the results:[quote]Area Source YTD 2010 YTD 2009 VarianceLA Source1 4 40 -36LA Source3 10 52 -42MA Source1 3 34 -31NJ Source1 8 37 -29NJ Source3 26 99 -73PA Source3 4 22 -18[/quote]Thu, 11 Feb 2010 15:21:17 GMTJeffrey Williams 3188http://www.sqlservercentral.com/Forums/Topic864256-338-1.aspxi ran both the queries provided, but it returned nothing...NO rows...I am not sure if It's returning result @ ur end.Thu, 11 Feb 2010 15:15:27 GMTLearner1http://www.sqlservercentral.com/Forums/Topic864256-338-1.aspxGive this a shot.[code="sql"]; with Year2010 AS ( Select AREA,SRC ,case when DATE between '1/1/2010' AND getdate() THEN 'YTD 2010' when DATE between '1/1/2009' AND dateadd(yy,-1,getdate()) THEN 'YTD 2009' else 'Not Required'end AS PERIOD ,COUNT(distinct ACCOUNT_NO) as AC_Count from dbo.Dim1 a where FILTER_CODE not in ('4','9','unknown') and DATE between '1/1/2010' AND getdate() group by AREA,SRC ,case when DATE between '1/1/2010' AND getdate() THEN 'YTD 2010' when DATE between '1/1/2009' AND dateadd(yy,-1,getdate()) THEN 'YTD 2009' else 'Not Required'end), Year2009 AS ( Select AREA,SRC ,case when DATE between '1/1/2010' AND getdate() THEN 'YTD 2010' when DATE between '1/1/2009' AND dateadd(yy,-1,getdate()) THEN 'YTD 2009' else 'Not Required'end AS PERIOD ,COUNT(distinct ACCOUNT_NO) as AC_Count from dbo.Dim1 a where FILTER_CODE not in ('4','9','unknown') and DATE between '1/1/2009' AND dateadd(yy,-1,getdate()) group by AREA,SRC ,case when DATE between '1/1/2010' AND getdate() THEN 'YTD 2010' when DATE between '1/1/2009' AND dateadd(yy,-1,getdate()) THEN 'YTD 2009' else 'Not Required'end)SELECT Year2010.[AREA], Year2010.[SRC], Year2010.[AC_COUNT] [AC_COUNT YTD2010], Year2009.[AC_COUNT] [AC_COUNT YTD2009], Year2010.[AC_COUNT] - Year2009.[AC_COUNT] AS [CountDifference] FROM Year2010INNER JOIN Year2009 ON Year2010.AREA = Year2009.AREA AND Year2010.SRC = Year2009.SRC --AND Year2010.PERIOD = Year2009.PERIOD[/code]Thu, 11 Feb 2010 15:10:38 GMTSteve Cullenhttp://www.sqlservercentral.com/Forums/Topic864256-338-1.aspxSee if this helps...[code]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;[/code]Thu, 11 Feb 2010 15:02:05 GMTJeffrey Williams 3188http://www.sqlservercentral.com/Forums/Topic864256-338-1.aspxHi I have already defined in my query the year strings...have a look here:[code="sql"] Select AREA,SRC ,case when DATE between '1/1/2010' AND getdate() THEN 'YTD 2010' when DATE between '1/1/2009' AND dateadd(yy,-1,getdate()) THEN 'YTD 2009' else 'Not Required'end AS PERIOD ,COUNT(distinct ACCOUNT_NO) as AC_Count from dbo.Dim1 where FILTER_CODE not in ('4','9','unknown') group by AREA,SRC ,case when DATE between '1/1/2010' AND getdate() THEN 'YTD 2010' when DATE between '1/1/2009' AND dateadd(yy,-1,getdate()) THEN 'YTD 2009' else 'Not Required'end[/code]Thu, 11 Feb 2010 14:47:21 GMTLearner1http://www.sqlservercentral.com/Forums/Topic864256-338-1.aspxYou can't solve this without a precise and complete definition of 'this year' and 'last year'. They mean different things to different people.Thu, 11 Feb 2010 14:35:35 GMTChrisM@homehttp://www.sqlservercentral.com/Forums/Topic864256-338-1.aspxany helppppppppp on thisssThanksThu, 11 Feb 2010 14:30:08 GMTLearner1http://www.sqlservercentral.com/Forums/Topic864256-338-1.aspxhi here is the create table and insert and my query to get data for 2009 and 2010 year,,the result will be like this:LA Source1 YTD 2009 69LA Source1 YTD 2010 68I want to show variance belowLA Source1 VARIANCE -1hope you got it...Just run the code the query will show the aggregated count...I need variance below now...Any help on this...thanksThu, 11 Feb 2010 13:49:45 GMTLearner1http://www.sqlservercentral.com/Forums/Topic864256-338-1.aspxPlease provide table definition and some sample data to play with as described in the first link in my signature.Thu, 11 Feb 2010 12:44:07 GMTLutzMhttp://www.sqlservercentral.com/Forums/Topic864256-338-1.aspx[font="Comic Sans MS"]Hi all,I am writing a query that will pick data from only one table and based on a date column I am finding count of Accounts in last year and in this year, .......i will find the distinct count of a column (account) for those calendar dates..Now my problem is that now I want to see also the VARIANCE in 2009 and 2010 counts from the results shown like this:[b]YTD 2009[/b]AREA CNTNJ 100NY 200PA 400[b]YTD 2010[/b]AREA CNTNJ 50NY 100PA 150Now...[b]i have calculate VARIANCE like this[/b][b]VARIANCE 2009-2010 [/b]AREA CNTNJ -50NY 100PA 250[/font]but I am not able to get this variance from this query:here is the SQL attachedcomplete SQL code is attached below....Any help on thisThanks in advance.Thu, 11 Feb 2010 12:33:52 GMTLearner1