Thanks g.britton for the useful response. It'll give me something to read up on.

Do you answer posts just for the sake of building up your points or something? What you ask for is irrelevant. The question is in regards to the...

The question is about the joins. Not the actual data. If I presented you with all the scripts involved, it'd take you a couple of days to sort...

You guys are making this more complicated. Forget the values. They are random and meaningless. Forget about trying to make an efficient route, I do not care...

The part is the part #. The initial data set is all the customers with that part. What the part is doesn't really matter either except that they do...

All that has been cleaned up now. I was hoping there was a log somewhere to show some history with a login and a time. My theory is...

I know it's their DBA, but just because of a process of elimination as no one else would be adding replication. The problem is that their SR DBA isn't...

I should also note that I do not have all the permissions to read logs and such. I'll just be passing on some recommendations and maybe looking over someone's...

Scott's suggestion looks good.

What I was looking for, and I am probably not drawing a decent picture, is a way to get a value out of multiple columns...

sqlvogel (11/25/2013)

---

Sorry but if you care about what...

sqlvogel (11/25/2013)

---

Use ROW_NUMBER() for surrogate key assignment and order on the natural key. As long as you receive the same data set each time the surrogates will be the same.

Better...

Let me add a note here. This has to do with an ETL process. I'm taking the data from the source and creating a table on the destination....

The reason I am creating a surrogate is because I need a KEY field.

I can't use the identity because now and then records are added or removed. Using identity...

that seems to have done the trick.

thanks

great thanks.