SQL Server: Using ROWNUMBER to Apply Ranking
I have a set of records for employee utilization, and I wanted a quick way to rank them from highest utilization to lowest utilization. It turns out that the ROWNUMBER() function did exactly what I needed. Here is an example of my data: ConsultantName UtilizationPercent Consultant A 100.5% Consultant B 87.4% Consultant C 95.0% Consultant…