can i create dynamic headers....:-)

SELECT paymentID, [ASD], [BG],[SD]

FROM (SELECT paymentID,

CASE receivedType WHEN 'Dr' THEN Amount ELSE -1 * Amount END Amount, Reason

FROM Payment) AS SourceTable

PIVOT ( Sum(Amount)

FOR Reason IN ([ASD], [BG], [SD]) ) AS PivotTable; //Here can i put SELECT statement for Dynamic Headers..