Sudipta Bandyopadhyay

This code will help to convert data organized as rows to be organized as columns. Problem statement: Say I have a table (MyTable): Year Month Count 2009 12 22 2010 5 19 2010 2 1914 2010 3 51 2010 11 40 2010 12 3 2010 9 28 2010 1 138 2010 10 103 I need the output like this: Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2009 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 22 2010 138 1914 51 NULL 19 NULL NULL NULL 28 103 40 3 SQL way to achieve the goal:   1: SELECT Year , 2: SUM (Jan) AS Jan, 3: SUM (Feb) AS Feb, 4: SUM (Mar) AS Mar, 5: SUM (Apr) AS Apr, 6: SUM (May) AS May, 7: SUM (Jun) AS Jun, 8: SUM (Jul) AS Jul, 9: SUM (Aug) AS Aug, 10: SUM (Sep) AS Sep, 11: SUM (Oct) AS Oct, 12: SUM (Nov) AS Nov, 13: SUM ( Dec ) AS Dec 14: FROM ( 15: SELECT Year , 16:...