That's not currently possible with custom metrics. The T-SQL on which the custom metric is based must return a single, numeric scalar or NULL value. It can call a stored procedure, as long as the returned value meets the same criteria. It cannot collect multiple values, results containing alphabetic or special characters, or recordsets.
crimdon
Posts: 54 Bronze 3
Comments
That's not currently possible with custom metrics. The T-SQL on which the custom metric is based must return a single, numeric scalar or NULL value. It can call a stored procedure, as long as the returned value meets the same criteria. It cannot collect multiple values, results containing alphabetic or special characters, or recordsets.
https://documentation.red-gate.com/disp ... ine+metric
Hope that helps.
Thanks
Adam