Adding sequence number to a query

[Tony1258]

I have a query that captures date values from a table based on a between function that works fine. What I would like to do is associate a sequence number fro each date value returned and either perform a make table or leave it as a select query. If I create a table I know that I aam able to add an autonumber field but the query is executed frequently and performing the addition of the autonumber field is not feesible. Any thoughts how I can generate the sequence number each time the query is executed?

Thanks

 

[WayneRyan]

Tony,

http://support.microsoft.com/kb/94397

Wayne

 

[RoyVidar]

Here's a SQL suggestion, only considering the date and ranking

SELECT t.myDate, (
    SELECT Count(*)
    FROM myTable s
    WHERE t.myDate <= s.myDate) as myRank
FROM myTable t

 

[Tony1258]

Thanks for the reply I will give it a shot