title: Reduce Multiple Recodes in one row from one table without use of agreegate function
body: <pre><code>SELECT * 
          FROM (
              SELECT id, No ,Date, ShiftType, Name, Dsc1, Dsc2 
          FROM xyz        
           ) T1
          PIVOT
          (
              min(ShiftType) for ShiftType IN ([Day],Evening,Night)
          ) AS T2
          ORDER BY No DESC
  </code></pre>
  
  <p>Got This Result from Above query</p>
  
  <pre><code>id | No  | Date       | Name | Desc1         | Desc2         | Day | Evening | Night
  -------------------------------------------------------------
  1  | 101 | 2018-01-05 | Nik  | Day Desc1     | Day Desc2     | Day - -
  2  | 101 | 2018-01-05 | Nik  | Evening Desc1 | Evening Desc2 | - Evening -
  3  | 101 | 2018-01-05 | Nik  | Night Desc1   | Night Desc  2 | - - Night
  4  | 102 | 2018-01-19 | Mgh  | Night Desc1   | Night Desc2   | - - Night
  </code></pre>
  
  <p>OUTPUT Needed As Follows</p>
  
  <pre><code>id | No | Date       | Name | Desc1Day     | Desc2Day     | Desc1Evening         | Desc2Evening         | Desc1Night       | Desc2Night
  -------------------------------------------------------------
  1 | 101 | 2018-01-05 | Nik  | Day Desc1Day | Day Desc2Day | Evening Desc1Evening | Evening Desc2Evening | Night Desc1Night | Night Desc2Night
  2 | 102 | 2018-01-19 | Mgh  | -            | -            | -                    | -                    | Night Desc1Night | Night Desc2Night  
  </code></pre>