insert question

• julie123

  Newbie

  Points: 1

  More actions

  January 17, 2003 at 10:40 am

  #80615

  Hi all,

  I want to insert two fields into a table

  one field value is from table (multiple values)

  second field value is constant for all the values

  I tried this

  insert employee (empname,date) (select empname from department, '01/17/2003')

  it gives an error at the date.

  when I try only the empname it is inserting.

  thanks for your time

• Andy Warren

  SSC Guru

  Points: 119912

  More actions

  January 17, 2003 at 10:56 am

  #446668

  Try it like this:

  insert employee (empname,date) select empname, '01/17/2003' from department

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn