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


Add to briefcase ««12

many to many join and union all Expand / Collapse
Author
Message
Posted Wednesday, January 09, 2013 8:51 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 20, 2013 7:19 AM
Points: 10, Visits: 51
PK is district_code with fund_code being a foreign key for all 3
function_code and object_code are foreign keys for expense
receipt_code being a foreign key for revenue
Post #1405146
Posted Thursday, January 10, 2013 7:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 20, 2013 7:19 AM
Points: 10, Visits: 51
bump
Post #1405453
Posted Thursday, January 10, 2013 12:31 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:01 AM
Points: 1,642, Visits: 16,580
wtolbert (1/10/2013)
bump


Hi...everyone here provides their time and expertise free of charge ....so please be patient.

It will probably help us to help you if you could provide the results you would expect based on the sample data you provided...this will enable us to check thro any code.

regards


__________________________________________________________________
you can lead a user to data....but you cannot make them think !
__________________________________________________________________
Post #1405601
Posted Thursday, January 10, 2013 12:58 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 20, 2013 7:19 AM
Points: 10, Visits: 51
Thank you J. below is the desired output taken from a different data set that I'm looking for.

onclick:if_IFCode('
CREATE TABLE [dbo].[RAW_Financial_desired_output](
[district_code] [float] NULL,
[FUND_CODE] [float] NULL,
[BEGIN_BALANCE] [float] NULL,
[END_BALANCE] [float] NULL,
[YEAR] [float] NULL,
[district_name] [varchar](100) NULL,
[fund_description] [varchar](100) NULL,
[fund_type] [varchar](100) NULL,
[function_code] [float] NULL,
[function_description] [varchar](100) NULL,
[object_code] [varchar](100) NULL,
[object_description] [varchar](100) NULL,
[source_code] [float] NULL,
[source_description] [varchar](100) NULL,
[actual] [float] NULL,
[budget] [float] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 262, NULL, 1153.14, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 751, NULL, 0, 80099)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 990, NULL, 0, 1380)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 100.0', NULL, NULL, NULL, 0, 861772)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 100.0', NULL, NULL, NULL, 0, 875434)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 131000, NULL, N' 210.0', NULL, NULL, NULL, 0, 4874)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 135000, NULL, N' 210.0', NULL, NULL, NULL, 0, 3330)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 136000, NULL, N' 220.0', NULL, NULL, NULL, 0, 2980)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 136000, NULL, N' 250.0', NULL, NULL, NULL, 128.64, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 140000, NULL, N' 220.0', NULL, NULL, NULL, 6064.08, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 160000, NULL, N' 240.0', NULL, NULL, NULL, 2.11, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 160000, NULL, N' 550.0', NULL, NULL, NULL, 0, 800)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 213000, NULL, N' 210.0', NULL, NULL, NULL, 4408.45, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 262, NULL, 0, 1000)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 517, NULL, 49950.36, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 791, NULL, 89578.42, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 969, NULL, 3399.93, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 470.0', NULL, NULL, NULL, 0, 25228)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 550.0', NULL, NULL, NULL, 3217.89, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 350.0', NULL, NULL, NULL, 0, 300)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 430.0', NULL, NULL, NULL, 0, 555)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 131000, NULL, N' 220.0', NULL, NULL, NULL, 0, 3550)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 132000, NULL, N' 100.0', NULL, NULL, NULL, 62455.81, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 133000, NULL, N' 250.0', NULL, NULL, NULL, 0, 21)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 135000, NULL, N' 100.0', NULL, NULL, NULL, 31681.83, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 135000, NULL, N' 410.0', NULL, NULL, NULL, 1849.8, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 8, 1225779.76, 1117323.38, 2007, N'ABBOTSFORD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 280, NULL, 0, 82727)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 581, NULL, 10231.46, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 972, NULL, 0, 12857)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 220.0', NULL, NULL, NULL, 59510.7, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 410.0', NULL, NULL, NULL, 0, 18789)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 560.0', NULL, NULL, NULL, 0, 1983)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 210.0', NULL, NULL, NULL, 88349.9, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 240.0', NULL, NULL, NULL, 0, 113017)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 940.0', NULL, NULL, NULL, 0, 200)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 131000, NULL, N' 250.0', NULL, NULL, NULL, 0, 154)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 132000, NULL, N' 470.0', NULL, NULL, NULL, 878.62, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 160000, NULL, N' 100.0', NULL, NULL, NULL, 81669.44, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 2067765.92, 1372068.34, 2007, N'ABBOTSFORD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 290.0', NULL, NULL, NULL, 0, 3000)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 430.0', NULL, NULL, NULL, 0, 3000)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 550.0', NULL, NULL, NULL, 1229.58, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 560.0', NULL, NULL, NULL, 0, 1350)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 132000, NULL, N' 210.0', NULL, NULL, NULL, 6578.78, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 132000, NULL, N' 240.0', NULL, NULL, NULL, 0, 6406)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 135000, NULL, N' 220.0', NULL, NULL, NULL, 2227.25, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 135000, NULL, N' 430.0', NULL, NULL, NULL, 0, 71)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 136000, NULL, N' 100.0', NULL, NULL, NULL, 38949, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 136000, NULL, N' 410.0', NULL, NULL, NULL, 2703.63, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 140000, NULL, N' 100.0', NULL, NULL, NULL, 85599.47, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 140000, NULL, N' 240.0', NULL, NULL, NULL, 14176.72, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 19644.15, 51854.2, 2007, N'ABBOTSFORD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 10253.42, 95491.46, 2007, N'ABBOTSFORD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 612, NULL, 19256.5, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 691, NULL, 5403, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 210.0', NULL, NULL, NULL, 0, 87092)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 430.0', NULL, NULL, NULL, 1986.86, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 220.0', NULL, NULL, NULL, 0, 67005)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 550.0', NULL, NULL, NULL, 0, 1560)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 131000, NULL, N' 430.0', NULL, NULL, NULL, 0, 303)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 131000, NULL, N' 570.0', NULL, NULL, NULL, 0, 1000)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 135000, NULL, N' 250.0', NULL, NULL, NULL, 0, 105)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 136000, NULL, N' 430.0', NULL, NULL, NULL, 0, 200)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 136000, NULL, N' 470.0', NULL, NULL, NULL, 615.19, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 78601.21, 54082.68, 2007, N'ABBOTSFORD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 211, NULL, 0, 1049562)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 279, NULL, 3404.75, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 292, NULL, 4318, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 295, NULL, 20, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 343, NULL, 0, 7200)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 345, NULL, 141607, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 613, NULL, 0, 16673)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 132000, NULL, N' 220.0', NULL, NULL, NULL, 0, 4778)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 133000, NULL, N' 210.0', NULL, NULL, NULL, 0, 451)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 133000, NULL, N' 220.0', NULL, NULL, NULL, 474.86, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 135000, NULL, N' 342.0', NULL, NULL, NULL, 0, 75)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 140000, NULL, N' 410.0', NULL, NULL, NULL, 2489.48, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 8, 704980.26, 575002.26, 2007, N'ABBOTSFORD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 43007.27, 35349.29, 2007, N'ABBOTSFORD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 241, NULL, 0, 5884)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 621, NULL, 4371388, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 730, NULL, 9587.03, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 971, NULL, 38224.86, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 240.0', NULL, NULL, NULL, 98765.18, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 310.0', NULL, NULL, NULL, 0, 3100)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 250.0', NULL, NULL, NULL, 0, 2696)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 131000, NULL, N' 240.0', NULL, NULL, NULL, 0, 11131)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 132000, NULL, N' 250.0', NULL, NULL, NULL, 0, 207)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 132000, NULL, N' 550.0', NULL, NULL, NULL, 0, 679)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 133000, NULL, N' 210.0', NULL, NULL, NULL, 651.61, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 8, 1146014.15, 1037557.65, 2007, N'ABBOTSFORD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, -722858.67, -37543.46, 2007, N'ABBOTSFORD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 77304.61, 403843.12, 2007, N'ABBOTSFORD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 213, NULL, 0, 4000)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 293, NULL, 28045.95, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 630, NULL, 861.45, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 964, NULL, 0, 4533)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 972, NULL, 84.71, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 131000, NULL, N' 100.0', NULL, NULL, NULL, 0, 46405)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 132000, NULL, N' 250.0', NULL, NULL, NULL, 206.16, 0)
GO
print 'Processed 100 total records'
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 132000, NULL, N' 410.0', NULL, NULL, NULL, 531.85, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 132000, NULL, N' 470.0', NULL, NULL, NULL, 0, 1081)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 133000, NULL, N' 100.0', NULL, NULL, NULL, 0, 6187)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 211, NULL, 1049562, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 213, NULL, 8333.95, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 292, NULL, 0, 6000)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 293, NULL, 0, 31600)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 341, NULL, 0, 1000)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 751, NULL, 80105.18, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 964, NULL, 36050, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 100.0', NULL, NULL, NULL, 829182.87, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 350.0', NULL, NULL, NULL, 173.36, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 131000, NULL, N' 100.0', NULL, NULL, NULL, 46405, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 132000, NULL, N' 220.0', NULL, NULL, NULL, 4592.74, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 133000, NULL, N' 410.0', NULL, NULL, NULL, 80.97, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 135000, NULL, N' 210.0', NULL, NULL, NULL, 3337.19, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 271, NULL, 27315.05, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 279, NULL, 0, 2531)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 294, NULL, 523.91, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 295, NULL, 0, 5500)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 297, NULL, 112.5, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 343, NULL, 14, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 650, NULL, 182124.56, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 969, NULL, 0, 3400)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 470.0', NULL, NULL, NULL, 22272.16, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 470.0', NULL, NULL, NULL, 3871.43, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 560.0', NULL, NULL, NULL, 1350, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 132000, NULL, N' 210.0', NULL, NULL, NULL, 0, 6559)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 133000, NULL, N' 100.0', NULL, NULL, NULL, 6186, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 613, NULL, 17241, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 410.0', NULL, NULL, NULL, 13863.64, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 240.0', NULL, NULL, NULL, 111609.17, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 131000, NULL, N' 250.0', NULL, NULL, NULL, 153.12, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 131000, NULL, N' 410.0', NULL, NULL, NULL, 6278.49, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 133000, NULL, N' 240.0', NULL, NULL, NULL, 0, 196)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 213000, NULL, N' 342.0', NULL, NULL, NULL, 85, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 214000, NULL, N' 940.0', NULL, NULL, NULL, 125, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 219000, NULL, N' 386.0', NULL, NULL, NULL, 0, 1040)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 221300, NULL, N' 550.0', NULL, NULL, NULL, 2456.32, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 222000, NULL, N' 220.0', NULL, NULL, NULL, 4637.8, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 223100, NULL, N' 100.0', NULL, NULL, NULL, 14803.61, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 223100, NULL, N' 220.0', NULL, NULL, NULL, 1032.02, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 271, NULL, 0, 19140)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 297, NULL, 0, 100)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 581, NULL, 0, 8000)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 650, NULL, 0, 205431)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 971, NULL, 0, 14000)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 990, NULL, 1379.47, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 240.0', NULL, NULL, NULL, 0, 106074)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 342.0', NULL, NULL, NULL, 0, 333)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 132000, NULL, N' 550.0', NULL, NULL, NULL, 669.73, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 135000, NULL, N' 250.0', NULL, NULL, NULL, 104.54, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 136000, NULL, N' 210.0', NULL, NULL, NULL, 0, 4091)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 136000, NULL, N' 220.0', NULL, NULL, NULL, 2801.21, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 140000, NULL, N' 220.0', NULL, NULL, NULL, 0, 6811)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 1500, 2007, N'ABBOTSFORD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 280, NULL, 88463.99, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 341, NULL, 7230.19, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 730, NULL, 0, 52259)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 791, NULL, 0, 68336)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 220.0', NULL, NULL, NULL, 0, 65927)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 290.0', NULL, NULL, NULL, 50, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 560.0', NULL, NULL, NULL, 313.6, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 210.0', NULL, NULL, NULL, 0, 89032)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 470.0', NULL, NULL, NULL, 0, 4368)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 940.0', NULL, NULL, NULL, 180, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 131000, NULL, N' 342.0', NULL, NULL, NULL, 0, 400)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 132000, NULL, N' 240.0', NULL, NULL, NULL, 5307.6, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 1972643.74, 2289404.67, 2007, N'ABBOTSFORD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 219, NULL, 300000, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 621, NULL, 0, 4371388)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 250.0', NULL, NULL, NULL, 2530.18, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 100.0', NULL, NULL, NULL, 850999.21, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 250.0', NULL, NULL, NULL, 2669.48, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 410.0', NULL, NULL, NULL, 24721.1, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 131000, NULL, N' 210.0', NULL, NULL, NULL, 4887.91, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 131000, NULL, N' 240.0', NULL, NULL, NULL, 11150.66, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 135000, NULL, N' 220.0', NULL, NULL, NULL, 0, 2426)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 136000, NULL, N' 250.0', NULL, NULL, NULL, 0, 129)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 136000, NULL, N' 410.0', NULL, NULL, NULL, 0, 2600)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 160000, NULL, N' 310.0', NULL, NULL, NULL, 0, 19580)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 8, 704979.84, 574999.17, 2007, N'ABBOTSFORD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 1972643.74, 1972643.74, 2007, N'ABBOTSFORD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 241, NULL, 4413, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 612, NULL, 0, 18792)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 691, NULL, 0, 5403)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 210.0', NULL, NULL, NULL, 84765.39, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 310.0', NULL, NULL, NULL, 3150, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 220.0', NULL, NULL, NULL, 60094.59, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 120000, NULL, N' 290.0', NULL, NULL, NULL, 0, 4000)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 131000, NULL, N' 410.0', NULL, NULL, NULL, 0, 3374)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 131000, NULL, N' 430.0', NULL, NULL, NULL, 279.05, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 132000, NULL, N' 410.0', NULL, NULL, NULL, 0, 850)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 133000, NULL, N' 240.0', NULL, NULL, NULL, 41.63, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 403157.04, 434254.9, 2007, N'ABBOTSFORD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 102290.17, 143185.64, 2007, N'ABBOTSFORD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 0, NULL, NULL, NULL, 345, NULL, 0, 183840)
INSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [function_code], [function_description], [object_code], [object_description], [source_code], [source_description], [actual], [budget]) VALUES (7, 10, 0, 0, 2007, N'ABBOTSFORD', NULL, NULL, 110000, NULL, N' 250.0', NULL, NULL, NULL, 0, 2638)

');
Post #1405616
Posted Thursday, January 10, 2013 1:21 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:01 AM
Points: 1,642, Visits: 16,580
wtolbert (1/10/2013)
Thank you J. below is the desired output taken from a different data set that I'm looking for.


Hi...am a bit busy just at the mo....maybe someone else will be along in a bit.
any reason why you decided to give sample data and then provide a result set for something other data set?

could you please post what you have tried so far...it may help .

regards


__________________________________________________________________
you can lead a user to data....but you cannot make them think !
__________________________________________________________________
Post #1405623
Posted Thursday, January 10, 2013 1:29 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 20, 2013 7:19 AM
Points: 10, Visits: 51
Well the results previously provided where done by another ETL developer and are from a different state. I'm using those results as a guide as how to go forward. I have tried a simple left join but it brings back too many rows and duplicates the actual, begin_balance, and end_balance totals where the district_code is joined instead of providing one line item per. I've also tried to union all the tables with select statements but as you know it just merges the tables together rather than keying on results where the foreign keys match.
Post #1405628
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse