Thank you for your help and time. 

Regards

Oscar

  What I did was create a DTS package.  It has an Active X task that creates the Excel object and the fields it on success it goes to sql...

 Both are very helpful.  It's gets you think about the different solutions to a problem. I'll keep plugging away at TSQL until it sets in. Thanks for your time.

Phil, Thanks.  I was making more complicated then I needed to.  I thought, I needed to count the number of seq for the client and then assign the number of...

I believe I might have found a way.  I just added TOP 1 to my query.  Will this work or is there a better way.  Thanks