I know how we can define a basic expression into a calculated field. I was wondering if we can attached a field either calculated field or in SQL Script based Calculation View where we can pass input parameters based on the selected fieds and defined a new field based on the returned value.
Let say a stored procedure ABC has 2 input parameters (both scalar parameter) and 1 output scalar parameter. I was wondering if we can call the procedure from select statement so that we can defined a new field based on this procedure.
SELECT field1, field2, Call ABC(field1, field2, result) as field3 from....
I could not find any such documentation and hoping someone experience this before and able to make this work.