Results 1 to 5 of 5

Thread: Remove duplicates from Temp Table

Threaded View

  1. #1
    Join Date
    Mar 2009
    Posts
    32

    Question [Resolved] Remove duplicates from Temp Table

    Have following temp table populated with data:


    PHP Code:
     #TempTable
            
                
    petroex_ind char(1)
                
    petroex_ver char(2)
                
    record_id char(1)
                
    supplier_code char(3)     
                
    division char(3)
                
    site_id char(1)
                
    splc_code char(9
                
    terminal_no char(9)
                
    period char(5)
                
    movement_month char(2)
                
    movement_year char(4)
                
    movement_date char(8)
                
    trans_descr char(40)
                
    ticket_no char(16)
                
    petroex_code char(3)
                
    product_code char(8),
                
    tank_code char(15
                
    qty_gross char(11)     
                
    qty_net char(11
                
    cred_flag char(1
                
    uom char(1)
                
    mode_transp char(2)                           
                
    mode_transp_descr char(15)
                
    scac char(5
                
    fein char(9)
                
    suffix char(1
    I need to loop through the table a remove duplicate records where

    ticket_no, petroex_code, tank_code, qty_gross and qty_net are the same.

    Is that possible?
    Last edited by snufse; 04-20-2011 at 11:46 AM.

Posting Permissions

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