For a little background, the view is performing a JOIN on another table, then grouping ... basically a pointer to the row number of the results. To do this in MS SQL Server, add the following ...