October 22, 2009 at 11:19 am
Hi all!
Lets get right to it:
I have 2 tables 1 with a unique key and a note "A" column that has new notes in it. These notes are updated by one user on top of the "B" notes, which comes from table 2. Table 2 contains a unique that matches tables 1.
I want to only insert the new "A" notes into the "B" notes column in the same order they are in for the notes. Ok simple, Not....
The problem is, "B" notes can be updated after the "A" notes are being updated.
For example someone pulls data for "A" notes and updates it over 3 hours but does not change it directly in the database. While someone else is updating "B" notes during those 3 hours. So the problem is I want to insert "A" into "B" in the same order without removing the B notes that weren't there in that 3 hour gap.
Is this possible?
October 22, 2009 at 1:38 pm
I am going to say that it is not going to be possible - at least with the information you have posted so far. Please review the article I link to in my signature to find out how to post your question better.
My best guess is that you are going to want to restructure your tables to include identifying information for each note. But, that is just a guess at this point...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 22, 2009 at 4:29 pm
On top of that, I would consider storing notes in table C, and removing them from A and B. This would save a log of creepy logic and some space in database too.
Regards
Piotr
...and your only reply is slàinte mhath
October 22, 2009 at 8:54 pm
Lets get right to it:
Is this possible?
It is possible if you could help us understand it !!!
Be clear in your question post with some sample script and also not with the screenshots.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply