Hi everyone,
I have to get a single value from a for all entries query. What would be more performant?
1)
SELECT mdocm FROM imrg
INTO l_mdocm
UP TO 1 ROWS
FOR ALL ENTRIES IN t_impt_tab
WHERE point EQ t_impt_tab-point
AND mdtxt EQ gv_clmno.
ENDSELECT.
2)
DATA: t_mdocm TYPE STANDARD TABLE OF imrg-mdocm.
SELECT mdocm FROM imrg
INTO TABLE t_mdocm
UP TO 1 ROWS
FOR ALL ENTRIES IN t_impt_tab
WHERE point EQ t_impt_tab-point
AND mdtxt EQ gv_clmno.
READ TABLE t_mdocm INDEX 1 INTO l_mdocm.
Please tell me which one and why. Database is MSSQL release 9.00.3042.
Thanks!
Pablo