Project

General

Profile

Download (546 Bytes)

routeplan patch.sql

Muhammed Azhar Mohamed Maideen, 01/03/2024 04:25 PM

 
1 

    		
  

  

    
      2
    
    
      
select top 1 * from di_RoutePlan_import (NOLOCK) where org_id='snekku' order by di_import_id desc


    		
  

  

    
      3
    
    
      

    		
  

  

    
      4
    
    
      
update  di_RoutePlan_import set customer_code = replace(customer_code,'$$$','') , error_message ='' where process_id='4792dd59-2bbf-4c42-82e5-90c906301dfb' 


    		
  

  

    
      5
    
    
      

    		
  

  

    
      6
    
    
      
exec [dbo].[sp_DataCheck_di_RoutePlan_import] 


    		
  

  

    
      7
    
    
      
@ProcessId ='4792dd59-2bbf-4c42-82e5-90c906301dfb',


    		
  

  

    
      8
    
    
      
@OrgId ='snekku'


    		
  

  

    
      9
    
    
      

    		
  

  

    
      10
    
    
      
--exec [dbo].[sp_DataLoad_di_RoutePlan_import] 


    		
  

  

    
      11
    
    
      
--@ProcessId ='10a1e38c-8d74-4374-960f-d4b5920d798a',


    		
  

  

    
      12
    
    
      
--@OrganizationID ='snekku'


    		
  

  

    
      13
    
    
      

    		
  

  

    
      14
    
    
      
exec sp_WhoIsActive


    		
  

  

    
      15
    
    
      

    		
  

  

    
      16
    
    
      

    		
  

  

    
      17