Using SELECT to INSERT records - SQL Server Information at SQLTeam.com
I'll use the SELECT statement in conjunction with the INSERT statement to make this as easy as possible. Normally, I would code an INSERT statement something like this (using the pubs database): INSERT authors (au_id, au_lname, au_fname, contract ......