Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,675 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
After running a pivot function, I am unable to select the column by names because I don't know them.
Can I, in a select on the pivot function, select the columns with the position and not with the name of a column?
for example:
select fourth column, fifth column, sixth column from pivotfunction where ...
Is there any way to do this?
Thanks for any help
Marco Dell'Oca
Not in T-SQL. Unfortunately, there is no way.
thank you very much
Marco Dell'Oca