Single row query returns multiple lines

This question is answered

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

Correct Answer

July 15, 2015 at 13:09 PM

Hi All,

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

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

Thanks,

Rithika

0 Likes 0 View this answer in context