Was able to work it out with some people on another forum

;WITH RowNumsAdded AS

(

SELECT *,RowNum=ROW_NUMBER() OVER (ORDER BY EFTV_Dts)

FROM EFTV

WHERE Prdt_Type='3500'

)

SELECT a.ID, a.Cmpy_Cd, a.Prdt_Type,...