-- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= ALTER PROCEDURE Usp_GetSlabByMemberIDANDExpectedDate @MemberID BIGINT, @ExpectedDate DATETIME AS BEGIN DECLARE @cnt INT SET @cnt = (SELECT COUNT(*) FROM tbl_MemberPackage WHERE ExpectedDate <= GETDATE() AND MemberID = @MemberID AND IsWorkDone IS NULL ) IF @cnt = 0 BEGIN SELECT --top(1) t1.MemberFirstName + ' ' + t1.MemberLastName AS MemberName, t2.MemberID, t2.ExpectedDate, t3.WorkName FROM tbl_MemberPackage t2 INNER JOIN tbl_Membermaster t1 ON t1.MemberID = t2.MemberID INNER JOIN tbl_TypeOfWork t3 ON t3.WorkID = t2.WorkID WHERE t2.MemberID = @MemberID AND t2.IsWorkDone IS NULL AND t2.ExpectedDate = '@ExpectedDate' END ELSE SELECT t1.MemberFirstName + ' ' + t1.MemberLastName AS MemberName, t2.MemberID, t2.ExpectedDate, t3.WorkName FROM tbl_MemberPackage t2 INNER JOIN tbl_Membermaster t1 ON t1.MemberID = t2.MemberID INNER JOIN tbl_TypeOfWork t3 ON t3.WorkID = t2.WorkID WHERE t2.MemberID = @MemberID AND t2.IsWorkDone IS NULL AND t2.ExpectedDate = '@ExpectedDate' END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)