If your going to post things like this, you might also take the time to post the reasons

Jeffrey,

As you are probably aware (you ARE an experienced CIO), any RBAR (a "Modenism" for "Row By Agonizing Row", pronounced "ree-bar") is ALWAYS slower than an equivalent set-based operation.  Cursors...

What is the datatype of the column you call "Activity Date"?  I have the sneaky suspicion that it's not a DateTime column and need to know what datatype it is...

SELECT IDENTITY(INT,1,1) AS RowNum,*

    INTO #yourtemptable

    FROM #yourpermtable

Don't forget to add a primary key for speed and accuracy...

The author of the article wrote: "but using temporary table you are increasing disk activity since TV (Table Variable) is created in memory as opposed to Temp tables (created in...

Ummmm.... wanna tell me what version of SQL Server there was that didn't have cursors?

Mike C,

Exactly right and great call.  In fact, there's documented proof that table variables do use TempDB at the following web site and that there are some serious DISADVANTAGES to...

Ah. Got it... very nice work around and thanks for the clarification on the xp_/sp_.  The proc is actually listed as an sp_ in the Master DB but I guess...

I'm thinking that those extra services take up some of the memory that would normally have been available to SQL Server on otherwise identical machines so I'm thinking you're right.

Like I said earlier... the hard knocks code will beat the pants off DTS either way.  Thanks for the feedback Greg.  You can get some extra performance out of SELECT...

>>>These temp tables can then be cursored...

I don't think you understood... the whole idea is to get rid of cursors and other RBAR methods in SQL Server.

>>But for this type of operation, I still think xp_execresultset is the best solution.

The original post was for "Eliminating Cursors" so I have to ask... how do you use it...

Just my humble opinion but I need to clear up some of the myths associated with Table Variables...

First, table variables don't live in memory anymore than temp tables...

Thanks for coming back, John...

Yeah, I saw your original post where you said you had a table with all of the individual possible values.  Your solution looks as though it...

Greg,

I don't know if having the Primary Key on the last column will affect performance especially for CLUSTERED keys... I'd have to study the format in BOL a bit.

However,...