help with multi-update
Posted on
16th Feb 2014 07:03 pm by
admin
Now sure how to ask this really....
10g database if that matters.
I have a customer that accidently changed 742 records incorrectly. I'm being asked to fix it.
Did you know?Explore Trending and Topic pages for more stories like this.
Here is the sql that SHOWS me the relevant columns...
Select
p2.numberprgn,
a.agreement_id,
p2.ng_legacy_agreement_id
from
msp_sc.probsummarym1 p, msp_sc.probsummarym2 p2, msp_sc.ngslaassistm1 a
where
p.NUMBERPRGN = p2.NUMBERPRGN and
a.ORG_LEVEL1 = p.NG_SECTOR_NM and
a.CURRENT_ASSIGN_GROUP = p.ASSIGNMENT and
a.SEVERITY = p.SEVERITY_CODE and
p.OPEN_TIME >= '1-AUG-09' AND
p.OPEN_TIME <= '21-OCT-09' and
P.CATEGORY = 'USER-DESKTOP' and
p2.ng_legacy_agreement_id = '379' and
p2.ng_legacy_agreement_id <> a.agreement_id;
When I ran a distinct query against the agreement id, I get a total of 7 id's.
361
352
356
358
350
348
360
So I need to change the legacy ids to match the respective agreement id.
I know how to do it on a one by one basis...but there has to be a better way than doing that 742 times.
example:
NUMBERPRGN AGREEMENT_ID NG_LEGACY_AGREEMENT_ID
IM2108605 356 379
IM2113059 356 379
IM2116625 356 379
IM2117250 356 379
IM2119411 356 379
How do I go about this?
thx
No comments posted yet
Your Answer:
Login to answer
75 
30 
Other forums
Generate multilayered array from string.
ok so i have a string that looks like this:
Code: blog:edit_all,delete_all|users:edit_all,delete_
Code clarification
Hi
In the following code what could be the "search_print()" and where it could be
Creating web pages by php
Hello again,
I was just wondering us there a way to use a php script to create a new web page. I
cURL Upload Help
OK, I am creating a bridge from a local program to my website and I am trying to find the best way t
fwrite error
Hi All,
Does anyone know what is causing the error in this code?
Code: <?
$error
Update not working ... please help
Hi,
I am trying to update a row using an edit form by passing id of the row .. but it is not
Date Question
I'm using the TIMESTAMP() function within mysql to set the date/time for certain events. However, ho
mysq_num_rows
Hi,
I want to use:
Code: if(mysql_num_rows($ergebnis2)==2)
how can the value 2, be
Typedef struct vs just struct
Anyone know the rationale for using typedef for structs when a struct is itself a typedef? I have s
Inserting multiple records from single form
I've found a number of threads that deal with this issue, but I'm new to php and coding language so
