IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id('$(@SPID)$') AND sysstat & 0xf = 4)
   DROP PROCEDURE dbo.$(@SPID)$
GO
/*********************************************************************************************************************
    설   명: [저장] 1마스터 2시트 화면의 두번째 시트 조회 SP입니다.   
    SP Name: $(@SPID)$
    작성일 : $(@CurrDate)$, $(@DevUserName)$
    수정일 : 
********************************************************************************************************************/
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 $(@DeclareData)$
    
	SELECT $(@GetData)$
   	  FROM #BIZ_IN_DataBlock1

	
	INSERT $(@OutTableName)$ ( $(@InsertTblData)$ )
	SELECT $(@SelectData)$
	  FROM $(@FromData)$ 
	 WHERE $(@WhereData)$

	
	
RETURN