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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-03 : 07:46:24
|
| shane writes "what i have is 2 applications talking via a sql . data is being transfered via a dts package.what i need to do is to update rows on a regular basis.what i am having problems with is how to perform the update.what i need to do is a test to see if the information exists and then if the information is up to date and if not update the information from a staging table that is rebuilt each night.i need to test on job number, percent complete and der date, If they exist test to see if they are at the same status as the staging table if not update.The table i want to update is called opact.the field names that i need to test are opname,orig_dur,act_desc and user_dte01,the opname will be there but i need to test if the act_desc has been change and if the orig_dur has been change and also user_dte01 has been changed from the table called mis_stg_opact.which is a staging table that holds this information and is rebuilt every night.I cannot truncate the opact table and rebuild it as it has a front end that inputs information to it also.this is stage 1 of updating i will have more fields that will need to follow this process. cheers shane" |
|
|
|
|
|
updating