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 |
|
rikleo2001
Posting Yak Master
185 Posts |
 Posted - 2007-12-04 : 21:46:52
|
| Guys, I am bit stumped here. Shame on me.. But I am still a learner.Here is what I want to do..Two identical tables in two differant databases.Web interface attached to one Table and the other I want to add/Update and delete an entry into/From.Both table will be used parrelall from two differant systems, so data will have to be identical.Concerns.1. Can't implement replication, as Identity column concerns.2. Identity values will be differant in both tables.3. Insertion of records at both ends not a problemNow cocnerns are when an existing entry will be updated on first table how come we can do the same change in other table (Remember all fields are required to change and Identity is already differant)Here what I thought that whenever a change in record occur I will update whole records for that day in second table.I can't figure out how the query is going to workout..Any ideas Please?Many ThanksSKR |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2007-12-05 : 00:48:29
|
| what is the link between both the tables????Chiraghttp://www.chirikworld.com |
 |
|
|
|
|
|
Update Query