title: Crosstab Query in SQL Server 2000
body: <p>I am hoping that someone has attempted this before and I can get some advice before I go any further.</p>
  
  <p>I am looking to produce something similar to a crosstab query in sql-server 2000.</p>
  
  <p>I have a table structure similar to the following:</p>
  
  <pre><code>Item       Item_Parameter      Parameter
  id         item_id             id
  desc       parameter_id        desc
             value
  </code></pre>
  
  <p>What I am looking to do is to flatten out the data through a query/stored procedure to make building reports easier.</p>
  
  <p>The ideal solution would produce results such as:</p>
  
  <pre><code>             Parameter.desc[0]      Parameter.desc[1]      Parameter.desc[3]...
  item.id[0]   Item_Parameter.value   Item_Parameter.value   Item_Parameter.value
  item.id[1]   Item_Parameter.value   Item_Parameter.value   Item_Parameter.value   
  </code></pre>