create Pivot Table

Question

Dear Friends , Any one can tell me how to create Pivot Table

Jignesh Trivedi · Answer

hi, Please refer, http://msdn.microsoft.com/en-us/library/ms177410%28v=sql.105%29.aspx http://www.simple-talk.com/sql/t-sql-programming/creating-cross-tab-queries-and-pivot-tables-in-sql/ good article on Pivot in SQL server.

Rahul Bhatt · Answer

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0cm 5.4pt 0cm 5.4pt;mso-para-margin-top:0cm;mso-para-margin-right:0cm;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0cm;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman";mso-bidi-theme-font:minor-bidi;mso-fareast-language:EN-US;} Your table has following field empid empname gender 1 mohan M 2 mohini F 3 suraj M 4 surya M 5 ragini F 6 rohini F 7 raju M Empid, empname, gender Now when you run simple query like select * from tblGenderEMP Now if you want to display row as coloum then you need to use PIVOT table Display Cout how may Male and How many Female M F 4 3 Your Quey become as SELECT [M] , [F] FROM ( SELECT sp . gender , sp . empid FROM tblGenderEMP as sp ) p PIVOT ( count ( empid ) FOR gender IN ( [M] , [F] ) ) AS pvt

Santhosh Kumar Jayaraman · Answer

Please check satyapriya nayak's post in the thread. http://www.c-sharpcorner.com/Forums/Thread/175401/__cs_myImageUpload.aspx

Vilas Gite · Answer

hi kunal refer good one example by pinal Dave http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/

George eric · Answer

Hi sir, I will direct you to several links: 1, an article on codeproject . 2, Create Piovt table with 3rd tool. A nd if you are an end-user, then please see http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/ . Hope my links can solve your question.

Satyapriya Nayak · Answer

Hi Kunal, Please refer the below links http://blog.sqlauthority.com/2008/05/22/sql-server-pivot-table-example/ http://www.sqlmag.com/article/tsql3/create-pivoted-tables-in-3-steps Thanks

create Pivot Table

Answers (6)