Urgent help needed!!

[ssmith001]

No luck. I just ran it again and zero rows were updated.

[ssmith001]

Oops...gave you the wrong query. Here's the correct one, which is still not updating any rows:

update temp_schedrcpts u
set manu_item = (
select imlitm from f4101 x
where x.imaitm = u.legacy_item)
where exists (
select 1 from f4101 x
where x.imaitm = u.legacy_item);


Steve

[balajiyes]

Hi I am not able to figure out the reason but if ur columns are VARCHAR type, sometime the value may not match. try using TRIM() option.

update temp_schedrcpts u
set manu_item = (
select imlitm from f4101 x
where TRIM(x.imaitm) = TRIM(u.legacy_item))
where exists (
select 1 from f4101 x
where TRIM(x.imaitm) = TRIM(u.legacy_item));

Cheers!