在SQL中对PIVOT表进行排序

I have a procedure that returns data from a PIVOT table. I just need to sort this data so that the PIVOT displays the columns in a particular order. I need them sorted by the "SortOrder" field in the Regions table. Here's my script. I don't actually need the sortorder field returned, I just need the columns sorted by sortorder. Any help is appreciatedI have a procedure that returns data from a PIV