El,

There are many books on learning SQL Server... and I realize you may not know enough about it to ask the kind of questions you probably need answers for...

Take a...

aaa or bbb is the primary key and unique????  Why do they show up in your example data more than once?

I still don't understand...

No... but if you want good help... you have to ask better questions and provide a more reasonable representation of what your data actually looks like.  You'll also find that...

No... because it can't be done.  If you don't have triggers to force the update of ModifiedOn and ModifiedBy columns in every table, there's nothing you can do.

LOL... not a problem... you should see what I miss before my first cup of coffee

Tracey,

What's going to be really hard is when you get all of this figured out and realize that all the load balancing you're trying to do with TempDB is nothing...

If the data "mirrors some of the issues", then the data might really have a problem.   Yes, your code does work... but it's...

Would you care to post your solution, please?

Yes, I do... why do you have different product names for the same ProductID's?

Heh... I'm no stats Ninja, either... but it's a heck of a lot more random with fairly even and unpredictable results over both small and large ranges of data than the...

You know me, Ryan... extraordinary claims require extraordinary proof... got code to prove that?

I don't see any records in your post...

Yes, there are some tables that know exactly which rows have changed... trying to teach you to "fish" a bit... read about "Triggers" in Books Online.

What say the da?

When I first started to read this, I thought "Jeez... that's a little obvious, Andy.  Hardly worth an article."   Now that I see...