Yes... sp__ will still go to MASTER first because it still contains sp_ as the first 3 characters.

Yes, you can do this without a function... it'll be a bit (maybe...

Ah... Matt's right... I left out a step... I should have said to insert all your missing rows into YourTable first, then run my code... don't need to add extra...

You know... that's a much better answer...

Roger that... still shouldn't matter but "can do"...

This obviously won't work if foreign keys exist...

First things first... make a "backup" of the table...

Jude,

What are you actually using?  Using CAST(anynumber AS MONEY) always results in 4 decimal places, not the 2 that you claimed it does...

Wow... lot's and lot's of suggestions... but I've gotta ask... the code runs almost instantaneously in QA even when there's not enough qualifying rows to satisfy TOP but causes the GUI to...

Mick,

Yeah, it can be done but I gotta ask... doesn't the ID field mean anything?    If you do this, any joins that reference...

The connections are not active and, therefor, nothing you really need to worry about.

Because of the contraints you have in the CTE, you might not even need MIN in the sub-selects.

Copy a quote from an existing post... paste it to yours... edit the quote using CPR (Copy, Paste, Replace).

Very nicely done, David, and a lot closer to set based!  And you even remembered the brackets for "odd" table names that I forgot  ...

It's a naming convention... see the following for more details...

http://en.wikipedia.org/wiki/Hungarian_notation

... and, it makes beer taste bad

Or...

Create a view or a reporting table and use Excel's "Get External Data".

Serqiy is spot on... a split function will make this easy and quite fast even without indexes.  But... before we can make a decent split funtion, we need a little...