SQL Pivot Table Multiple Columns

Question

I have a table that looks like this:

Title01    Title02     Title03       Title04        Title05
Number     Title       Division      Department     IFC

And I am wanting to turn the columns into rows so it loos like this:

Field
Number
Title
Division
Department
IFC

Is it possible to do this using the PIVOT function in SQL?

There are countless examples of Pivot both dynamic and static. However, the inital concern is how to enforce the proper sequence. — John Cappelletti
– John Cappelletti, Commented Jan 24, 2018 at 0:00

Gordon Linoff · Accepted Answer · 2018-01-24 00:18:25Z

1

I like to use CROSS APPLY for this:

select v.field
from t cross apply
     (values (title01), (title02), (title03), (title04), (title05)
     ) v(field);

CROSS APPLY implements the lateral join. You can think of it as an extension of correlated subqueries -- but the subquery can return multiple columns and multiple rows. Unpivoting data happens to be a simple introduction to the concept.

answered Jan 24, 2018 at 0:18

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3277335 Over a year ago

Didn't even know about Cross Apply, this is much simpler than using Pivot, thank you!

Collectives™ on Stack Overflow

SQL Pivot Table Multiple Columns

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related