I have a custom aggregation (UDA) and I want to pass an array of arguments like so:
select dbo.MyAggregation( t.type, N'My aggregation property', t.param1, t.param2, t.param3 ) from someTable t group by t.type
The above is just an example, and I want to pass arbitrary number of params (i.e 4-...).
I've tried to use
SqlString as an "array" with some delimiter, and then split the string by this delimiter, but this doesn't seem like a good solution.