I have a view of a SQL table that performs a complicated calculation that is called [Overall Rating]. The view has: faciliy number, fiscal year, and the [overall rating].
Facility Number FY Overall Rating
1 2006 Poor
2 2006 Average
3 2007 Superior
1 2009 Adequate
2 2010 Average
I want to pivot the data to list the facility number for each row and then columns for 2006, 2007, 2008, 2009, 2010, etc, with the rating for that fiscal year appearing in that column
so that it looks like:
Facility Number 2006 2007 2008 2009 2010
1 Poor Adequate
2 Average Average
Can I do that or do I have to attack this from a different direction?
Thanks in advance for your help....