• PIVOT clause in SQL Server

    PIVOT clause in SQL Server
    in sql server (transact-sql), the pivot clause allows cross tabulation to pass data from one table to another.