Team - I need your assistance for the SQL Pivot question.
I have Raw Data with many columns, however i am going to work only with 8 columns.
Question i have is, all gate dates above will have a date(MM/DD/YYYY) format. What i want to show is
Middle columns(FY13/14) will show current year and the previous column(FY12/13) is for previous year and like wise the last column is Next year.
Months will start from July to June
Every gate date has a color code attached.
Lets say - PEGatedate is 4th January 2014 and PCGatedate is 5th March2014,
in the output, For J (after OND) in FY13/14, it should say "DatePC" and for Feb also. And for M (after JF in FY13/14), it should say "DatePC"