BANK KALTENG

??USE [MinovaES_BankKalteng_Dev]

GO

/****** Object:  StoredProcedure [dbo].[PRPTCMMERITHEAD]    Script Date: 13/07/2022 10.17.33 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[PRPTCMMERITHEAD]

(

  @Version varchar(8),

  @CompanyID varchar(8),

  @Year varchar(8),

  @CostCenter varchar(8),

  @Organization varchar(8),

  @EmployeeIDFrom varchar(8),

  @EmployeeIDTo varchar(8)

)

AS

--DECLARE @CompanyID varchar(8)

--DECLARE @Version varchar(8)

--DECLARE @Year varchar(8)

--DECLARE @CostCenter varchar(8)

--DECLARE @Organization varchar(8)

--DECLARE @EmployeeIDFrom varchar(8)

--DECLARE @EmployeeIDTo varchar(8)

--SET @Version = '0011'

--SET @CompanyID = '1000'

--SET @Year = '2022'

--SET @CostCenter = ''

--SET @Organization = ''

--SET @EmployeeIDFrom = ''

--SET @EmployeeIDTo = ''

SELECT TOP(1) COM.* ,

        ISNULL(CAT.FileData, 0) AS Value

		,@year AS period

FROM    dbo.PCMEPCOMPID COM

LEFT JOIN dbo.SFILECATALOG CAT ON COM.Logo = CAT.FileName

WHERE (com.CompanyID = @CompanyID OR @CompanyID = '')