This issue has come up several times recently and to the best of my knowledge, under sql server 2000, you cannot read the prior value of a row once the update...

Michael,

I'm not sure why UPDLOCK seems to help in this situation but so be it. 

One potential problem now is that between the time you Insert into @SelectedId and the...

Michael,

It looks like you are setting the isolation level to Repeatable Read, selecting rows and then returnng to the client.  I'm not sure but this may be leaving shared or...

Repeatable Read looks to be the correct isolation level for the situation you described. 

The use of HOLDLOCK will only make the situation worse as this would raise he isolation...

Ron - at some point if someone decides to place the clustered index on another column then that's the one that will be "ordered by" IF THERE ARE NO OTHER...

You cannot depend on any index to return the data in any specified order for at least these two reason:

1) Your are depending on the current retrieval implementation method of...

Also from this site:

ALTER procedure sp_FindText @SearchText varchar(100)

AS

/*

Acknowledgement: Okie_Greg

Source: http://www.sqlservercentral.com/forums

Location: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=102649&p=2

Date: 21-Apr-04

*/

SELECT sysobjects.name AS 'Stored Procedure'

FROM sysobjects,syscomments

WHERE sysobjects.id = syscomments.id

AND

sysobjects.type = 'P'

AND

sysobjects.category=0

AND

charindex(@SearchText,syscomments.text)>0

RETURN

And just to add my $.02.  From Book Online:

ORDER BY order_list [ ASC | DESC ]

The ORDER BY clause defines the order in which the rows in the result...

I don't know if this matters but I did this install just the other day I remember using

SAPWD=myPassword

That is without the qoutes around the password.

This thread may help.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=181044

Another example from the Frank Kalis article.  How to strip the time from the date (replace Getdate() with any datetime value):

SELECT

DATEADD(d,DATEDIFF(d,0,GETDATE()),0)

------------------------------------------------------

2005-03-23 00:00:00.000

For full explanation read the article found...

Here's an example from the Frank Kalis article mentioned aboved.  For a full discussion on working with sql server dates please read the article.

SELECT

CustomerID

, OrderDate

FROM

Orders

WHERE

OrderDate >= '19960704'

AND

OrderDate < '19960705'

The between operator is inclusive so you do not want to use it in this case.  You would need to do something like:

where... col_date >= @date and < @date...

Is there anything that currently makes these rows unique?

I haven't tested this but you can give it try.

Update YourTable

set MemberSeqNbr =

 (Select ISNULL(max(MemberSeqNbr),0) + 1

  From YourTable yt

  Where yt.MemberNumber = YourTable.MemberNumber)

Where MemberSeqNbr IS NULL

Edit: added isnull to...