embed select statment within a insert statement?

• james powers

  SSC Journeyman

  Points: 93

  More actions

  April 11, 2007 at 5:56 pm

  #175850

  Does anyone know if sql server has the capacity to embed a select statement within a value in the insert statement?

  insert into table1

  (

  report_date,

  employee

  )

  values

  (

  select rpt_dt from reports where rpt_dt = somevalue,

  select emp from employees where emp = id

  )

  Thanks

• Koji Matsumura

  SSCrazy

  Points: 2241

  More actions

  April 11, 2007 at 6:42 pm

  #699944

  Try

  insert into table1

  (

  report_date,

  employee

  )

  select rpt_dt, (select emp from employees where emp = id)

  from reports where rpt_dt = somevalue