Hi osxman, I've updated my reply. It should work.

Try this: 

SELECT a.EmployeeId, a.Forename, a.Surname, a.DateOfBirth, a.leaver, a.EmployeeStartDate, a.LeftDate,
        row_number() over (partition by a.forname, a.surname, a.dob order by a.empid) as rn, b.count_reemployed
FROM (
SELECT *, ROW_NUMBER()...

Great! Thanks a lot.

Thanks. The front end is custom by developers. It was suggested that the stored procedure needs to be updated to use the linked server to connect to the database. There...

I tried to add SET ANSI_WARNINGS OFF, but executing the stored procedure raises this. "

August 8, 2018 at 6:46 am

#2000776