Skip to Content
0
Nov 08, 2012 at 02:22 PM

Is this possible to do in calculation view?

41 Views

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.