Project

General

Profile

Download (522 Bytes)

data hợp đồng.txt

Luc Tran Van, 03/09/2023 11:04 AM

 
1 
declare @REQ_DOC_ID VARCHAR(15)='', @PL_REQ_ID VARCHAR(15)=''
2 
SET @REQ_DOC_ID = (select top(1) REQ_DOC_ID from TR_CONTRACT where CONTRACT_ID = 'TRC000000000254')
3 

    		
  

  

    
      4
    
    
      

    		
  

  

    
      5
    
    
      
SET @PL_REQ_ID = (select TOP(1) PL_REQ_ID from TR_REQUEST_DOC WHERE REQ_ID = @REQ_DOC_ID)


    		
  

  

    
      6
    
    
      

    		
  

  

    
      7
    
    
      
select * from PL_REQUEST_DOC WHERE REQ_ID = @PL_REQ_ID


    		
  

  

    
      8
    
    
      

    		
  

  

    
      9
    
    
      
select * from PL_REQUEST_DOC_DT WHERE REQ_ID = @PL_REQ_ID


    		
  

  

    
      10
    
    
      

    		
  

  

    
      11
    
    
      
select * from PL_TRADEDETAIL TRADE WHERE EXISTS(Select * from PL_REQUEST_DOC_DT DT WHERE REQ_ID = @PL_REQ_ID AND DT.TRADE_ID = TRADE.TRADE_ID)