see illustration belowdeclare @t table(Empno int,Ename varchar(10))insert @tvalues(10, 'Raju'),(20, 'Ramu') select cat,MAX(CASE WHEN seq=1 THEN value END) AS Val1,MAX(CASE WHEN seq=2 then value END) AS Val2from(select *,ROW_NUMBER() OVER (PARTITION BY cat ORDER BY value) AS Seqfrom (SELECT CAST(Empno AS varchar(10)) AS Empno,Ename FROM @t)tunpivot (value for cat in (Empno,Ename))u)mgroup by catoutput-------------------------------------cat Val1 Val2-------------------------------------Empno 10 20Ename Raju Ramu
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/