[2:33:27 PM] Harsha Vardhana Reddy: Declare @Table6 table(PickedUp varchar(50),day1 Int,day2 Int,day3 Int,day4 Int,day5 Int,day6 Int,day7 Int,day8 Int,day9 Int,day10 Int,day11 Int,day12 Int,day13 Int,day14 Int,day15 Int,day16 Int,day17 Int,day18 Int,day19 Int,day20 Int,day21 Int,day22 Int,day23 Int,day24 Int,day25 Int,day26 Int,day27 Int,day28 Int,day29 Int,day0 Int, day31 Int)
Insert Into @Table6(PickedUp,day1 ,day2 ,day3 ,day4 ,day5 ,day6 ,day7 ,day8 ,day9 ,day10 ,day11 ,day12 ,day13 ,day14 ,day15 ,day16 ,day17 ,day18 ,day19 ,day20 ,day21 ,day22 ,day23 ,day24 ,day25 ,day26 ,day27 ,day28 ,day29 ,day0 , day31 )
SELECT 'PickedUp' AS PickedUp,[1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12],[13],[14],[15],[16],[17],[18],[19],[20],[21],[22],[23],[24],[25],[26],[27],[28],[29],[30],[31]
From
(Select days,PickedUp From @Table5) As SourceTable
PIVOT
(
SUM(PickedUp) For Days In([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12],[13],[14],[15],[16],[17],[18],[19],[20],[21],[22],[23],[24],[25],[26],[27],[28],[29],[30],[31] )
)AS pivotTable;
Insert Into @Final(Description ,Day1 ,Day2 ,Day3 ,Day4 ,Day5 ,Day6 ,Day7 ,Day8 ,Day9 ,Day10 ,Day11 ,Day12 ,Day13 ,Day14 ,Day15 ,Day16 ,Day17 ,Day18 ,Day19 ,Day20,Day21 ,Day22 ,Day23 ,Day24 ,Day25 ,Day26 ,Day27 ,Day28 ,Day29 ,Day30,Day31)
Select PickedUp,day1 ,day2 ,day3 ,day4 ,day5 ,day6 ,day7 ,day8 ,day9 ,day10 ,day11 ,day12 ,day13 ,day14 ,day15 ,day16 ,day17 ,day18 ,day19 ,day20 ,day21 ,day22 ,day23 ,day24 ,day25 ,day26 ,day27 ,day28 ,day29 ,day0 , day31 from @Table6