I kinda agree with Andy. Why is the position of the record in the database relevant at all ? I think the OP should reconsider his/her scenario.
Also, the ROW_NUMBER function is only available in SQL Server 2005 and newer. Since the OP has not specified their SQL version, I would be more cautious suggesting the use of this function. On Sep 6, 6:00 pm, Andrew Badera <[email protected]> wrote: > Hey everybody, > > Think the OP could use ROW_NUMBER? Maybe? Is it possible? (It's like a > broken record in here.) > > But is it exactly what the OP is looking for? Really? Is it? > > ∞ Andy Badera
