SQL Server 2005 Adding Counter to Query
I need this functionality sporadically, but can’t ever remember what the function is called to add a row counter to a query, aka similar to an identity column. The function you’re looking for is called ROW_NUMBER() along with an OVER() function, e.g.
SELECT ROW_NUMBER() OVER (ORDER BY day ASC, hour ASC) cnt, * FROM <table name>
