I am using Pivot in my query.My problem is that i want to add Average column of Pivoted columns.
Please give an idea how to do that?
eg. if my Pivoted columns are - ,,,, then i need to display one more column as sum of avg of all this 5 columns like below.
Select ,,,,,(AVG()+AVG()+AVG()+AVG()+AVG()) as Avg from #temp.