September 14, 2010 at 11:30 pm
Hi,
I have schedule one procedure to execute with in every 15 minute to update the data.
itakes the data from multiple table and then insert into single table as per requirement.
what is the best way to insert?
1. to delete the data of existing date and then insert
2. only insert the new updated record, check by time.
Please Help me.
September 15, 2010 at 1:28 am
It depends. You're not describing your problem with enough detail to get a sensible answer.
Can you give us a more detailed description of your requirement?
-- Gianluca Sartori
September 15, 2010 at 1:45 am
Cross post....
http://www.sqlservercentral.com/Forums/Topic986023-360-1.aspx
http://www.sqlservercentral.com/Forums/Topic986028-360-1.aspx
By posting multiple similar questions , you are helping no-one , least of all yourself.
Lets deal with you specific select issues first.
September 15, 2010 at 2:59 am
Gianluca Sartori (9/15/2010)
It depends. You're not describing your problem with enough detail to get a sensible answer.Can you give us a more detailed description of your requirement?
I have web service which update the data from remote location to local. and i have to read out these records and perform some operation on it and then store in to new tables. this process continue every 15 minutes. after 15 minute a procedure is executed .
currently i check the current date records if exists then i delete it and insert the new one.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply