Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 pivoting

Author  Topic 

kashyapsid
Yak Posting Veteran

78 Posts

Posted - 2010-04-24 : 03:36:07
What is the correct definition of pivoting in sqlserver-2005

KaShYaP

kashyapsid
Yak Posting Veteran

78 Posts

Posted - 2010-04-24 : 03:37:14
i read the article but i caun't understand the definition

KaShYaP
Go to Top of Page

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-04-24 : 03:45:22
I am not sure about definition but you can say that Pivot operator can be used for arranging the rows into columns (Like matrix) and again it depends on the requirement.

Regards,
Bohra



I am here to learn from Masters and help new bees in learning.
Go to Top of Page

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2010-04-24 : 05:07:34
describe what your problem is?
otherwise BOL servers good definition on pivoting: http://msdn.microsoft.com/en-us/library/ms177410.aspx
Go to Top of Page

kashyapsid
Yak Posting Veteran

78 Posts

Posted - 2010-04-24 : 06:59:49
actually i had read the definition but i am not able to catch it that's the reason i asked

KaShYaP
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-04-24 : 07:29:43
basically pivot on a column values and aggregate a quantity to get the accumulated figures as columns based on pivot field

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

kashyapsid
Yak Posting Veteran

78 Posts

Posted - 2010-04-24 : 07:53:01
ooh ok right now i got the concept

KaShYaP
Go to Top of Page
   

- Advertisement -