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

Thanks, Josef... I'm on my way to work... will take a whack at it tonight.

Forgot to ask... can you provide a couple of file names from each directory?  And, Lowell...

Actually, it does...

    IF OBJECT_ID('TempDB..#tablename','U') IS NOT NULL

  DROP TABLE #tableName

Nisha,

Why the conversions?  2 is already an INT and RowID is likely an INT if the column is an IDENTITY column...

Yes... it IS a lie... and there is no lower form of life than someone who lies especially on a resume.  But, it's not that person's fault they (s)he got...