BATCH UPDATES ON CLIENT SERVER

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

BATCH UPDATES ON CLIENT SERVER

Author

Topic

rborda
Starting Member

2 Posts

Posted - 2004-08-27 : 13:45:31

Having a front end user & the data residing on SQL Server.
Users need to process online transactions. I am familiar with the
SQL staments to delete and insert, but I can not understand
how to do the following before I started placing my tables on SQL:
On the front end when several users selected loans for their pools,
they were stored temporarily in a table, then all I had to do was
INSERT INTO Master(Loan) SELECT Loan FROM TempLoans;
Since I moved my Master tables to SQL, and my TempLoans table
still resides on the front end user. If I use a pass-through query
with the following statement:

INSERT INTO Master SELECT Loan FROM TempLoans;
Fails because it can't recognize TempLoans within SQL Server.
Thus, how is batch update handled by SQL Server for this particular
scenario?

Thanks in advance for the feedback

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2004-08-27 : 13:49:09

so you have tabels on different servers?
use 4 name naming convention (i now it has a proper name):
select * from server.database.user.table

Go with the flow & have fun! Else fight the flow :)

rborda
Starting Member

2 Posts

Posted - 2004-08-27 : 16:24:37

Front End is Access and back end is SQL Server

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources