• Hi,

    You can create dynamic query for PIVOT and then run it using sp_executesql.

    Best Regards

    Nitin

    http://www.enlinkURL.com

    Regards,
    Nitin