On Wednesday, March 8, 2023, Rosebrock, Uwe (Environment, Hobart) < uwe.rosebr...@csiro.au> 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.