Hi everyone,

I am having a bit of difficulty trying to figure out the best way to do this transformation.

I have a table e.g.

Column1 Column2 Column3
--------------------------------
Customer1 Type1 1
Customer1 Type2 2
Customer2 Type1 3
Customer2 Type2 4

But I want to create a pivot view something similar to

Type Customer1 Customer2
--------------------------------
Type1 1 3
Type2 2 4

Is this possiblein one query? I am able to do individual rows using pivot queries but I am trying to make this more efficient as my views seems to be getting a bit messy with multiple queries.

Any help would be much appreciated ^_^.

Thanks

MonkeyMan666

Yes... it's not only possible but it's easy to do, as well. I'm at work and don't have the time (right now) to write some code for your specific example, but here's a pretty good article on it.

http://www.sqlservercentral.com/articles/T-SQL/63681/

__________________
--Jeff Moden

Thanks Jeff, useful article :-)