This is about 3 years too late, but it worked for me:

SELECT [Field1]

, ROW_NUMBER() OVER (ORDER BY [Field1]) AS 'Row Number'

FROM [dbo].[MyTable]

I've been a lurker on this site for at least 3 years. It's amazing on the extremes this article produced. It's almost reminiscent of the 1992 campaign when...

quote:

---

I found it interesting that the email received had the correct DESC (second choice) but on the website the DESC was missing....

quote:

---

Do you still have Outlook or some other (maybe non-Exchange) mail client installed?

---

Yes, Outlook is...

The poor sods that got the question wrong may deserve bonus points for honesty. You KNOW these people aren't peeking in BOL or the forum ahead of...