Based on what I have read, I have another question. How does the OLTP system relate Contracts to Customers since it does not have an apparent FK relationship defined?

Could...

This may not answer your question, but it may help you figure out what you need to do:

create table #RoomData (

Room ...

Without giving away company specific info, can you provide a simple schema of how the tables relate in your OLTP database and in your datawarehouse? This will help me...

May I ask a dumb question first, what is a round robin database?

:unsure:

Or, as this looks like the database is SQL Server 2005, I'd start with the subquery only. When it returns the appropriate data, turn it into a CTE and...

Import the "date" fields (i.e. 100083) as an integer. The following SQL code when run in SSMS will convert the value to a date. You can incorporate this...

The following is untested. I was out on the pitch all day Saturday and Sunday, and didn't have time to create your tables or convert your data into insert...

We are trying to help you. If you take the time to read the article I pointed you to, you would see what we need to be able to...

I'd like to provide you with more help, but you still haven't provided us with the expected output you are looking for from the query. I am not going...

Read this article:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

It will help you figure out what is needed to allow us to help you better.

I realize that for SSIS, some of it may be more difficult, but...

All that is missing now is your expected results when the data is queried.

You are going to have to show me what you are trying to accomplish. Read this article:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

then following what it recommends and post the table DDL, sample data, and...

First question that needs to be answered, does the table you are inserting data into have a primary key that is a part of the data you are inserting? ...

Remember, this code is untested, but you could try this:

SELECT

j2821.RepName,

j2821.LogEntryID,

j2821.Transaction2821ID,

j2821.TransactionPercentOfNetWorth,

...

Please take a few minutes to read the following article:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

It would help if you would provide us with table DDL and sample data. This will allow us to test...