Skip to Content
0
Former Member
Mar 16, 2016 at 10:34 AM

How to pass a procedure (scalar procedure - returning a single value) to input parameter

184 Views

Hi,

I have a simple procedure calculating Last Year Current Month(LYCM) - NVARCHAR(6) based on an input parameter(having Current Month This Year- an user selection).

How can I bind the value returned by this procedure to a second input parameter of NVARCHAR(6) derived from this procedure?

I am on HANA SP10

Thanks in Advance,

Prasad