Thank you all very much, it is very much appreciated.....

Have a great day everyone...

Rich

Thank you John, I didn't think it was doing much either and couldn't figure out why it would maintain the lock...I'll try to indexing....

Thanks again,

Rich

Thank you very much, that was a huge help and I have it working as desired.

Thank you all, it is very much appreciated...

Rich

Found the problem, I'm just an idiot...

Put the stored procedure on an MSDE box, not SQLServer ....jeez...tgif...