In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.
I have 200 columns, and would like to avoid hard-typing , , , ...,  in my T-SQL.
SELECT row_id, , ,  FROM (SELECT row_id, column_id, value FROM my_table WHERE some_fk_id = 0 AND column_id IN (1, 2, 3)) AS src PIVOT ( MIN(value) FOR column_id IN (, , )) AS tgt
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.