Sorry, it only works if you omit the 'where rank between @iStartRank and @iEndRank' clause.

Regards

Tony Healey

http://www.SQLCoder.com - Free Code generation for SQL Server 7/2000

Hi,

Try the following. I've only tried it on a cut down version of data, so excuse me if there is a syntax error (or two). It seems to work OK.

select...

Hi,

'Read committed' is the default isolation level so you probably won't have changed anything there.

I don't know if you want to set the isolation level to repeatable read or serializable...

Hi,

I am assuming here you want the price for the latest datetime associated with a code.

Try :

select code, datetime, price

from tablename t1

where datetime = ( select max(datetime)

...

Hi,

This is from the BOL, 'SET ANSI_NUllS' entry.

For stored procedures, SQL Server uses the SET ANSI_NULLS setting value from the initial creation time of the stored procedure. Whenever the stored...