I am hoping that someone has attempted this before and I can get some advice before I go any further.
I am looking to produce 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 am looking to do is to flatten out the data through a query/stored procedure to make building reports easier.
The ideal solution would produce results such 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