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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-07 : 09:02:43
|
| Samantha writes "Can I do that? If so how?I have this stmt: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 with connections created:Conn.Open "DSN=sisinfo;UID=monroet;PWD=PgKfOT;APP=SISINFO;DATABASE=" & incDSNthat is for table sisbappI then have another one for SAT_infowhen running the above query I get this:sisbapp table basically not found.All help appreciated.thankssamantha" |
|
|
|
|
|
|
|
insert into select using mulitiple data sources on different servers