• Try a 'manual pivot' like i show in this article http://www.sqlservercentral.com/articles/T-SQL/73887/[/url]



    Clear Sky SQL
    My Blog[/url]