Skip to Content
0
Former Member
Aug 31, 2012 at 06:16 AM

How to Bind Input Parameter to a Variable in SQLScript

1122 Views

Dear Experts,

I want to query a view which has an Input parameter in an SQLScript code. Question is how to bind a variable to input parameter in PLACEHOLDER keyword. Ex-

var_filter NVARCHAR(4);

BEGIN

var_filter = SELECT max(FiscalYear) FROM XYZ WHERE Amount_Due > 10000;

var_out = SELECT column1, column2....column10 FROM "_sys_BIC"."test/TEST" ('PLACEHOLDER' = ('$$YEAR$$', var_filter));

The above statement does not work, as it expects me to enter parameter value as hardcoded value in quotes - ('$$YEAR$$', '2012')

Any way to bind the variable here?

Best Regards,

Vikas Bittera