Ahh I see... I didn't provide you with my final corrected Pseudo code:

update dbo.mytable

set

 mytable.one = source.uno

,mytable.two  = source.due

,mytable.three  = source.tre

from 

 #mySource source

where

  mytable.dte = source.dte

and

 source.type = 'SELL'

I assumed you saw the above and were...

Please, why so?

Ahhh, I think I have it:

CREATE TABLE #mySource (

 dte      varchar (8)

,uno      int

,due      int

,tre       int

,type     varchar(4)  )

INSERT #mySource (

 dte    

,uno

,due

,tre

,type)    

EXECUTE [dbo].[myStoredProcedure] GetDate()

update dbo.mytable

set

 mytable.one = source.uno

,mytable.two  = source.due

,mytable.three  = source.tre

from

 (exec [dbo].[myStoredProcedure] GetDate())...

Thank you both for very considerate responses.

To stay in line with the other objects I've created, I believe that I prefer the temp table approach... How would that work considering...

I believe that I read something like that just recently while researching the problem: that the records may not have inserted as I wrote them.

However, I DID use a clustered...

That was kinda my point in posting originally.

Assuming all records went into table sequentually as written, the first 14 mil would have been the first batch and anything later would...

BCP?

I loaded 14 million rows and then loaded an additional 1.5 million rows.

TOP would better be classified as FIRST

A late breaking requirement was to...

Jaret:

Your solution is wonderful but from the start, my requirement WAS to consider the update sequentially.

I must update the FIRST or TOP 14...

Yes, the plan is to process a small table first then to move on to bigger issues.

However, Assuming I wanted to update a 20,000 row table and chose to break...

OMG!  I just lost my first reply as well!

I had a clustered index on a field that is hit often and produces a sizable recordet.  From that sense, the index...

OMG!  This is probably NOT the best way of doing it but I was desperate

I added an IDENTITY column to the table @ last...