Results 1 to 13 of 13

Thread: [RESOLVED] sql server 2000 - help with insert from one table to another

Threaded View

  1. Sep 17th, 2009, 03:22 PM #12
    GaryMazzone
    GaryMazzone is offline
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: sql server 2000 - help with insert from one table to another

    I normally try this with inner joins

    sql Code:
    1. UPDATE ldc_zip SET

    2.      ldc_zip.ldc_ik = t2.ldc_ik 

    3. FROM ldc_zip t1 

    4. INNER JOIN ldc_zip t2  On t1.zip = t2.zip

    5. WHERE ldc_zip.ldc_ik is null
    Last edited by GaryMazzone; Sep 17th, 2009 at 03:23 PM. Reason: Formating
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width