My Pivot

SELECT *
FROM
(
    SELECT projectallocation.proAllocationID AS Sno,
           temp.intro_name AS IntroTop,
           projectallocation.introtoplevelEmpid AS TopEmp,
           (companystructure.csshortname) AS Level,
           introducermaster.intro_name AS IntroLow,
           projectallocation.introlevelEmpid AS EmpID
    FROM projectallocation
         INNER JOIN dbo.IntroducerMaster ON dbo.introducermaster.empid = projectallocation.introLevelEmpid
         INNER JOIN introducermaster AS temp ON temp.empiD = projectallocation.introtopLevelEmpid
         INNER JOIN companyStructure ON companyStructure.HLevel = projectallocation.introleveID
    WHERE projectallocation.projectID = 1
          AND projectallocation.introleveID = 4
    GROUP BY IntroducerMaster.Intro_Name,
             temp.intro_name,
             companyStructure.CSShortName,
             projectallocation.proAllocationID,
             projectallocation.introlevelEmpid,
             projectallocation.introtoplevelEmpid,
             projectallocation.introtoplevelid
) b PIVOT(MAX(introlow) FOR level IN(ch,
                                     ed,
                                     dir,
                                     gm,
                                     agm,
                                     bdm,
                                     smm)) PVT;
SELECT *
FROM
(
    SELECT projectal