Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Query Help - difference between last and current year Expand / Collapse
Author
Message
Posted Thursday, February 11, 2010 12:33 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, June 30, 2014 1:23 PM
Points: 336, Visits: 866
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:

YTD 2009
AREA CNT
NJ 100
NY 200
PA 400


YTD 2010
AREA CNT
NJ 50
NY 100
PA 150

Now...i have calculate VARIANCE like this

VARIANCE 2009-2010
AREA CNT
NJ -50
NY 100
PA 250


but I am not able to get this variance from this query:
here is the SQL attached

complete SQL code is attached below....

Any help on this
Thanks in advance.



---------------------------------------------------

Thanks
Post #864256
Posted Thursday, February 11, 2010 12:44 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:36 PM
Points: 7,040, Visits: 12,964
Please provide table definition and some sample data to play with as described in the first link in my signature.



Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function
Post #864264
Posted Thursday, February 11, 2010 1:49 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, June 30, 2014 1:23 PM
Points: 336, Visits: 866
hi 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 69
LA Source1 YTD 2010 68

I want to show variance below

LA Source1 VARIANCE -1
hope you got it...

Just run the code the query will show the aggregated count...
I need variance below now...
Any help on this...
thanks



---------------------------------------------------

Thanks
Post #864307
Posted Thursday, February 11, 2010 2:30 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, June 30, 2014 1:23 PM
Points: 336, Visits: 866
any helppppppppp on thisss
Thanks



---------------------------------------------------

Thanks
Post #864331
Posted Thursday, February 11, 2010 2:35 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:54 PM
Points: 1,074, Visits: 6,368
You can't solve this without a precise and complete definition of 'this year' and 'last year'. They mean different things to different people.


Low-hanging fruit picker and defender of the moggies





For better assistance in answering your questions, please read this.




Understanding and using APPLY, (I) and (II) Paul White

Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Post #864337
Posted Thursday, February 11, 2010 2:47 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, June 30, 2014 1:23 PM
Points: 336, Visits: 866
Hi

I have already defined in my query the year strings...
have a look here:
   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




---------------------------------------------------

Thanks
Post #864346
Posted Thursday, February 11, 2010 3:02 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:28 AM
Points: 4,388, Visits: 9,508
See if this helps...

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;



Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #864351
Posted Thursday, February 11, 2010 3:10 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, September 19, 2012 8:39 AM
Points: 595, Visits: 1,226
Give this a shot.

; 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 Year2010
INNER JOIN Year2009
ON Year2010.AREA = Year2009.AREA
AND Year2010.SRC = Year2009.SRC
--AND Year2010.PERIOD = Year2009.PERIOD




Converting oxygen into carbon dioxide, since 1955.

Post #864359
Posted Thursday, February 11, 2010 3:15 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, June 30, 2014 1:23 PM
Points: 336, Visits: 866
i ran both the queries provided, but it returned nothing...NO rows...
I am not sure if It's returning result @ ur end.



---------------------------------------------------

Thanks
Post #864360
Posted Thursday, February 11, 2010 3:21 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:28 AM
Points: 4,388, Visits: 9,508
On the query I provided, did you change the table reference back to your original table? I modified it to use a temp table instead. Here is the full sample:

Drop Table #dim1;

--create
CREATE TABLE [dbo].[#dim1](
[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')
Go

Declare @curYearStart datetime
,@prevYearStart datetime;

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

;With currentYTD (Area, Source, Total)
As (Select Area
,Src
,count(Distinct Account_No)
From #dim1
Where Filter_Code Not In ('4', '9', 'Unknown')
And [Date] >= @curYearStart
And [Date] < dateadd(day, datediff(day, 0, getdate()), 0)
Group By Area
,Src
), previousYTD (Area, Source, Total)
As (Select Area
,Src
,count(Distinct Account_No)
From #dim1
Where Filter_Code Not In ('4', '9', 'Unknown')
And [Date] >= @prevYearStart
And [Date] < @curYearStart
Group By Area
,Src
)
Select curYTD.Area
,curYTD.Source
,curYTD.Total As 'YTD 2010'
,prevYTD.Total As 'YTD 2009'
,(curYTD.Total - prevYTD.Total) As Variance
From currentYTD curYTD
Join previousYTD prevYTD On prevYTD.Area = curYTD.Area
And prevYTD.Source = curYTD.Source;

And here are the results:


Area Source YTD 2010 YTD 2009 Variance
LA Source1 4 40 -36
LA Source3 10 52 -42
MA Source1 3 34 -31
NJ Source1 8 37 -29
NJ Source3 26 99 -73
PA Source3 4 22 -18


Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #864363
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse