Haven't tested it but learned a long time ago never to mix aggragation and formatting in a single select...

 SELECT d.Cases,d.Status

   FROM

        (

        SELECT

        count(r.status_id) As...

Peter,

Now you know why I asked...   was pretty sure the Order By wouldn't do it...

Heh... that's funny... but I get what Peter is suggesting with that simple query... pass the data to the client box and let the client box work on the solution. ...

Will that put it in the order the OP requested?

Chris,

Turn that SELECT into a CTE instead of using a table variable...

Heh... I love it, Serqiy... thanks for the great laugh

Dang... I still don't have access to SQL Server 2005 ... I love the CTE's that use that wonderful Rownumber Over Partition...

Antonio... can you tell us how long that took...

I did read that post... pretty well thought out and glad to be part of those thoughts.  You covered a good number of the points that I was trying to...

Heh... wise old fellow once said "To measure something is to change its state."  No exception with SQL... sometimes, ya just gotta bite the bullet to find out what's going...

Heh... I'm all for that especially with present company

What did you end up with, David?

Tomm's code for an upsert is good... think I'd do it in a stored procedure rather than DTS, but it'll do the trick either way.

I still use BULK INSERT and...

Heh... you're welcome, Chris...

But that's just step one... (make it work)

Here's the code to generate a million row test table for step two... (make it work fast)