Skip to Content
0
Former Member
Jul 15, 2008 at 03:17 PM

Getting a single value with a FOR ALL ENTRIES

2554 Views

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