I have also done it before using temp tables with a identity field.  The purpose of the post above was someone needed it in a straight select statement.

Thanks for the reply!