DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Urgent help needed!!

  1. #11
    Join Date
    Aug 2003
    Posts
    100
    No luck. I just ran it again and zero rows were updated.

  2. #12
    Join Date
    Aug 2003
    Posts
    100
    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

  3. #13
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    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!
    Cheers!
    OraKid.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width