Pivot-SQL

-- http://dba.stackexchange.com/q/113131/8783
-- try using OPTION (MAXDOP 1) as well to measure performance
SELECT  *
FROM (
    SELECT top 100 codCliente
        ,Resposta
        ,NrQuestao --,COUNT(1) as Qtde
        ,(
            SELECT COUNT(1) AS qtde
            FROM tblRespostaINT T2
            WHERE T2.codCliente = T0.codCliente
                AND T2.codNrQuestao BETWEEN 9
                    AND 29
            ) AS QResp
    FROM tblRespostaINT T0
    INNER JOIN tblQuestao T1 ON T0.codNrQuestao = T1.codNrQuestao
    WHERE T0.CodQuestionario = 1
        AND T1.codNrQuestao BETWEEN 9
            AND 29
        ORDER BY codCliente --- ORDER BY !!
                --and codCliente = 5156
                --Group by codCliente, Resposta,NrQuestao
    ) AS tblx
Pivot(SUM(resposta) FOR NrQuestao IN (
            [I_1_P14_1]
            ,[I_2_P14_1]
            ,[I_3_P14_1]
            ,[I_4_P14_1]
            ,[I_5_P14_1]
            ,[I_6_P14_1]
            ,[I_7_P14_1]
            ,[I_9_P14_1]
            ,[I_10_P14_1]
            ,[I_11_P14_1]
            ,[I_12_P14_1]
            ,[I_13_P14_1]
            ,[I_14_P14_1]
            ,[I_15_P14_1]
            ,[I_16_P14_1]
            ,[I_17_P14_1]
            ,[I_18_P14_1]
            ,[I_19_P14_1]
            ,[I_20_P14_1]
            ,[I_21_P14_1]
            ,[I_22_P14_1]
            )) tbl