Convert Rows to Column --- Can any one help ?

Question

Convert Rows to Column --- Can any one help ?

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

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

Mark Marinovic SSCrazy Points: 2472 More actions · Answer 1

I would look at the PIVOT/UNPIVOT functions in BOL, also you can use CASE statements to return the data you're wanting in a specific column position.

MJM

Jack Corbett SSC Guru Points: 184395 More actions · Answer 2

You can also take a look at the Cross Tab and Pivot articles linked in my signature line. They give you options in addition to the PIVOT function provided.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

RV-813525 Default port Points: 1415 More actions · Answer 3

Thanks, But can you write a sample query lafter ooking at my query.

RV-813525 Default port Points: 1415 More actions · Answer 4

Thanks, But can you write a sample query lafter ooking at my query.