How To Convert Rows Into Column In Single Select Query SQL Server 2008 R2
<p>How to return the following result on single select query.</p>

<p>Table</p>

<pre><code>Rn  TicketNo    CreateDate               Assigned
1   xxx         2016-11-17 03:45:46.000  Tom
2   xxx         2016-11-18 03:45:46.000  Jerry
1   yyy         2016-11-17 03:45:46.000  Tom
2   yyy         2016-11-18 03:45:46.000  Jerry
</code></pre>

<p>Expected Result</p>

<pre><code>TicketNo    AssignedToTom             AssignedToJerry
xxx         2016-11-17 03:45:46.000  2016-11-18 03:45:46.000
yyy         2016-11-17 03:45:46.000  2016-11-18 03:45:46.000
</code></pre>

<p>Many thanks in advance</p>