On Dec 7, 12:04 pm, Captain Paralytic <paul_laut...@yahoo.com> wrote:
> Can you post what the output data you would wish to see is?- Hide quoted text -

something like this:
(im assuming that the patchid column can store the unique integer that
is the primary key of the row that should be replaced, so for the
example data:

scanario 1 (baseline)
id scenario data patchid
1 1 100 0
2 1 100 0
3 1 100 0
4 1 100 0
5 1 100 0
6 1 100 0
7 1 100 0
8 1 100 0
9 1 100 0
10 1 100 0

scenario 2
id scenario data patchid
1 1 100 0
2 1 100 0
11 2 110 3
12 2 130 4
4 1 100 0
5 1 100 0
6 1 100 0
7 1 100 0
8 1 100 0
9 1 100 0
10 1 100 0

scenario 3
id scenario data patchid
1 1 100 0
2 1 100 0
3 1 100 0
4 1 100 0
5 1 100 0
6 1 100 0
13 3 200 7
8 1 100 0
9 1 100 0
10 1 100 0


cheers

Dan