Project

General

Profile

Download (395 Bytes)

1.0 EXPORT PROCESS.txt

Luc Tran Van, 04/13/2021 01:09 PM

 
1 
EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_PROCESS_CHILD', -- varchar(776)
2 
@from = 'FROM PL_REQUEST_PROCESS_CHILD WHERE YEAR(TRANFER_DT) =2021' -- varchar(800)
3 

    		
  

  

    
      4
    
    
      
EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_PROCESS', -- varchar(776)


    		
  

  

    
      5
    
    
      
@from = 'FROM PL_REQUEST_PROCESS WHERE REQ_ID IN (SELECT REQ_ID FROM PL_REQUEST_DOC WHERE PROCESS_ID <> ''APPROVE'')' -- varchar(800)


    		
  

  

    
      6