title: sql command which help me to group by or any other query
body: <p>I have the following query </p>
  
  <pre><code> select a.EmpId,AttenDate,status 
   from dbo.Attendance as a
        inner join dbo.employeemast as e
        on a.empid=e.empid
   where e.EmpWeekOfType='V'`
  </code></pre>
  
  <p>It gives me:</p>
  
  <pre><code>1500011 2014-08-31 00:00:00.000 A
  1500011 2014-09-01 00:00:00.000 A
  1500011 2014-09-02 00:00:00.000 A
  1500011 2014-09-03 00:00:00.000 A
  1500011 2014-09-04 00:00:00.000 A
  1500011 2014-09-05 00:00:00.000 A
  1500011 2014-09-06 00:00:00.000 P
  1500011 2014-09-07 00:00:00.000 A
  1500011 2014-09-08 00:00:00.000 A
  1500011 2014-09-09 00:00:00.000 A
  1500011 2014-09-10 00:00:00.000 A
  1500011 2014-09-11 00:00:00.000 A
  </code></pre>
  
  <p>I want to arrange the row with this format:</p>
  
  <pre><code>150011 | 2014-08-31 00:00:00.000|2014-09-01 00:00:00.000|2014-09-02 00:00:00.000.... 
                      A           |         A ........
  </code></pre>
  
  <p>Please suggest me a query??</p>