Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Change rows into column without using pivot method. Expand / Collapse
Change rows into column without using pivot method.
Poll ResultsVotes
Change rows into column and vice versa without using pivot method.
 
100%
7
Member Votes: 7, Anonymous Votes: 0. You don't have permission to vote within this poll.
Author
Message
Posted Friday, February 25, 2011 6:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Sunday, February 27, 2011 12:53 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:16 PM
Points: 11,194, Visits: 11,105
I voted in favour



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1070133
Posted Monday, February 11, 2013 9:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 11, 2013 9:20 AM
Points: 1, Visits: 0
i need answer
Post #1418512
Posted Monday, February 11, 2013 9:27 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 2:40 PM
Points: 23,081, Visits: 31,614
Answer to what? You didn't give us anything to work with here.



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
Posted Monday, February 11, 2013 9:49 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:21 AM
Points: 7,133, Visits: 13,520
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 »

Add to briefcase

Permissions Expand / Collapse