How to interchange rows and columns in SQL?

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Piotr.Rodak SSCrazy Eights Points: 9376 More actions · Answer 1

look at the PIVOT command in BOL

...and your only reply is slàinte mhath

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 2

Read up on the PIVOT keyword in BOL or search this site. There are plenty of examples around. 😉

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

TJDBA Default port Points: 1490 More actions · Answer 3

Sorry to say this..I am new to SQL...what is BOL? can anyone provide me with a query as a solution

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 4

"Books Online" It can be found

Start > Programs > Microsoft SQL Server 2005 > Documentation and Tutorials > SQL Server 2005 Books Online

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

TJDBA Default port Points: 1490 More actions · Answer 5

Thanks a lot..i will take it from here..thanks once again