SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Query Help - difference between last and current year


Query Help - difference between last and current year

Author
Message
sql_learner29
sql_learner29
SSC Eights!
SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)

Group: General Forum Members
Points: 917 Visits: 928
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

LutzM
LutzM
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12747 Visits: 13559
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
sql_learner29
sql_learner29
SSC Eights!
SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)

Group: General Forum Members
Points: 917 Visits: 928
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

sql_learner29
sql_learner29
SSC Eights!
SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)

Group: General Forum Members
Points: 917 Visits: 928
any helppppppppp on thisss
Thanks


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

Thanks

ChrisM@home
ChrisM@home
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2694 Visits: 10536
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
sql_learner29
sql_learner29
SSC Eights!
SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)

Group: General Forum Members
Points: 917 Visits: 928
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

Jeffrey Williams 3188
Jeffrey Williams 3188
SSCrazy Eights
SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)

Group: General Forum Members
Points: 9876 Visits: 9994
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 opportunities brilliantly disguised as insurmountable obstacles.

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

Steve Cullen
Steve Cullen
SSC Eights!
SSC Eights! (875 reputation)SSC Eights! (875 reputation)SSC Eights! (875 reputation)SSC Eights! (875 reputation)SSC Eights! (875 reputation)SSC Eights! (875 reputation)SSC Eights! (875 reputation)SSC Eights! (875 reputation)

Group: General Forum Members
Points: 875 Visits: 1226
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.


sql_learner29
sql_learner29
SSC Eights!
SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)SSC Eights! (917 reputation)

Group: General Forum Members
Points: 917 Visits: 928
i ran both the queries provided, but it returned nothing...NO rows...
I am not sure if It's returning result @ ur end.


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

Thanks

Jeffrey Williams 3188
Jeffrey Williams 3188
SSCrazy Eights
SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)

Group: General Forum Members
Points: 9876 Visits: 9994
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 opportunities brilliantly disguised as insurmountable obstacles.

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

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search