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 ∞ +1 518-641-1280 ∞ This email is: [ ] bloggable [x] ask first [ ] private ∞ Google me: http://www.google.com/search?q=("andrew badera") OR ("andy badera") On Sat, Sep 5, 2009 at 9:55 AM, Yonggang, Meng<[email protected]> wrote: > > ROW_NUMBER() OVER(ORDER BY [column name]) is what you want. > > On Sep 4, 9:12 pm, san <[email protected]> wrote: >> How can i get the row number in which record is stored in sql server. >> >> Example: suppose if record is stored in fifth row i want output as 5. >> >> Thanks! >
