IF EXISTS (SELECT * From sysobjects Where id = object_id('$(@SPID)$') AND sysstat & 0xf = 4)
 DROP PROCEDURE $(@SPID)$
GO
/*********************************************************************************************************************    
    설   명: [저장] 1마스터 2시트 화면의 두번째 시트 저장 SP입니다.   
    SP Name: $(@SPID)$
    작성일 : $(@CurrDate)$, $(@DevUserID)$
    수정일 : 
********************************************************************************************************************/     
CREATE PROCEDURE $(@SPID)$      
    @ServiceSeq     INT     = 0,  
    @WorkingTag     NVARCHAR(10)= '',  
    @CompanySeq     INT     = 1,  
    @LanguageSeq    INT     = 1,  
    @UserSeq        INT     = 0,  
    @PgmSeq         INT     = 0,  
    @IsTransaction  BIT     = 0    
AS        
    DECLARE @docHandle  INT   
      
      
    -- DELETE          
    IF EXISTS (SELECT 1 FROM $(@OutTableName)$ WHERE WorkingTag = 'D' AND Status = 0  )        
    BEGIN        
        DELETE $(@G_SS2)$
          FROM $(@OutTableName)$ AS A        
          JOIN $(@G_SS2)$ AS B WITH (NOLOCK) ON $(#JKCC_columns)$
         WHERE A.WorkingTag = 'D'     
           AND Status = 0      
          
        IF @@ERROR <> 0 RETURN          
    END      
        
    -- Update          
    IF EXISTS (SELECT 1 FROM $(@OutTableName)$ WHERE WorkingTag = 'U' AND Status = 0  )        
    BEGIN         
        UPDATE $(@G_SS2)$      
           SET $(#UN_columns)$      
          FROM $(@OutTableName)$ AS A      
          JOIN $(@G_SS2)$ AS B WITH (NOLOCK) ON $(#JKCC_columns)$
         WHERE A.WorkingTag = 'U'     
           AND A.Status = 0       
      
        IF @@ERROR <> 0 RETURN         
    END       
           
    -- INSERT          
    IF EXISTS (SELECT 1 FROM $(@OutTableName)$ WHERE WorkingTag = 'A' AND Status = 0  )        
    BEGIN    
        INSERT INTO $(@G_SS2)$ ($($IA_Columns)$)
            SELECT $(#SACC_columns))$  
              FROM $(@OutTableName)$  
             WHERE WorkingTag = 'A' 
               AND Status = 0   
        
        IF @@ERROR <> 0 RETURN          
    END            
          
    RETURN