Crosstab query in SQL Server 2000

Question

I hope someone has tried this before, and I can get some advice before I go any further.

I want to create something similar to a crosstab query in sql server 2000.

I have a table structure similar to the following:

Item       Item_Parameter      Parameter
id         item_id             id
desc       parameter_id        desc
           value

What I want to do is smooth the data using the query / storage procedure to make reporting easier.

An ideal solution will give such results as:

             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   

Answer 1

As a result, I created a stored procedure ( http://www.sqlteam.com/article/dynamic-cross-tabs-pivot-tables ) to dynamically create an sql statement.

Thanks Dan and Andomar

Answer 2

, , group by:

select  item_id
,       max(case when parameter_id = 1 then value) Par1
,       max(case when parameter_id = 2 then value) Par2
,       max(case when parameter_id = 3 then value) Par3
from    item_paramenter
group by
        item_id

min avg max: , item_id,

SQL .