Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
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
Join the community of 500,000 technology professionals and ask your questions.