InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 23:08:49 GMT20http://www.sqlservercentral.com/Forums/Topic1405043-169-1.aspxWell the results previously provided where done by another ETL developer and are from a different state. I'm using those results as a guide as how to go forward. I have tried a simple left join but it brings back too many rows and duplicates the actual, begin_balance, and end_balance totals where the district_code is joined instead of providing one line item per. I've also tried to union all the tables with select statements but as you know it just merges the tables together rather than keying on results where the foreign keys match.Thu, 10 Jan 2013 13:29:05 GMTwtolberthttp://www.sqlservercentral.com/Forums/Topic1405043-169-1.aspx[quote][b]wtolbert (1/10/2013)[/b][hr]Thank you J. below is the desired output taken from a different data set that I'm looking for.[/quote]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 .regardsThu, 10 Jan 2013 13:21:01 GMTJ Livingston SQLhttp://www.sqlservercentral.com/Forums/Topic1405043-169-1.aspxThank you J. below is the desired output taken from a different data set that I'm looking for.onclick:if_IFCode('[code="sql"]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]GOSET ANSI_PADDING OFFGOINSERT [dbo].[RAW_Financial_desired_output] ([district_code], [FUND_CODE], [BEGIN_BALANCE], [END_BALANCE], [YEAR], [district_name], [fund_description], [fund_type], [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)GOprint '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)[/code]');Thu, 10 Jan 2013 12:58:31 GMTwtolberthttp://www.sqlservercentral.com/Forums/Topic1405043-169-1.aspx[quote][b]wtolbert (1/10/2013)[/b][hr]bump[/quote]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.regardsThu, 10 Jan 2013 12:31:03 GMTJ Livingston SQLhttp://www.sqlservercentral.com/Forums/Topic1405043-169-1.aspxbumpThu, 10 Jan 2013 07:37:57 GMTwtolberthttp://www.sqlservercentral.com/Forums/Topic1405043-169-1.aspxPK is district_code with fund_code being a foreign key for all 3function_code and object_code are foreign keys for [b]expense[/b]receipt_code being a foreign key for [b]revenue [/b]Wed, 09 Jan 2013 20:51:29 GMTwtolberthttp://www.sqlservercentral.com/Forums/Topic1405043-169-1.aspxWhat's the PK of each of those tables?Wed, 09 Jan 2013 20:42:02 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1405043-169-1.aspxThanks Craig.[code="sql"]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]GOSET ANSI_PADDING OFFGOINSERT [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 ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE 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]GOSET ANSI_PADDING OFFGOINSERT [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 ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE 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]GOSET ANSI_PADDING OFFGOINSERT [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)[/code]Wed, 09 Jan 2013 17:06:15 GMTwtolberthttp://www.sqlservercentral.com/Forums/Topic1405043-169-1.aspx[quote][b]wtolbert (1/9/2013)[/b][hr]I have the schema and data. Not sure where I should attach it?[/quote]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.Wed, 09 Jan 2013 16:43:17 GMTEvil Kraig Fhttp://www.sqlservercentral.com/Forums/Topic1405043-169-1.aspxI have the schema and data. Not sure where I should attach it?Wed, 09 Jan 2013 16:36:26 GMTwtolberthttp://www.sqlservercentral.com/Forums/Topic1405043-169-1.aspxgreat...look fwd to seeing the scriptsWed, 09 Jan 2013 16:11:52 GMTJ Livingston SQLhttp://www.sqlservercentral.com/Forums/Topic1405043-169-1.aspxI'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.Wed, 09 Jan 2013 16:08:49 GMTwtolberthttp://www.sqlservercentral.com/Forums/Topic1405043-169-1.aspx[quote][b]wtolbert (1/9/2013)[/b][hr]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.[/quote]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)...??regardsWed, 09 Jan 2013 15:44:11 GMTJ Livingston SQLhttp://www.sqlservercentral.com/Forums/Topic1405043-169-1.aspxJ I am new. Thank you for the welcome. Any pointers will be helpful. SQL Server 7, 2000 is not what I was looking for.Wed, 09 Jan 2013 15:38:14 GMTwtolberthttp://www.sqlservercentral.com/Forums/Topic1405043-169-1.aspxHiseems 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.Wed, 09 Jan 2013 15:34:51 GMTJ Livingston SQLhttp://www.sqlservercentral.com/Forums/Topic1405043-169-1.aspxI'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:[b]Revenue_table[/b] building_code - 125, 125, 125 function_code – null, null, null fund_code - 001, 001, 001 receipt_code – 14, 18, 31object_code - null, null, nullrevenue - 24463.24, 0, 825625.16begin_balance - null, null, nullend_balance - null, null, nullyear - 2007-12[b]Expense_table[/b] building_code - 125, 125, 125 fund_code - 001, 001, 001 function_code – 11, 11, 11 receipt_code - null, null, nullobject_code – 41, 41, 42 revenue - 24463.24, 0, 825625.16begin_balance - null, null, nullend_balance - null, null, nullyear - 2007-12[b]Cash_table[/b] building_code - 125, 125, 125 function_code - null, null, null fund_code - 001, 006, 007 receipt_code - null, null, nullobject_code - 41, 41, 42 revenue - null, null, null begin_balance - 206891.77, 0, 424.65end_balance - 764207, -13522.95, 494.65year - 2007-12What 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.Wed, 09 Jan 2013 15:19:47 GMTwtolbert