Change rows into column without using pivot method.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » Change rows into column without using pivot...

Change rows into column without using pivot method.

Rate Topic

Display Mode

Topic Options

Change rows into column without using pivot method.

Poll Results

Votes

Change rows into column and vice versa without using pivot method.

100%

Member Votes: 7, Anonymous Votes: 0. You don't have permission to vote within this poll.

Author

Message

anandvish2006

Posted Friday, February 25, 2011 6:15 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, February 26, 2011 4:51 AM
Points: 2, Visits: 4

Change rows into column and vice versa without using pivot method.

Post #1069543

Paul White

Posted Sunday, February 27, 2011 12:53 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 7:53 AM
Points: 10,990, Visits: 10,577

I voted in favour Laugh

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #1070133

gparamasivamit

Posted Monday, February 11, 2013 9:21 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, February 11, 2013 9:20 AM
Points: 1, Visits: 0

i need answer

Post #1418512

Lynn Pettis

Posted Monday, February 11, 2013 9:27 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 8:42 AM
Points: 21,832, Visits: 27,857

Answer to what? You didn't give us anything to work with here.

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1418515

ChrisM@Work

Posted Monday, February 11, 2013 9:49 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 8:57 AM
Points: 5,705, Visits: 11,140

gparamasivamit (2/11/2013)

i need answer

42 of course. Doesn't everybody know this now?

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps

Post #1418530

« Prev Topic | Next Topic »

Permissions