On Wednesday, March 8, 2023, Rosebrock, Uwe (Environment, Hobart) <Uwe.Rosebrock@xxxxxxxx> wrote:
Hi List
I like to use crosstab to pivot a long list of rows into columns, however the column labels are created dynamically with the resulting column type known.
Is there a way pass a list of names and types to crosstab (‘query’) as (<‘type list as strings in array’> ) ?
In other words,
Can I pass an array to crosstab row labels
No, you cannot change query structure at execution time in SQL.
David J.
