项目

一般

简介

下载 (1.69 KB)

3857.sql

匿名用户, 2019-09-12 14:28

 
1 
-- ????
2 
SELECT OrgID,BusinessManID,BusinessInternal,ChannelID,ChannelBrand,EntryTime from BOIPMain
3 
where OrgID = 'G5003006' AND SigningDate >= '2019-01-01' and SigningDate <= '2019-08-31'
4 

    		
  

  

    
      5
    
    
      
UPDATE BOIPMain SET BusinessManID = 'U5000525' , BusinessInternal = 'U5000525', OrgID = 'G5003004', ChannelID = 'N0000005', ChannelBrand = 'A1000002' WHERE OrgID = 'G5003006' AND SigningDate >= '2019-01-01' and SigningDate <= '2019-08-31'


    		
  

  

    
      6
    
    
      

    		
  

  

    
      7
    
    
      
-- ???㵥


    		
  

  

    
      8
    
    
      
SELECT OrgID,BusinessManID,BusinessInternal,ChannelBrand,ChannelID,* FROM BOExpenseSettlement 


    		
  

  

    
      9
    
    
      
where        OrgID = 'G5003006' AND EntryTime >= '2019-01-01' and EntryTime <= '2019-08-31'


    		
  

  

    
      10
    
    
      

    		
  

  

    
      11
    
    
      
UPDATE BOExpenseSettlement SET BusinessManID = 'U5000525' , BusinessInternal = 'U5000525', OrgID = 'G5003004', ChannelID = 'N0000005', ChannelBrand = 'A1000002' WHERE OrgID = 'G5003006' AND SigningDate >= '2019-01-01' and SigningDate <= '2019-08-31'


    		
  

  

    
      12
    
    
      
 


    		
  

  

    
      13
    
    
      
-- Ͷ????


    		
  

  

    
      14
    
    
      
SELECT OrgID,BusinessManID,BusinessInternal,ChannelBrand,ChannelID,* FROM BOIQApplication 


    		
  

  

    
      15
    
    
      
where OrgID = 'G5003006' AND EntryTime >= '2019-01-01' and EntryTime <= '2019-08-31'        


    		
  

  

    
      16
    
    
      

    		
  

  

    
      17
    
    
      
UPDATE BOIQApplication SET BusinessManID = 'U5000525' , BusinessInternal = 'U5000525', OrgID = 'G5003004', ChannelID = 'N0000005', ChannelBrand = 'A1000002' WHERE OrgID = 'G5003006' AND EntryTime >= '2019-01-01' and EntryTime <= '2019-08-31'


    		
  

  

    
      18
    
    
      

    		
  

  

    
      19
    
    
      
-- ???????ý???


    		
  

  

    
      20
    
    
      
SELECT OrgID,BusinessManID,ChannelBrand,ChannelID,* from BONewExpenseSettlement 


    		
  

  

    
      21
    
    
      
where OrgID = 'G5003006' AND EntryTime >= '2019-01-01' and EntryTime <= '2019-08-31'


    		
  

  

    
      22
    
    
      

    		
  

  

    
      23
    
    
      
UPDATE BONewExpenseSettlement SET BusinessManID = 'U5000525' , OrgID = 'G5003004', ChannelID = 'N0000005', ChannelBrand = 'A1000002' WHERE OrgID = 'G5003006' AND SigningDate >= '2019-01-01' and SigningDate <= '2019-08-31'


    		
  

  

    
      24