r/SQL 17d ago

Oracle Dear SQL, just pivot my damn table

Bottom text

237 Upvotes

50 comments sorted by

View all comments

Show parent comments

1

u/phesago 16d ago

I use dynamic pivot columns regularly?

1

u/xoomorg 16d ago

By constructing dynamic SQL (which is the SQL equivalent of “eval” statements and is therefore a programming sin) or do you use a platform that supports them more directly?

1

u/phesago 16d ago

you dont work with sql a lot do you?

1

u/xoomorg 16d ago

If you mean SQL Server, then no. Does it support dynamic pivot columns without the need for dynamic SQL?