Ranks CustomerID and Sales Order number by Total due (Using the AdventureWorks2012 database):

select

h.CustomerID,

h.SalesOrderNumber,

h.TotalDue,

rank() over (order by h.TotalDue desc) as TotalRank

from Sales.SalesOrderHeader h

So to clear things up I have a param @mgrFlag that captures the permission from the app.

Orginailly I had this:

If not exists(select 1 from EmployeeAssocTable where EmployeeID = @EnteredForEmpID and...