Insert stored procedure output to a table and add datetimestamp

• RPSQL

  Hall of Fame

  Points: 3229

  More actions

  June 22, 2015 at 2:05 pm

  #318322

  Hi All,

  I have a need to insert stored procedure output a table and in addition to that add a datetimestamp column.. For example, Below is the process to get sp_who output into Table_Test table. But I want to add one additional column in Table_test table with datetimestamp when the procedure was executed.

  insert into Table_Test execute sp_who

  any help will be highly appreciated.

  Thanks.

• g.britton

  SSChampion

  Points: 13863

  More actions

  June 22, 2015 at 2:25 pm

  #1807198

  something like this:

  add a column "when datetime" to your table then:

  begin tran

  declare @when datetime = current_timestamp;

  insert into table

  exec sp_who2

  update table

  set when = @when

  where when is null

  commit

  Gerald Britton, Pluralsight courses

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  June 22, 2015 at 2:34 pm

  #1807199

  Or put a DEFAULT (GetDate() / GetUTCDate()) constraint on the new column.

  ---