The major subject of our database is PRODUCT.
PRODUCT has hunderds unevenly distributed attributes known for us
and hunderds not yet defined.
The following shema has been proposed to solve problem of undefined attributes.

PRODUCT table
*ProductID
ProductAttributeID
ProductAttributeValue

PRODUCTATTRIBUTE table
*ProductAttributeID
ProductAttributeType
ProductAttributeDescription

Customer can easily define new attribute by adding new record to PRODUCTATTRIBUTE table.

QUESTION : How to build the VIEW where values from ProductAttributeDescription would be
the column names and ProductAttributeValue would be row value

ProductID | ProductAttributeDescription (1) | …………….. | ProductAttributeDescription (N)
1 ProductAttributeValue ProductAttributeValue
2 ProductAttributeValue


Any comments greatly appreciated

Thanx

Alex