Re: selecting into a temp table

[Stephen Keen <Stephen_Keen@SQR-SERVICES.COM>]

Thanks  Thomas!!

Stephen B. Keen

 -----Original Message-----
From:   Discussion of SQR,             Brio Technology's database reporting
language [mailto:SQR-USERS@list.iex.net]  On Behalf Of Thomas, Lyla
Sent:   Wednesday, July 12, 2000 10:09 AM
To:     SQR-USERS@list.iex.net
Subject:        Re: selecting into a temp table

Hi Steve,
    you could do this way
    Begin-Procedure Populate_Temp_Tbl
     begin-sql
      INSERT INTO PS_ZZ_Temp_Table (EMPLID,ACTION,ACTION_REASON)
      SELECT A.EMPLID, C.ACTION, C.ACTION_REASON
      FROM PS_PERS_DATA_EFFDT A, PS_JOB C
      WHERE A.EMPLID = C.EMPLID
     End-SQL
   End-Procedure

   Or you could do this way
      SELECT A.EMPLID, C.ACTION, C.ACTION_REASON
          Do Insert_Into_Temp_Tbl
      FROM PS_PERS_DATA_EFFDT A, PS_JOB C
      WHERE A.EMPLID = C.EMPLID

     Begin-Procedure Insert_Into_Temp_Tbl
      Begin-sql
        INSERT INTO PS_ZZ_Temp_Table
           (EMPLID,ACTION,ACTION_REASON)
          Values
           ($o_EMPLID,
            $o_Action,
          $o_Action_Reason)
      End-SQL
    End-Procedure

  Hope this helps
Lyla

-----Original Message-----
From: Stephen Keen [mailto:Stephen_Keen@SQR-SERVICES.COM]
Sent: Wednesday, July 12, 2000 9:54 AM
To: SQR-USERS@LIST.IEX.NET
Subject: selecting into a temp table


Can someone give me the syntax for selecting data from a table into a
temporary table?

Thanks


Steve