BANK KALTENG » Bank Kalteng (Phase 2)

??--USE [MinovaES_Bank_Kalteng_Dev]

--GO

--/****** Object:  UserDefinedFunction [dbo].[Product_GetBudgetActual]    Script Date: 20/06/2022 16.58.15 ******/

--SET ANSI_NULLS ON

--GO

--SET QUOTED_IDENTIFIER ON

--GO

--ALTER FUNCTION [dbo].[Product_GetBudgetActual]  --SELECT * FROM dbo.GetBudgetActual('100','2010','scriberion','triadblank')

--(	

--	-- Add the parameters for the function here

--	@year VARCHAR(4),

--	@CostCenter VARCHAR(20),

--	@EmployeeID VARCHAR(20)

--)

--RETURNS TABLE 

--AS

--RETURN 

--(

	DECLARE @year VARCHAR(4) = '2022'

	DECLARE @CostCenter VARCHAR(20) = ''

	DECLARE @EmployeeID VARCHAR(20) = ''

	-- Add the SELECT statement with parameter references here

	SELECT *

	FROM dbo.Product_GetBudgetActualMonthly(@year, '01', '12', @CostCenter, @EmployeeID)

--)