many to many join and union all

Question

Post reply

many to many join and union all

wtolbert

SSC Enthusiast

Points: 100
More actions
January 9, 2013 at 3:19 pm

#287455

I'm having a hard time with this query this afternoon. I have 3 tables cash, revenue, expense. I need to join them together keeping all rows along with begin_balance, end_balance, and revenue. There are several rows per building all having different totals.
Sample data:
Revenue_table
building_code - 125, 125, 125
function_code – null, null, null
fund_code - 001, 001, 001
receipt_code – 14, 18, 31
object_code - null, null, null
revenue - 24463.24, 0, 825625.16
begin_balance - null, null, null
end_balance - null, null, null
year - 2007-12
Expense_table
building_code - 125, 125, 125
fund_code - 001, 001, 001
function_code – 11, 11, 11
receipt_code - null, null, null
object_code – 41, 41, 42
revenue - 24463.24, 0, 825625.16
begin_balance - null, null, null
end_balance - null, null, null
year - 2007-12
Cash_table
building_code - 125, 125, 125
function_code - null, null, null
fund_code - 001, 006, 007
receipt_code - null, null, null
object_code - 41, 41, 42
revenue - null, null, null
begin_balance - 206891.77, 0, 424.65
end_balance - 764207, -13522.95, 494.65
year - 2007-12
What is needed is to join on building_code and foreign keys to merge data together than possibly union the tables together creating one table in which all the data exists. I was uncertain as to how to join on tables with many to many relationships without producing unnecessary matches.

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

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

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 1

Hi

seems you are new around here...so a big welcome ...hopefully you will find this site a friendly and helpful resource.

first off...you have posted in SQL 7 , 2000 forum...is this the SQL version that you are using?

only asking cos it will make a difference to the answers provided......

are you familiar with how to provide "create table" statements and how to provide data to populate said tables ?.....this will make it far more likely that you will receive a tried and tested answer...if not please post back and we can give you some pointers.

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

wtolbert SSC Enthusiast Points: 100 More actions · Answer 2

J I am new. Thank you for the welcome. Any pointers will be helpful. SQL Server 7, 2000 is not what I was looking for.

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 3

wtolbert (1/9/2013)
J I am new. Thank you for the welcome. Any pointers will be helpful. SQL Server 7, 2000 is not what I was looking for.

ok...what version of MS SQL are you working with?

assuming you already have a SQL table with data called "Revenue_table " ?...correct?

do you know how to script this out (with data) to enable the forum to easily use your output (eg cut and paste into their version of SSMS and thereby replicate what you can see)...??

regards

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

wtolbert SSC Enthusiast Points: 100 More actions · Answer 4

I'm using SQL Server 2008 R2 and the tables are not very large but I can condense them to a small sample size and produce the schema and data.

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 5

great...look fwd to seeing the scripts

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

wtolbert SSC Enthusiast Points: 100 More actions · Answer 6

I have the schema and data. Not sure where I should attach it?

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 7

wtolbert (1/9/2013)
I have the schema and data. Not sure where I should attach it?

Instead of attaching it, it's best if you simply put it into the post and wrap it with the code="sql" tags you'll see in the ifCode shortcuts you'll see on the left. Many of us here are a bit fearful of downloading anything from the internet simply because a lot of us are on our work machines.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

wtolbert SSC Enthusiast Points: 100 More actions · Answer 8

Thanks Craig.

CREATE TABLE [dbo].[RAW_Financial_revenue_test](

[year_time] [varchar](100) NULL,

[district_code] [varchar](150) NULL,

[district_name] [varchar](150) NULL,

[FUND_CODE] [varchar](150) NULL,

[fund_description] [varchar](150) NULL,

[fund_type] [varchar](150) NULL,

[source_data] [varchar](250) NULL,

[source_state] [varchar](100) NULL,

[function_code] [varchar](150) NULL,

[function_description] [varchar](150) NULL,

[source_code] [varchar](100) NULL,

[source_description] [varchar](150) NULL,

[receipt_code] [varchar](100) NULL,

[receipt_description] [varchar](150) NULL,

[object_code] [varchar](100) NULL,

[object_description] [varchar](150) NULL,

[begin_balance] [varchar](100) NULL,

[end_balance] [varchar](100) NULL,

[actual] [varchar](100) NULL,

[budget] [varchar](100) NULL,

[report_type] [varchar](5) NULL,

[account_type_code] [varchar](5) NULL,

[account_type_desc] [varchar](50) NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

INSERT [dbo].[RAW_Financial_revenue_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'001', N'General', N'Debt Service Fund', NULL, NULL, NULL, NULL, NULL, NULL, N'1410', N'Interest on Investments *', NULL, NULL, NULL, NULL, N'24463.24', NULL, N'A', N'R', N'revenue')

INSERT [dbo].[RAW_Financial_revenue_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'001', N'General', N'Debt Service Fund', NULL, NULL, NULL, NULL, NULL, NULL, N'1890', N'Other Miscellaneous Receipts *', NULL, NULL, NULL, NULL, N'0', NULL, N'A', N'R', N'revenue')

INSERT [dbo].[RAW_Financial_revenue_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'001', N'General', N'Debt Service Fund', NULL, NULL, NULL, NULL, NULL, NULL, N'3110', N'School Foundation Basic Allowance *', NULL, NULL, NULL, NULL, N'825625.16', NULL, N'A', N'R', N'revenue')

INSERT [dbo].[RAW_Financial_revenue_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'001', N'General', N'Debt Service Fund', NULL, NULL, NULL, NULL, NULL, NULL, N'3110', N'School Foundation Basic Allowance *', NULL, NULL, NULL, NULL, N'9745.89', NULL, N'A', N'R', N'revenue')

INSERT [dbo].[RAW_Financial_revenue_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'001', N'General', N'Debt Service Fund', NULL, NULL, NULL, NULL, NULL, NULL, N'3110', N'School Foundation Basic Allowance *', NULL, NULL, NULL, NULL, N'74245.4', NULL, N'A', N'R', N'revenue')

INSERT [dbo].[RAW_Financial_revenue_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'001', N'General', N'Debt Service Fund', NULL, NULL, NULL, NULL, NULL, NULL, N'3110', N'School Foundation Basic Allowance *', NULL, NULL, NULL, NULL, N'41152.86', NULL, N'A', N'R', N'revenue')

INSERT [dbo].[RAW_Financial_revenue_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'006', N'Food Services ', N'Special Revenue Fund/Permanent fund/Private Purpose fund', NULL, NULL, NULL, NULL, NULL, NULL, N'1512', N'Sales of Type A Lunches to Students *', NULL, NULL, NULL, NULL, N'39', NULL, N'A', N'R', N'revenue')

INSERT [dbo].[RAW_Financial_revenue_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'006', N'Food Services ', N'Special Revenue Fund/Permanent fund/Private Purpose fund', NULL, NULL, NULL, NULL, NULL, NULL, N'4210', N'Restricted Grants-in-aid Received Directly from Federal Government *', NULL, NULL, NULL, NULL, N'3724.8', NULL, N'A', N'R', N'revenue')

INSERT [dbo].[RAW_Financial_revenue_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'007', N'Special Trust ', N'Special Revenue Fund/Private Purpose fund', NULL, NULL, NULL, NULL, NULL, NULL, N'1820', N'Contributions and Donations from Private Sources *', NULL, NULL, NULL, NULL, N'270', NULL, N'A', N'R', N'revenue')

INSERT [dbo].[RAW_Financial_revenue_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'007', N'Special Trust ', N'Special Revenue Fund/Private Purpose fund', NULL, NULL, NULL, NULL, NULL, NULL, N'1820', N'Contributions and Donations from Private Sources *', NULL, NULL, NULL, NULL, N'2500', NULL, N'A', N'R', N'revenue')

/****** Object: Table [dbo].[RAW_Financial_expense_test] Script Date: 01/09/2013 18:04:04 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[RAW_Financial_expense_test](

[year_time] [varchar](100) NULL,

[district_code] [varchar](150) NULL,

[district_name] [varchar](150) NULL,

[FUND_CODE] [varchar](150) NULL,

[fund_description] [varchar](150) NULL,

[fund_type] [varchar](150) NULL,

[source_data] [varchar](250) NULL,

[source_state] [varchar](100) NULL,

[function_code] [varchar](150) NULL,

[function_description] [varchar](150) NULL,

[source_code] [varchar](100) NULL,

[source_description] [varchar](150) NULL,

[receipt_code] [varchar](100) NULL,

[receipt_description] [varchar](150) NULL,

[object_code] [varchar](100) NULL,

[object_description] [varchar](150) NULL,

[begin_balance] [varchar](100) NULL,

[end_balance] [varchar](100) NULL,

[actual] [varchar](100) NULL,

[budget] [varchar](100) NULL,

[report_type] [varchar](5) NULL,

[account_type_code] [varchar](5) NULL,

[account_type_desc] [varchar](50) NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

INSERT [dbo].[RAW_Financial_expense_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'001', N'General', N'Debt Service Fund', N'\\f5adev01\transfer\OHK12\AFR and Budget\Expenditure_Folders\FY07_exp.txt', N'OH', N'1140', N'Alternative School', NULL, NULL, NULL, NULL, N'412', N'Instructional Improvement Services:', NULL, NULL, NULL, NULL, NULL, N'E', N'expense')

INSERT [dbo].[RAW_Financial_expense_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'001', N'General', N'Debt Service Fund', N'\\f5adev01\transfer\OHK12\AFR and Budget\Expenditure_Folders\FY07_exp.txt', N'OH', N'1140', N'Alternative School', NULL, NULL, NULL, NULL, N'419', N'Other Professional and Technical Services:', NULL, NULL, NULL, NULL, NULL, N'E', N'expense')

INSERT [dbo].[RAW_Financial_expense_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'001', N'General', N'Debt Service Fund', N'\\f5adev01\transfer\OHK12\AFR and Budget\Expenditure_Folders\FY07_exp.txt', N'OH', N'1140', N'Alternative School', NULL, NULL, NULL, NULL, N'425', N'Early Childhood Education', NULL, NULL, NULL, NULL, NULL, N'E', N'expense')

INSERT [dbo].[RAW_Financial_expense_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'001', N'General', N'Debt Service Fund', N'\\f5adev01\transfer\OHK12\AFR and Budget\Expenditure_Folders\FY07_exp.txt', N'OH', N'1140', N'Alternative School', NULL, NULL, NULL, NULL, N'432', N'Management Information System', NULL, NULL, NULL, NULL, NULL, N'E', N'expense')

INSERT [dbo].[RAW_Financial_expense_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'001', N'General', N'Debt Service Fund', N'\\f5adev01\transfer\OHK12\AFR and Budget\Expenditure_Folders\FY07_exp.txt', N'OH', N'1140', N'Alternative School', NULL, NULL, NULL, NULL, N'433', N'Non-Certificated Travel Reimbursement:', NULL, NULL, NULL, NULL, NULL, N'E', N'expense')

INSERT [dbo].[RAW_Financial_expense_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'001', N'General', N'Debt Service Fund', N'\\f5adev01\transfer\OHK12\AFR and Budget\Expenditure_Folders\FY07_exp.txt', N'OH', N'1140', N'Alternative School', NULL, NULL, NULL, NULL, N'441', N'Telephone Service:', NULL, NULL, NULL, NULL, NULL, N'E', N'expense')

INSERT [dbo].[RAW_Financial_expense_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'001', N'General', N'Debt Service Fund', N'\\f5adev01\transfer\OHK12\AFR and Budget\Expenditure_Folders\FY07_exp.txt', N'OH', N'1140', N'Alternative School', NULL, NULL, NULL, NULL, N'443', N'Summer School Remediation', NULL, NULL, NULL, NULL, NULL, N'E', N'expense')

INSERT [dbo].[RAW_Financial_expense_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'001', N'General', N'Debt Service Fund', N'\\f5adev01\transfer\OHK12\AFR and Budget\Expenditure_Folders\FY07_exp.txt', N'OH', N'1140', N'Alternative School', NULL, NULL, NULL, NULL, N'449', N'Other Communication Services:', NULL, NULL, NULL, NULL, NULL, N'E', N'expense')

INSERT [dbo].[RAW_Financial_expense_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'001', N'General', N'Debt Service Fund', N'\\f5adev01\transfer\OHK12\AFR and Budget\Expenditure_Folders\FY07_exp.txt', N'OH', N'1140', N'Alternative School', NULL, NULL, NULL, NULL, N'461', N'Printing and Binding:', NULL, NULL, NULL, NULL, NULL, N'E', N'expense')

INSERT [dbo].[RAW_Financial_expense_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'001', N'General', N'Debt Service Fund', N'\\f5adev01\transfer\OHK12\AFR and Budget\Expenditure_Folders\FY07_exp.txt', N'OH', N'1140', N'Alternative School', NULL, NULL, NULL, NULL, N'469', N'Other Craft and Trade Services:', NULL, NULL, NULL, NULL, NULL, N'E', N'expense')

/****** Object: Table [dbo].[RAW_Financial_balancesheet_test] Script Date: 01/09/2013 18:04:04 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[RAW_Financial_balancesheet_test](

[year_time] [varchar](100) NULL,

[district_code] [varchar](150) NULL,

[district_name] [varchar](150) NULL,

[FUND_CODE] [varchar](150) NULL,

[fund_description] [varchar](150) NULL,

[fund_type] [varchar](150) NULL,

[source_data] [varchar](250) NULL,

[source_state] [varchar](100) NULL,

[function_code] [varchar](150) NULL,

[function_description] [varchar](150) NULL,

[source_code] [varchar](100) NULL,

[source_description] [varchar](150) NULL,

[receipt_code] [varchar](100) NULL,

[receipt_description] [varchar](150) NULL,

[object_code] [varchar](100) NULL,

[object_description] [varchar](150) NULL,

[begin_balance] [varchar](100) NULL,

[end_balance] [varchar](100) NULL,

[actual] [varchar](100) NULL,

[budget] [varchar](100) NULL,

[report_type] [varchar](5) NULL,

[account_type_code] [varchar](5) NULL,

[account_type_desc] [varchar](50) NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

INSERT [dbo].[RAW_Financial_balancesheet_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'001', N'General', N'Debt Service Fund', N'\\f5adev01\transfer\OHK12\AFR and Budget\Cash_Records\FY07_Cash_Record.txt', N'OH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'206891.77', N'764207', NULL, NULL, N'A', NULL, NULL)

INSERT [dbo].[RAW_Financial_balancesheet_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'006', N'Food Services ', N'Special Revenue Fund/Permanent fund/Private Purpose fund', N'\\f5adev01\transfer\OHK12\AFR and Budget\Cash_Records\FY07_Cash_Record.txt', N'OH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'0', N'-13522.95', NULL, NULL, N'A', NULL, NULL)

INSERT [dbo].[RAW_Financial_balancesheet_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'007', N'Special Trust ', N'Special Revenue Fund/Private Purpose fund', N'\\f5adev01\transfer\OHK12\AFR and Budget\Cash_Records\FY07_Cash_Record.txt', N'OH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'424.65', N'494.65', NULL, NULL, N'A', NULL, NULL)

INSERT [dbo].[RAW_Financial_balancesheet_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'007', N'Special Trust ', N'Special Revenue Fund/Private Purpose fund', N'\\f5adev01\transfer\OHK12\AFR and Budget\Cash_Records\FY07_Cash_Record.txt', N'OH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'1354.86', N'1047.82', NULL, NULL, N'A', NULL, NULL)

INSERT [dbo].[RAW_Financial_balancesheet_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'007', N'Special Trust ', N'Special Revenue Fund/Private Purpose fund', N'\\f5adev01\transfer\OHK12\AFR and Budget\Cash_Records\FY07_Cash_Record.txt', N'OH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'0', N'2500', NULL, NULL, N'A', NULL, NULL)

INSERT [dbo].[RAW_Financial_balancesheet_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'007', N'Special Trust ', N'Special Revenue Fund/Private Purpose fund', N'\\f5adev01\transfer\OHK12\AFR and Budget\Cash_Records\FY07_Cash_Record.txt', N'OH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'0', N'485.88', NULL, NULL, N'A', NULL, NULL)

INSERT [dbo].[RAW_Financial_balancesheet_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'007', N'Special Trust ', N'Special Revenue Fund/Private Purpose fund', N'\\f5adev01\transfer\OHK12\AFR and Budget\Cash_Records\FY07_Cash_Record.txt', N'OH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'0', N'17423.76', NULL, NULL, N'A', NULL, NULL)

INSERT [dbo].[RAW_Financial_balancesheet_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'018', N'Public School Support', N'Special Revenue Fund', N'\\f5adev01\transfer\OHK12\AFR and Budget\Cash_Records\FY07_Cash_Record.txt', N'OH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'30', N'30', NULL, NULL, N'A', NULL, NULL)

INSERT [dbo].[RAW_Financial_balancesheet_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'019', N'Other Grants', N'Enterprise fund', N'\\f5adev01\transfer\OHK12\AFR and Budget\Cash_Records\FY07_Cash_Record.txt', N'OH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'38737.6', N'38737.6', NULL, NULL, N'A', NULL, NULL)

INSERT [dbo].[RAW_Financial_balancesheet_test] ([year_time], [district_code], [district_name], [FUND_CODE], [fund_description], [fund_type], [source_data], [source_state], [function_code], [function_description], [source_code], [source_description], [receipt_code], [receipt_description], [object_code], [object_description], [begin_balance], [end_balance], [actual], [budget], [report_type], [account_type_code], [account_type_desc]) VALUES (N'2007', N'000125', N'Polly Fox Academy Community School', N'019', N'Other Grants', N'Enterprise fund', N'\\f5adev01\transfer\OHK12\AFR and Budget\Cash_Records\FY07_Cash_Record.txt', N'OH', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'1279.5', N'585.1', NULL, NULL, N'A', NULL, NULL)

Jeff Moden SSC Guru Points: 1003857 More actions · Answer 9

What's the PK of each of those tables?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

wtolbert SSC Enthusiast Points: 100 More actions · Answer 10

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

wtolbert SSC Enthusiast Points: 100 More actions · Answer 11

wtolbert

SSC Enthusiast

Points: 100

January 10, 2013 at 7:37 am

#1575804

bump

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 12

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
and remember....every day is a school day

wtolbert SSC Enthusiast Points: 100 More actions · Answer 13

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)

');

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 14

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
and remember....every day is a school day