Insert more than 1 records using stored procedure

• setlan1983

  SSCommitted

  Points: 1636

  More actions

  December 1, 2008 at 4:01 am

  #215900

  I wish to insert more than 1 records using stored procedure, may I know how to do that?

  Example:

  Table A:

  ID TransDT Actions

  -- ----------- ----------

  1 01-Dec-2008 02:00:00 Login

  2 01-Dec-2008 03:12:10 Logout

  3 01-Dec-2008 12:30:12 Login

  4 01-Dec-2008 14:12:56 Login

  I wish to select records where TransDT between 01-Dec-2008 07:00:00 and 01-Dec-2008 18:00:00 and insert into Table B.

  Thanks

• Madhivanan-208264

  SSCertifiable

  Points: 7516

  More actions

  December 1, 2008 at 4:23 am

  #905471

  Insert into TableB(columns)

  Select columns from TableA

  Where TransDT between '01-Dec-2008 07:00:00' and '01-Dec-2008 18:00:00'

  ---

  Madhivanan

  Failing to plan is Planning to fail

• brainy

  SSCrazy

  Points: 2445

  More actions

  December 1, 2008 at 5:21 am

  #905515

  Yes Madhivanan is correct .. it will work fine.