Thanks so much..

Im going to try an dlook into the nolock

??

If there are many Insert into's in the SP

does the @@rowcount only evaluate on the the just prior Insert statement?

Thx

Joe

Sorry being a pain..

would the statement look like this where the tag_name="CUST_RID

INSERT INTO @TEMPTABLE(TAG_NAME,TAG_DATA)

SELECT TAG_NAME = 'CUST_RID',

TAG_DATA =

( SELECT TOP 1 CLIENT_IDENTIFIER

FROM CLIENT_TO_CLIENT_IDENTIFIER_COLLECTION (NOLOCK)

INNER JOIN dbo.CLIENT_IDENTIFIER (NOLOCK) on CLIENT_IDENTIFIER.OID...

thanks for getting back so quick!!

ok so I do want to use the same name I just cut the code that I needed to do the comparisionso I need to...