Juntar campos para select

SELECT *,
      (SELECT
            CASE (SELECT
                    COUNT(c.name)
                  FROM
                    sys.sysindexes I, sys.sysindexkeys IK, sys.syscolumns C
                  WHERE I.id = IK.id
                    AND I.id = c.id
                    AND I.indid = IK.indid
                    AND IK.colid = C.colid
                    AND I.id = (SELECT id FROM sys.sysobjects WHERE xtype = 'U' AND name = NOMETABELA)
                    AND IK.indid = 1
                    AND C.NAME = S.COLUMN_NAME)
            WHEN 0 THEN ' ' ELSE 'Chave Primaria' END) CHAVE
    FROM
      INFORMATION_SCHEMA.COLUMNS S
    WHERE
      TABLE_NAME = NOMETABELA