title: Concrete Rows of Id 2 with Id 1 IF Date is Same and All Row Names Should be different in SQL Server 2008R2 and
body: <p>I have following Data in myRecords Table</p>
  
  <pre><code>Id     Date                 Name     Cash
  1   11/25/2016 4:23.123     Ramesh  10000
  2   11/25/2016 4:23.173     Suresh  15000
  1   11/27/2016 5:23.320     Ramesh  30000
  2   11/27/2016 5:23.670     Suresh  40000
  </code></pre>
  
  <p>and I want to create view So I can  get data in following Format</p>
  
  <pre><code>Id1 Date1               Name1   Cash1   Id2 Date2               Name2   Cash2
  1   11/25/2016 4:23.123  Ramesh 10000   2   11/25/2016 4:23.173 Suresh  15000
  1   11/27/2016 5:23.320  Ramesh 30000   2   11/27/2016 5:23.670 Suresh  40000
  </code></pre>
  
  <p>How can I do it.</p>