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 |
|
learntsql
524 Posts |
 Posted - 2009-10-20 : 02:59:24
|
| Hi,I have a staging table and i have to load the data from staging table to master table on everyday only few columns.I have to load only those rows which are either newly inserted,Deleted or Updated from last batch.Master table should contain unique records.Which transformation sholud i use.or any alternative. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-20 : 03:59:49
|
| As the data is already in a table, I'd suggest using a stored procedure to move the data to its destination table. |
 |
|
|
gaauspawcscwcj
Starting Member
29 Posts |
Posted - 2009-10-21 : 03:29:01
|
| use table source and table destination to transfer.gaauspawcscwcj |
|
|
|
|
|
|
Staging table to master table load