Well the results previously provided where done by another ETL developer and are from a different state. I'm using those results as a guide as how to go forward....

Thank you J. below is the desired output taken from a different data set that I'm looking for.

onclick:if_IFCode('CREATE TABLE [dbo].[RAW_Financial_desired_output](

[district_code] [float] NULL,

[FUND_CODE] [float] NULL,

[BEGIN_BALANCE] [float] NULL,

[END_BALANCE] [float] NULL,

[YEAR] [float]...

bump

PK is district_code with fund_code being a foreign key for all 3

function_code and object_code are foreign keys for expense

receipt_code being a foreign key for revenue

Thanks Craig.

CREATE TABLE [dbo].[RAW_Financial_revenue_test](

[year_time] [varchar](100) NULL,

[district_code] [varchar](150) NULL,

[district_name] [varchar](150) NULL,

[FUND_CODE] [varchar](150) NULL,

[fund_description] [varchar](150) NULL,

[fund_type] [varchar](150) NULL,

[source_data] [varchar](250) NULL,

[source_state] [varchar](100) NULL,

[function_code] [varchar](150) NULL,

[function_description] [varchar](150) NULL,

[source_code] [varchar](100) NULL,

[source_description] [varchar](150) NULL,

[receipt_code] [varchar](100) NULL,

[receipt_description]...

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

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

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