Query Help - difference between last and current year

  • [font="Comic Sans MS"]Hi all,

    I am writing a query that will pick data from only one table and based on a date column I am finding count of Accounts in last year and in this year, .......

    i will find the distinct count of a column (account) for those calendar dates..

    Now my problem is that now I want to see also the VARIANCE in 2009 and 2010 counts from the results shown like this:

    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

    [/font]

    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.

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • 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[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • 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:

    LASource1YTD 200969

    LASource1YTD 201068

    I want to show variance below

    LASource1VARIANCE-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

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • any helppppppppp on thisss

    Thanks

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • You can't solve this without a precise and complete definition of 'this year' and 'last year'. They mean different things to different people.


    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].


    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

  • 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

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • 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
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

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

  • 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

    fromdbo.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

    fromdbo.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.

    ,

    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.
  • i ran both the queries provided, but it returned nothing...NO rows...

    I am not sure if It's returning result @ ur end.

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

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

    Drop Table #dim1;

    --create

    CREATE TABLE [dbo].[#dim1](

    [varchar](5) NULL,

    [DATE] [datetime] NULL,

    [ACCOUNT_NO] [char](10) NULL,

    [FILTER_CODE] [varchar](50) NULL,

    [SRC] [varchar](50) NULL

    )

    --insert

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    INSERT INTO #dim1 ( AREA,DATE,ACCOUNT_NO,FILTER_CODE,SRC) VALUES ( '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:

    AreaSourceYTD 2010YTD 2009Variance

    LASource1440-36

    LASource31052-42

    MASource1334-31

    NJSource1837-29

    NJSource32699-73

    PASource3422-18

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

    ― Charles R. Swindoll

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

  • hi

    Thanx a lot, I can see the variance now, but every count is shown in a different column I want everything YTD2009 / YTD2010 / and Variance in same Column, As I have to use it in a group column, Can you make it all in same column ....

    Thanks again

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • Not to be a kill joy, but don't you think you should look at the code provided and see if you can make the necessary changes to format the output to your requirements.

    We don't mind helping, but, you need to remember that most of us are volunteers giving of our own time and effort to help you. You really shouldn't treat as free contract labor.

    If you have problems making the changes, show us what you have done and we will be glad to assist you.

  • ok let me try, anyways thanx a lot

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • Hey Thanks Jeffery ...:-):-)

    I just used unpivot in the query you provided and got it the way I wanted in one column....Thanks again:-)

    Declare @curYearStart datetime

    ,@prevYearStart datetime;

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

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

    With currentYTD (Area, Source, Total)

    As

    (

    Select Area

    ,Src

    ,count(Distinct Account_No)

    From #dim1

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

    And [Date] >= @curYearStart

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

    Group By Area,Src

    ), previousYTD (Area, Source, Total)

    As (Select Area

    ,Src

    ,count(Distinct Account_No)

    From #dim1

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

    And [Date] >= @prevYearStart

    And [Date] < @curYearStart

    Group By Area

    ,Src

    )

    SELECT area,source,heading, cnt

    FROM

    (

    Select curYTD.Area

    ,curYTD.Source

    ,curYTD.Total As 'YTD 2010'

    ,prevYTD.Total As 'YTD 2009'

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

    From currentYTD curYTD

    Join previousYTD prevYTD On prevYTD.Area = curYTD.Area

    And prevYTD.Source = curYTD.Source

    ) p

    UNPIVOT

    (cnt FOR heading IN

    ([YTD 2010],[YTD 2009],Variance)

    )AS unpvt

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • Great. Now, keep an eye on this thread as you may find others that may show you another way to accomplish the task as well. This will give you something to compare against your solution.

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply