Hi , I have multiple records for an employee in a table. I want to dispplay a 1 for the max sales value and a 0 if not max for each employee. Can you tell me how to do this using a case statement or some other way. Thanks

The easiest way would be to use RANK OVER Partition to add a column in your data listing the rank of the sales value in desc order. Then you could use a case statement to check for rankcolumn = 1Chuck

Something like this: SELECT employeeID , SalesValue , MaxSalesValue = CASE WHEN RANK() OVER (PARTITION BY EmployeeID ORDER BY SalesValue DESC) = 1 THEN 1 ELSE 0 END FROM YourTable Chuck

Thank You for the help!!!