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 |
jrogers
Starting Member
34 Posts |
Posted - 2008-03-19 : 10:10:46
|
Hi, I am migrating an applicatino from msAccess to SQL Server 2000. Now currently I download data from a SQL database into msAccess MAIN TABLE (to make querying much quicker and so I am dealing with a smaller dataset) after this downlaod I run a update query to insert certain values into a MAPPING TABLE if they are not already present.My question is what would be the most efficient way to do this.1) continue as I am by uploading data and then running a sp to update MAPPING TABLE2) create trigger on the MAIN TABLE to insert values into MAPPING TABLE if they don't exist. |
|
jrogers
Starting Member
34 Posts |
Posted - 2008-03-20 : 04:17:26
|
Sorry, brain fart.. option 1 is the way to go |
|
|
|
|
|