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/
AndyConnect with me on LinkedIn
Viewing post 1 (of 2 total)
You must be logged in to reply to this topic. Login to reply