Click here to Skip to main content
16,010,022 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SQL
[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
Posted
Comments
ZurdoDev 26-Apr-13 7:40am    
What?
Rohit Janapally 26-Apr-13 8:12am    
this code is in SQL i need to change it to MYSQl..i want to know is "WHat to write in place id PIVOT?"

1 solution

See my past answer: customize query result[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900