About former_member330120

former_member330120

Hi,anybody an idea why the following create table within an stored procedure is not working and throwing the error message:„Invalid Use of table variable"If i use the variable :RSLT within an insert table statement it works fine, but not for the cre...

former_member330120

Hi i would like to use a dynamic select statment within a hana procedure.the select statement should use value of the variable v_name as data field of the table DEBT.like this: (But this shows only the value GENDER in the resut)create type t_woe as t...

former_member330120

Thank you for this excellent article. Interesting and very informative.

former_member330120

Hi Florian,Thanks for your prompt answer, but :YEAR_SALES_RSLT is a table variable itselfregardsMike

former_member330120

Hi Krishna,Great ! Works fine !Thanks for you supportRegardsMike

former_member330120

Hi Adria,thanks for your quick response.Unfortunately it does not work.your proposed solution delivers for the column "I_GENDER' the values 'GENDER' which looks like this I_GENDER1 GENDER2 GENDER3 GENDER.... .....1...

User Statistics

User Activity

create table statement in procedure

dynamic sql for select statement in procedure

Re: Anomaly Forecast of Sensor Data in Energy Intensive Industries – Part I: The Machine Learning and Beer Production

Re: create table statement in procedure

Re: dynamic sql for select statement in procedure

Re: dynamic sql for select statement in procedure