Dang... you're right Lynn... I was blazing through a bunch of these and didn't read all the posts. My appologies. Thanks for the feedback.

Matt Miller (7/21/2008)

---

I keep trying to look at the bright side. The ETL is process some 10,000...

Christopher Stobbs (7/22/2008)

---

HI Jeff,

I think he doesn't mind which is returned if they are all different.

I added an extra ordering to my rank query so that the first is returned...

Heh... well that worked well... wanna borrow some porkchops? 😛

What was the...

Awesome articles, Gus... dunno how I missed the second one, but I just read it. Really nice job.

My only suggestion to everyone is to NOT audit inserts. The...

Somehow, I missed this article before. Awesome job, Gus. Huge amount of good info and some great technique comparisons!

Also, I gotta know because this is not a run of the mill request... I've only seen one other time when this was needed... a customer could have two identical...

Heh... I'm thinking the folks that were good enough to help, so far, may take offense to...

nealwright44 (7/21/2008)

---

This is for Christoper's first reply above...

In the first example, records 1,2,3 & 5 have the same Address value, therefore 'Mcmullen Road/N /n/nDarlington/nDurham' must be returned as it's...

Jack... after you get done building it, change all the Addresses to 0 for where the...

lallen (7/21/2008)

---

I've created a temporary table using select into statement, and called the table #Table1 (for example). But I can't get the syntax right to pull the information out...

I'm walking into a new job similar to that on Monday...

Heh... look how many people are doing homework with no try from the op... 😉

The real problem is that you need to identify why it is full, first.