root/trunk/SQL/Functions/getProcentProwizjiDyrektora.txt @ 747

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:              <Author,,Name>
-- Create date: <Create Date, ,>
-- Description: <Description, ,>
-- =============================================
ALTER FUNCTION [dbo].[getProcentProwizjiDyrektora] 
(
        -- Add the parameters for the function here
        @podstawa decimal(9,4),
        @planbiura decimal(9,4),
        @planOgolny decimal(9,4)
)
RETURNS decimal(9,4)
AS
BEGIN
DECLARE @prowizja DECIMAL(9,4)


IF @planbiura >= 1
SET @prowizja = @podstawa + 0.005
ELSE
SET @prowizja = @podstawa - 0.005

IF @planOgolny >=1
SET @prowizja = @prowizja + 0.005

RETURN @prowizja

END
GO

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO