;WITH CTE AS
(
   SELECT
      ROW_NUMBER() OVER (PARTITION BY r.userId,r.programmeId ORDER BY r.dateExpired DESC) AS RN,
      r.userId,
      r.programmeId,
      u.email,
      u.firstName,
      u.lastName,
      u.profileId,
      tblProgrammes.name,
      u.storeId,
      r.dateEnded AS lastPass,
      r.dateExpired
   FROM
      tblUserRepeatHistory AS r
      INNER JOIN tblUsers AS u
         ON  r.userId = u.id
      INNER JOIN tblProgrammes
         ON  r.programmeId = tblProgrammes.id
   WHERE
      (r.dateExpired IS NOT NULL)
      AND (u.storeId = @storeId)
)
SELECT * FROM CTE WHERE RN = 1;