AnsweredAssumed Answered

Problem using Pivot in SQL statement

Question asked by user28311 on Jan 18, 2018
Latest reply on Jan 20, 2018 by beverly

I am testing the use of ExecuteSQL to produce a pivot table. So far I have not been successful.

Simple SQL statements have syntax errors when it includes the "pivot(.....)" function in the statement.

 

Same statement tested outside FM works.

 

Does FM 15 support Pivot function call in SQL statements ?

 

Thank you

Outcomes