• Hi Chris,

    Thanks for your reply.

    could you please help me on making the below query to fetch top 5000 records. currently it only take 6 records.

    SELECT *

    FROM

    (

    select Val,Cat,ROW_NUMBER() over (partition by Cat ORDER BY Empid ) AS Rn

    FROM (SELECT Empid,Empname,CAST(Empsalary as varchar(50)) AS EmpSalary,CAST(Empdesignation as varchar(50)) AS Empdesignation FROM Sample)s

    unpivot (Val FOR Cat IN ([EmpName],[EmpSalary],[EmpDesignation]))u

    )m

    PIVOT(MAX(Val) FOR Rn IN ([1],[2],[3],[4],[5],[6]))p

    ORDER BY CASE Cat WHEN 'Empname' THEN 1 WHEN 'salary' THEN 2 ELSE 3 END

    Help me on making this be dynamic sql

    Thanks