line numbering in result set

Does anybody know how I can get a row count in the result of my query.
So first column should be 1, 2, 3 ...
Thanks,
BoontjeSince you appear to be using Microsoft SQL Server, I'd take the suggestion from Kaiowas in your posting (http://www.dbforums.com/t1095025.html) in that forum. You may get a lot of confusing answers here from people that don't know which database engine you are using.

-PatP|||FYI duplicate posts in multiple forums will be deleted

:)