Thanks to all.

Thanks Kathi and Aaron.

Assuming that the indexes are defined properly, is there a better way to delete the rows?

The problem with this is, between select and update there is a possibility that the flag and value might be changed by some other user.

Hi Phil,

After executing the below I need to get the values of batchno and detailno.

UPDATE detail

SET flag = 'A'

FROM (

SELECT TOP 1 d.batchno, detailno

FROM detail AS d

INNER JOIN batch AS...

I changed the stored procedure as follows and it works fine now.

DECLARE @batchno varchar(15)

DECLARE @seqno int

SELECT TOP 1 @batchno = d.batchno, @seqno = seqno

FROM detail AS d WITH (UPDLOCK,...

Yes, the date on the MDF file is modified each time a block is written.

don1941 can you tell me what those undocumented stored procs are.

Previously we used an ISAM DB, I am trying to migrate to SQL server with minimal changes.

I have all the DB access done in a DLL and other applications call...

My understanding is that SQL Server sends the raw data and the column information like the name of the column etc which is used by the client applications to display....

I have a structure which exactly matches the DB row, so if I am able to get the raw data directly I can just copy it to my structure instead...

Thanks Mathew. It works!!!

Sorry.

The test data should be

batch (integer) value (integer)

100,1

101,1

102,1

103,2

Maheswar, your SQL will give me both 10000 & 10001. I need only 10000

Thanks Solart for your suggestion.

To over come this error I had to change the "Startup service account" from "system account" to a valid domain account.

Senthil.

Thanks.