How can i write an sql query (under MS sql server) that enumerates each row that was recieved from the query
there should be no need to. As you iterate through the result set, increment a counter to keep track of which row you're on.
Tom