quote:

---

Originally posted by visakh16

you will need to use unpivot first and get them into rows. then apply pivot over them based on value of Month column

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

quote:

---

Originally posted by anujpratap84

Thanks for reply..
Can you please write a sample example query...

Thanks in advance.

quote:

---

Originally posted by visakh16

you will need to use unpivot first and get them into rows. then apply pivot over them based on value of Month column

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

Anuj Pratap Singh

---

CREATE TABLE #pivunpiv
(
[Month] varchar(100),
 ALLTotal int,
DEF int,
TEN int,
[ALL] int
)
insert #pivunpiv
SELECT '1', 45, 10, 15, 20 union all
SELECT '2', 40, 5, 10, 25 union all
SELECT 'Total', 85, 15, 35, 45

select * from #pivunpiv

select [cat] AS [Month],[1],[2],[Total] into #result 
from
(
select * from #pivunpiv p
unpivot ( Val FOR Cat IN (ALLTotal,DEF,TEN,[ALL]))u

)t
pivot (sum(Val) for [Month] IN ([1],[2],[Total]))p

select * from #result
drop table #pivunpiv
drop table #result


output
-----------------------------------
after unpivot
-----------------------------------
Month	ALLTotal	DEF	TEN	ALL
1	45	10	15	20
2	40	5	10	25
Total	85	15	35	45

-----------------------------------
after final pivot
-----------------------------------
Month	1	2	Total
ALL	20	25	45
ALLTotal	45	40	85
DEF	10	5	15
TEN	15	10	35