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 |
|
lamujerdetuhermano10
Yak Posting Veteran
75 Posts |
 Posted - 2008-10-02 : 19:40:29
|
| i wanna write sp for incremental extract. We have a sp for every table. what is the best way to do it in one sp? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-03 : 00:02:29
|
| you need a single sp for all tables? that will need to use dynamic sql. i think its better to keep one sp seperate for each table. |
 |
|
|
lamujerdetuhermano10
Yak Posting Veteran
75 Posts |
Posted - 2008-10-03 : 01:58:16
|
| i have that but how can i improve it? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-03 : 02:16:23
|
quote:
Originally posted by lamujerdetuhermano10
i have that but how can i improve it?
improve its performance you mean? for that we need some idea abut current code. can you post the current code? |
|
|
|
|
|
|
incremental extract best way?