Add a row count to query results in Microsoft SQL 2005

Have you ever wanted to have a row count as a column in sql output?
Well, I have for a number of different reasons and this is how I found to do it.

ROW_NUMBER() OVER(Order by ‘SomeColumn’) as seq