title: Cross Tab Query Required SQL 2000
body: <p>I have already googled for this </p>
  
  <pre>
    <code>
   I have a Table with following structure in SQL 2000
  
   ID ContactName Designation
   1  A           CEO
   2  B           ABC
   3  C           DEF
   4  D           GHI
  </code></pre>
  
  <p>I need the Output as follows</p>
  
  <pre><code>
  ContactName1 Contactname2 ContactName3 ContactName4
   A CEO        B ABC         C DEF         D GHI
  </code></pre>
  
  <p>Any Suggestions ? </p>