| Since the SetToArray returns a variant, we do not have a working query example for SQL Server Management Studio. However, the simulated query below would pass an array to a UDF.
|
| |
SELECT
MY_UDF(SETTOARRAY({[Sales Reason].[Sales Reasons].[Sales Reason].Members}, [Measures].[Sales Amount])) ON COLUMNS
FROM
[Adventure Works] |
| |
| If you run the above query in SQL Server Management Studio, you will receive the following error:
Executing the query ...
Query (1, 8) The '[MY_UDF]' function does not exist.
Execution complete
|
| |
|
| |
|