In Sql Server you can link to an external odbc datasource. You could then do a the following
Insert Into si_acl_groups ("group_id", "forum_id", "auth_option_id", "auth_role_id", "auth_setting")
select "group_id", "forum_id", "auth_option_id", "auth_role_id", "auth_setting"
from [linkeddb].database.tablename
This will allow your entire table to be inserted without using unions.
Another way is to use the bulk copy program (BCP) or DTS for imports, both of which use flat files to pull information into tables. (note: the aformentioned methods also do extracts.)
Enjoy
-----------------------------------------
Marco Island Florida waterfront vacation rental house
steroid
Edited 2 time(s). Last edit at 09/25/2009 09:40AM by banglore agent1.