USE [Emp1] GO CREATE FUNCTION [dbo].[Leave] ( @EmployeeID INT ) RETURNS INT AS BEGIN DECLARE @PayLeave INT, @NonPayLeave INT; SET @PayLeave = 0; SET @NonPayLeave = 0; RETURN ( SELECT IF((ImDescription == "Sick") AND (ImLeaveType == "Yearly")) { IF((ImMonthlyMaxLeave > 1) OR (ImYearlyMaxLeave > 10 )) { @NonPayLeave = @NonPayLeave + 1; PRINT @NonPayLeave; } ELSE { @PayLeave = @PayLeave + 1; PRINT @PayLeave; } } ) END --PRINT dbo.Leave('123')
NonPayLeave
PayLeave
EmployeeID
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)