Hello, is it possible to generate pivot table?

I considered to create temporary table and insert data (both in stored
procedure) but unfortunately stored procedure can't use DDL.


Regards
Ryszard Lewandowski.