Skip to Content
0
Dec 05, 2019 at 01:19 PM

Passing Variable to Select statement in SAP HANA Stored procedure

1606 Views Last edit Dec 05, 2019 at 01:19 PM 2 rev

Dear Experts,

Im trying to Pass dynamic Variables to Select Statement in SAP HANA but i'm not finding a way out. Please suggest.

Ex:

select "Column A" into Table_Name from Table A where Country='XXX';

select count(*) from Table_Name;

Format looks similar to above query. The basic Idea is to Pass the value that I have stored in Table_Name Variable in to final select Statement.

Thanks