Date: 11/25/08 (SQL Server)    Keywords: no keywords

I need to change rows into columns to wrap them into a header contract. This is how I need the data to show. If this is very involved I can see about paying for help.

Customer |Vendor |Service Type

McDonalds |MyCompany |Full Service



Oracle stores the data this way.

Role |Party Name

Customer |McDonalds

Vendor |MyCompany

Service Type |Full Service

Source: http://community.livejournal.com/sqlserver/68660.html