IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id('$(@SPID)$') AND sysstat & 0xf = 4)
   DROP PROCEDURE dbo.$(@SPID)$
GO
/*********************************************************************************************************************
    설  명 : [조회] 1C1S_Ds1 의 조회 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