Hi Friends,
Now facing problem on pivot concept. I explained below friends please share your knowledge to solve this.
IF OBJECT_ID('tempdb..#TempMaxOpp') IS NOT NULL DROP TABLE #TempMaxOpp
create table #TempMaxOpp(tuitionfees int,hostelmessfees int,bookfees int,messbillstudent int,busfees int,canteencollection int)
insert into #TempMaxOpp values(30000,15000,3200,1500,13000,1930)
select * from #TempMaxOpp
now I need output as below format
Account Name
Amount
tuitionfees
30000 Go to the complete details ...