Project

General

Profile

Download (1.92 KB)

1.0 MAPPING LAI 26 HANG HOA CO NHIEU DON VI CHUYÊN MON (MAPPING DUNG MOI HANG HOA CHI THUOC 1 DVCM).txt

Luc Tran Van, 05/04/2021 09:50 AM

 
1 
DELETE FROM CM_HANGHOA_DVCM WHERE HH_ID IN
2 
(SELECT HH_ID FROM CM_HANGHOA_DVCM
3 
GROUP BY HH_ID
4 
HAVING COUNT(*) >1)
5 

    		
  

  

    
      6
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000000014','DM0000000000015')


    		
  

  

    
      7
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000003507','DM0000000000015')


    		
  

  

    
      8
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112038','DM0000000000049')


    		
  

  

    
      9
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112039','DM0000000000049')


    		
  

  

    
      10
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112060','DM0000000000015')


    		
  

  

    
      11
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112068','DM0000000000050')


    		
  

  

    
      12
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112072','DM0000000000049')


    		
  

  

    
      13
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112088','DM0000000000003')


    		
  

  

    
      14
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112195','DM0000000000003')


    		
  

  

    
      15
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112202','DM0000000000003')


    		
  

  

    
      16
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112253','DM0000000000006')


    		
  

  

    
      17
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112263','DM0000000000005')


    		
  

  

    
      18
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112267','DM0000000000004')


    		
  

  

    
      19
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112275','DM0000000000004')


    		
  

  

    
      20
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112277','DM0000000000004')


    		
  

  

    
      21
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112280','DM0000000000004')


    		
  

  

    
      22
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112282','DM0000000000004')


    		
  

  

    
      23
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112283','DM0000000000004')


    		
  

  

    
      24
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112289','DM0000000000004')


    		
  

  

    
      25
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112295','DM0000000000008')


    		
  

  

    
      26
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112296','DM0000000000008')


    		
  

  

    
      27
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112297','DM0000000000008')


    		
  

  

    
      28
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112299','DM0000000000008')


    		
  

  

    
      29
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112302','DM0000000000008')


    		
  

  

    
      30
    
    
      
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000001058474','DM0000000000049')