Click here to Skip to main content
13,398,199 members (33,072 online)
Rate this:
Please Sign up or sign in to vote.
How to convert the following SQL-C# logic to syntactically-correct SQL code (SQL Server 2005)?

"Description", "LeaveType", "MonthlyMaxLeave", "YearlyMaxLeave" are the column names in the table EmpTab.

I have written a basic logic to calculate the PayLeave and NonPayLeave, and to display its final values. Assume that the fields "Description" and "LeaveType" always contains the values "Sick" and "Yearly" respectively. Please do not worry about the data in the table. The field values in the table may be customized as per the requirements.

Just correct the syntax in the code so as to meet the SQL standards, as well as to display the PayLeave and NonPayLeave values based on the calculation logic shown below.
USE [Emp1]
CREATE FUNCTION [dbo].[Leave] 
   @EmployeeID INT    

    DECLARE	@PayLeave INT,
    	@NonPayLeave INT;
    SET @PayLeave = 0;
    SET @NonPayLeave = 0;
        IF((ImDescription == "Sick") AND (ImLeaveType == "Yearly"))
            IF((ImMonthlyMaxLeave > 1) OR (ImYearlyMaxLeave > 10 ))
            	@NonPayLeave = @NonPayLeave + 1;
            	PRINT @NonPayLeave;
            	@PayLeave = @PayLeave + 1;
                PRINT @PayLeave;

--PRINT dbo.Leave('123')
Posted 14-Mar-13 21:46pm
Updated 14-Mar-13 22:09pm
Karthik Harve 15-Mar-13 3:10am
[Edit] pre tags added.
Maciej Los 6-Apr-13 16:55pm
Please, be more specific and provide more details.
Are you trying to count NonPayLeave and PayLeave for employee with EmployeeID?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.180216.1 | Last Updated 15 Mar 2013
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100