SQL SERVER: How can I enumerate the rows of a select statement with union operator, but without restarting the count, without duplicity and without subselect? Is it possible? I need something with performance. I got it with subselect and the function ROW_NUMBER(), but I need something faster. Any idea? Thanks!SQL SERVER: How can I enumerate the rows of a s