I use window functions all the time now when working with inherited databases:

CREATE VIEW vAssisterCert AS

WITH DuplicateACStatus AS (

SELECT RN=Row_number() OVER (Partition BY EnrollmentEntityAssisterId ORDER BY UpdatedDate DESC), EnrollmentEntityAssisterId, CertificationNumber,...