Okay. And, tell me if I am wrong, this also leads to another potential problem in the data. I could be in there multiple times as Lynn Pettis,...

Quite simple really, I'd put an alternate index (unique) or a unique constraint on CountryName.

😎

majorbloodnock

Isn't the 19th century when psychiatry came into being with people like Freud?

😎

That looks like laziness on their part. They obviously didn't want to take the time to analyze the data that would be stored in the varchar fields so that...

Jeff,

It may not be your job to evaluate peoples code, but I personally take it as a great compliment when you have complimented me on my code. I'm sure...

Try this code. It is untested as you did not provide the DDL or any test data.

with TestDate (

PersonNumber,

EntryDate

) as (

select

...

Jack,

I didn't take it as a criticism. The more detailed the request, the more info provided about what has been tried, and what is expected, the more likely you...

Jack Corbett (2/26/2008)

Lynn Pettis (2/26/2008)

Jeff,

Thanks for the comment. ...

Jeff,

Thanks for the comment. Sometimes it isn't giving...

Okay, that helps. But to paraphase a bit to be sure:

Contract is being split into Customer, Address, and Contract in the DW.

Is this correct?

Edit:

Also, can a single customer have...

Matter of preference I guess. I find cte's help me keep the code cleaner actually instead of using derived tables in the FROM clause. Keeps it more like...

For your perusal, some more code to play with:

create table dbo.RoomData (

Room smallint,

XDate ...

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...