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 |
|
krushnapanda
Starting Member
18 Posts |
 Posted - 2007-12-07 : 00:14:40
|
| I have two table 1. tblCurr12. tblCurr2tblCurr1 Fields are Curr_Code,TT_Buy,Bill_Buy,TT_Sell,Bill_Sell,TC_Buy,CCY_Buy,TC_Sell,CCY_SelltblCurr2 Fields areCurr_Code,TT_Buy,TT_Sell,Update_Onthis is my SPCreate proc sp_notepadCurr as delete from tblCurr1 BULK INSERT tblCurr1 FROM 'D:\UpdateCurr_Server\Main.txt'-- what is the NEXTtblCurr1 Records are Update Through Notepad Daily using a SPI want insert Curr_Code,TT_Buy,TT_Sell,Update_On (Date&Time) into tblCurr2from tblCurr1 When tblCurr1 update through notepad file No update tblCurr2 , insert new every time as per DateTime when tblCurr1 isupdate through NotepadThanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-07 : 03:38:36
|
| Import to a temporary table and then update accordingly. |
 |
|
|
|
|
|
|
|
SQL Server 2005