And then comes along a merger, and your unique OrderNo/CustomerNo/InvoiceNo whatever is no longer unique as you have to merger both companies data into a single database. It comes...

You mentioned pulling the data from both SQL Server and the mainframe, if the layout of the data from the mainframe the same as in SQL Server?

😎

More than one. You also have the variations on the name as well: John Smithe for example. Is it really Smithe or is it a typo and should...

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