WITH CertCTE(CERTStaffID, CERTID, Ranking) AS
(SELECT CERTStaffID,
        CERTID,
        Ranking = DENSE_RANK() OVER (partition BY CERTStaffID, CERTID
 ORDER BY NEWID() ASC)
 FROM Certification)

SELECT c.CERTStaffID,       c.CERTID,
       ISNULL(RIGHT(s.STAFUD01HQTSubject,6),'') AS sub1,  ISNULL(LEFT(s.STAFUDHQTFlag1,1),'')  AS flag1,
       ISNULL(RIGHT(s.STAFUD02HQTSubject,6),'') AS sub2,  ISNULL(LEFT(s.STAFUDHQTFlag2,1),'')  AS flag2,
       ISNULL(RIGHT(s.STAFUD03HQTSubject,6),'') AS sub3,  ISNULL(LEFT(s.STAFUDHQTFlag3,1),'')  AS flag3,
       ISNULL(RIGHT(s.STAFUD04HQTSubject,6),'') AS sub4,  ISNULL(LEFT(s.STAFUDHQTFlag4,1),'')  AS flag4,
       ISNULL(RIGHT(s.STAFUD05HQTSubject,6),'') AS sub5,  ISNULL(LEFT(s.STAFUDHQTFlag5,1),'')  AS flag5,
       ISNULL(RIGHT(s.STAFUD06HQTSubject,6),'') AS sub6,  ISNULL(LEFT(s.STAFUDHQTFlag6,1),'')  AS flag6,
       ISNULL(RIGHT(s.STAFUD07HQTSubject,6),'') AS sub7,  ISNULL(LEFT(s.STAFUDHQTFlag7,1),'')  AS flag7,
       ISNULL(RIGHT(s.STAFUD08HQTSubject,6),'') AS sub8,  ISNULL(LEFT(s.STAFUDHQTFlag8,1),'')  AS flag8,
       ISNULL(RIGHT(s.STAFUD09HQTSubject,6),'') AS sub9,  ISNULL(LEFT(s.STAFUDHQTFlag9,1),'')  AS flag9,
       ISNULL(RIGHT(s.STAFUD10HQTSubject,6),'') AS sub10, ISNULL(LEFT(s.STAFUDHQTFlag10,1),'') AS flag10,
       ISNULL(RIGHT(s.STAFUD11HQTSubject,6),'') AS sub11, ISNULL(LEFT(s.STAFUDHQTFlag11,1),'') AS flag11,
       ISNULL(RIGHT(s.STAFUD12HQTSubject,6),'') AS sub12, ISNULL(LEFT(s.STAFUDHQTFlag12,1),'') AS flag12,
       ISNULL(RIGHT(s.STAFUD13HQTSubject,6),'') AS sub13, ISNULL(LEFT(s.STAFUDHQTFlag13,1),'') AS flag13,
       ISNULL(RIGHT(s.STAFUD14HQTSubject,6),'') AS sub14, ISNULL(LEFT(s.STAFUDHQTFlag14,1),'') AS flag14,
       ISNULL(RIGHT(s.STAFUD15HQTSubject,6),'') AS sub15, ISNULL(LEFT(s.STAFUDHQTFlag15,1),'') AS flag15,
       ISNULL(RIGHT(s.STAFUD16HQTSubject,6),'') AS sub16, ISNULL(LEFT(s.STAFUDHQTFlag16,1),'') AS flag16,
       ISNULL(RIGHT(s.STAFUD17HQTSubject,6),'') AS sub17, ISNULL(LEFT(s.STAFUDHQTFlag17,1),'') AS flag17,
       ISNULL(RIGHT(s.STAFUD18HQTSubject,6),'') AS sub18, ISNULL(LEFT(s.STAFUDHQTFlag18,1),'') AS flag18,
       ISNULL(RIGHT(s.STAFUD19HQTSubject,6),'') AS sub19, ISNULL(LEFT(s.STAFUDHQTFlag19,1),'') AS flag19,
       ISNULL(RIGHT(s.STAFUD20HQTSubject,6),'') AS sub20, ISNULL(LEFT(s.STAFUDHQTFlag20,1),'') AS flag20
FROM CertCTE AS c INNER JOIN Staff AS s ON c.CERTStaffID = s.STAFStaffID AND NOT c.certid = '' AND c.Ranking = 1
WHERE s.STAFUD01HQTSubject > '0'