BANK WOORI SAUDARA » Phase 2

??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)

)