Complex view

Hey everyone

I have the following tables

Attribute_Set
==========
Category_ID|| Attribute_ID || Attribute ||

1 1 Color
1 2 Condition
1 3 Shape

… … …


Data_Set
=========
Item_ID|| Attribute_ID || Data

131 1 Red
131 2 Broken
131 3 Cube
… … …

Now I want to create a view that creates columns from the Attribute_Set - Attribute value, to be more specific I need a view like this

Item_ID || Color || Condition || Shape || ….|| ……….

131 Red Broken Cube

…. …. …. …..

The view must create it’s columns from the Attribute_Set table, because new attributes may be added.

I have written a stored procedure that returns

Item_ID || Attribute || Data

131 Color Red

131 Condition Broken

……

How can I create the above described view?

Thanks for your time