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 |
|
mermaidhaven
Starting Member
9 Posts |
 Posted - 2001-11-01 : 15:12:33
|
| Hi,I have a problem with 2 databases being on 2 different servers. I have therefore created 2 connections, however I need this statemt to run at the same time:insert into SAT_info (population, avg_math, avg_verbal, admit_term,coll_code, major_code, ethnic_code) select count(*) as recordcount,avg(convert(int,best_sat_verbal)), avg(convert(int,best_sat_math)), admit_term_code,coll_code,major_code,ethnic_code from sisbapp group by admit_term_code,major_code,ethnic_code, coll_code I get an error basically stating that it cannot find one of the tables listed. Is there another way.I do NOT WANT to loop. A BCP would be ok if I could somehow throw the select stmt in it.HELP!Thankssam |
|
|
|
|
|
|
|
insert into select using multiple data sources