Pivot query result (column name will change)

RJ 166

Hi there,

Working on a huge db task. A small part of it is pivoting a query result with dynamic column names.

Example Query:
Select top 1 * from information_schema.columns

Output should be

ColumnName | Value

Thanks

NIKHILA NETHIKUNTA 2,395 Reputation points Microsoft Vendor

2024-10-03T06:42:15.3333333+00:00

@RJ
Thank you for the question and for using Microsoft Q&A platform.
It seems like you want to pivot the result of a query with dynamic column names. Can you please provide more information on how you want to pivot the data? Which column do you want to use as the pivot key? And what aggregate function do you want to use for the pivoted columns?

Your answer