How to query and display data as a matrix?
<p>My query :</p>

<pre><code>SELECT *
FROM   
    (SELECT  
         t.Description,
         ISNULL(COUNT(e.EmployeeCode), 0) 
     FROM    
         Employee AS e  
     INNER JOIN 
         Department AS d ON e.DepartmentCode = d.DepartmentCode
     INNER JOIN 
         TermReason AS t ON e.TermReasonCode = t.TermReasonCode  
     WHERE   
         e.terminationdate IS NOT NULL
         AND e.TerminationDate BETWEEN @PeriodStartDate AND @PeriodEndDate) s
PIVOT   
    (COUNT(EmployeeCode) FOR description IN 
        ([Finance], [Human Resources], [Nursing])) pvt
</code></pre>

<p>My expected results are:</p>

<pre><code>Termination Reason Department1 Department2 Department3 etc etc
---------------------------------------------------------------------
    aaa       value1       value2        value 3           value4
    bbb       value1       value2        value 3           value4
    ccc       value1       value2        value 3           value4
    ddd       value1       value2        value 3           value4
</code></pre>