Recently, I created a report using SSRS and i found ROW_NUMBER() can be very useful in rank-related tasks.Here is a sample query using AdventureWorks database. Select ProductID, ReorderPoint , SafetyStockLevel,ROW_NUMBER() OVER (order by ProductID) as RowFROM Production.Product&n...
[More]