cancel
Showing results for 
Search instead for 
Did you mean: 

Single row query returns multiple lines

former_member224444
Participant
0 Kudos

Hi ,

I am getting below error when calling a procedure in HANA Studio SQL editor

single-row query returns more than one row exception: single-row query returns more than one row: Please check lines: 250


Below is the query

SELECT

  ARTICLE,

  sum(stock_on_hand) as  stock_on_hand

  FROM :VAR_OUT1 

  group by ARTICLE;

What will be the reason?

Thanks,

Rithika

Accepted Solutions (1)

Accepted Solutions (1)

former_member224444
Participant
0 Kudos

Hi All,

Solved the issue myself.  I have used werks = (select .... from <table>) instead of

werks IN (select .... from <table>)


Thanks,

Rithika

Answers (0)