I have a view in MSSQL 2005 that contains up to 6 rows of information per order (shown below). Up to 3 sales persons, and up to 3 external sales persons (max) can be found in the view.
I need to collapse all of that down to a view that only shows 1 row per order, and spreads the sales people information out across multiple, pre-defined, columns.
I have been playing around with variations on unions, stuffs, selects etc. from previous posts here, but with no luck. Any help would be very appreciated.