Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
eevans
Starting Member
48 Posts |
 Posted - 2009-02-27 : 13:28:35
|
| Hello,I have query that returns a list of about 3000 employee id#s. I need to insert these id#s into an existing table. What would be the easiest way to accomplish this? Thanks. |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-02-27 : 13:31:09
|
| INSERT INTO EXISTINGTABLE (EMPLOYEE_ID)SELECT yourquery to get the employeeids |
 |
|
|
eevans
Starting Member
48 Posts |
Posted - 2009-02-27 : 13:42:00
|
| That's easy enough. Thanks. |
|
|
|
|
|
|
mass insert