Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Pivot and Unpivot

 
Guddu Ali
Ranch Hand
Posts: 40
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is use of pivot and unpivot where it is used?
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The first result I get when searching for "unpivot" is called "Using PIVOT and UNPIVOT" - that looks very promising :-). If you meant something else, please be more specific, as these words can have various meanings.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34410
346
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Also, what is the context? Excel? A database? Something else?
 
Guddu Ali
Ranch Hand
Posts: 40
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In context of SQL Data Base.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34410
346
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In that case, the Microsoft Tech Note Ulf mentioned is a good start. Take a look and that post back what questions you have. Also, I'll move this to our database forum.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic