I guess I don't fully understand the goal here. If your goal is to have the count for an employeeID on each record for that corresponding employeeID. You can do LEFT JOIN(Table) LOAD COUNT(employeeID) As [EmployeeID Count] Resident [Table] GROUP BY EmployeeID; Then Join this table to your original table on EmployeeID. If labeling in the order of records is the goal I would utilize a peek function.
Thanks Sunny. Worked perfect. The problem was we had the same employee with multiple service violation dates and we only wanted the first one. So the rowno worked perfect resetting it for each employee.