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 |
|
tll414
Starting Member
4 Posts |
 Posted - 2008-03-11 : 15:59:44
|
I have a SQL2k5 table capturing transaction via an online vendor application. I need to join this data with cooresponding data that exist within a 2003 MS Access .MDB application. I've had recent training in SQL Serv 2005 T-SQL and programming. This is what I'm planning but not if this is the best/simple plan.- write After Insert trigger for SQL tbl to invoke a sp
- write After Insert trigger for SQL tbl to invoke a sp (OK with this)
- write a sp to select last inserted record from SQL tbl (OK with this)
- sp will use pk_col to pull data from linked MS Access 2003 using OPENQUERY or four part naming (is one way better than the other?)
- insert Parent record into MS Access parent tbl (after insert, how can i get Parent Key from this insert to use as Child FK col? will @@identity work?)
- insert Child record into MS Access child tbl (how can i get Child Key from this insert to use as GrandChild FK col? @@identity?)
- insert GrandChild record into MS Access GrandChild table
any help greatly appreciated!Thanks for being there.... Tom |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2008-03-12 : 01:21:37
|
| not sure on opequery part. but would also think on index fragmentation and alter index update |
 |
|
|
|
|
|
Multi insert into .MDB - need help