reverse pivoting

Is there systematic approaches in data warehousing to do the following

converting table Pivot (customer, product, amount) -- many rows per customer

into table RPivot (customer, prod1Amt, prod2Amt, ... prodnAmt) -- one row per customer

the columns in the RPivot table are the unique values in the Pivot.product column.

I am interested in a pure SQL way.

Thanks. Received on Mon Mar 11 2002 - 17:39:54 CST