get Row number group by SQL-Server

select

payroll_item,[name],Row_number() OVER(PARTITION BY payroll_item ORDER BY payroll_item) AS 'OBJ_Detail'

from Tempprdetail