EXEC_SP Action and SQL Pivot

[Aware2014]

I had the need to build a SQL stored procedure and thus calling it using the EXEC_SP action. The stored procedure utilized the PIVOT operator.

Using PIVOT involves temporary run-time created columns (i.e. columns that are not defined in the database). These are called Pivoted Columns.

To handle this in AwareIM, in the BO which you will return the results of the query against, simply create an attribute for each Pivoted Column. From there you will be able to perform all other AwareIM functions no different than other attributes.