pivot table in sql server

See more:

SQL-Server

SELECT
    kat."bez", leisthis."epreis"*leisthis."anzahl" as payment,
    source."gruppe",
    ptypgrp."rategrp"
FROM
    { oj (((("protel"."proteluser"."kat" kat INNER JOIN "protel"."proteluser"."zimmer" zimmer ON
        kat."katnr" = zimmer."kat")
     INNER JOIN "protel"."proteluser"."leisthis" leisthis ON
        zimmer."ziname" = leisthis."zimmer")
     INNER JOIN "protel"."proteluser"."ptyp" ptyp ON
        leisthis."postdetail" = ptyp."ptypnr")
     INNER JOIN "protel"."proteluser"."source" source ON
        leisthis."source" = source."nr")
     INNER JOIN "protel"."proteluser"."ptypgrp" ptypgrp ON
        ptyp."ptypnr" = ptypgrp."ptgnr"}

i wanna pivot on kat.bez and source.group
like this
"""""" """ source1 """" source2 """" source3
kat.bez """ payment1""" payment2 """ payment3