asif372
Posting Yak Master
100 Posts |
Posted - 2013-01-14 : 02:02:40
|
I am using Above Query but it donot meat to the requirement i want to Check all the Conditions i mean if Condition 1 is true then it should go above also neither than Coming out of itmy Query isAlter PROCEDURE InsManualData2(@EID int,@Date Datetime,@TimeIn Datetime,@TimeOut Datetime,@Remarks varchar(50),@Comments varchar(50))ASBEGINSET NOCOUNT ON;IF EXISTS(SELECT * FROM ShortLeave2WHERE EID = @EIDAND--CheckTime = DateAdd(d, DateDiff(d, 0, Cast(CONVERT(VARCHAR(30),@Date,110) As datetime)), Cast(CONVERT(VARCHAR(10),@TIMEIN,108) as datetime))CheckTime = DateAdd(d, DateDiff(d, 0, Cast(CONVERT(VARCHAR(30),@Date,110) As datetime)), Cast(CONVERT(VARCHAR(10),@TIMEIN,108) as datetime)))BEGINUPDATE ShortLeave2SET Remarks = @Remarks,Comments = @CommentsWHEREEID = @EIDANDCheckTime = DateAdd(d, DateDiff(d, 0, Cast(CONVERT(VARCHAR(30),@Date,110) As datetime)), Cast(CONVERT(VARCHAR(10),@TimeOut,108) as datetime))ENDELSE IF EXISTS(SELECT * FROM ShortLeave2WHERE EID = @EIDANDCheckTime = @TimeOut)BEGINUPDATE ShortLeave2SET Remarks = @Remarks,Comments = @CommentsWHEREEID = @EIDANDCheckTime = @TimeOutENDELSE IF NOT EXISTS(SELECT * FROM SHORTLEAVE2 WHERE EID = @EIDAND CheckTime = DateAdd(d, DateDiff(d, 0, Cast(CONVERT(VARCHAR(30),@Date,110) As datetime)), Cast(CONVERT(VARCHAR(10),@TIMEIN,108) as datetime)))BEGININSERT INTO SHORTLEAVE2SELECT @EID,DateAdd(d, DateDiff(d, 0, Cast(CONVERT(VARCHAR(30),@Date,110) As datetime)), Cast(CONVERT(VARCHAR(10),@TIMEIN,108) as datetime)) AS CheckTime,'I' AS CheckType,@Remarks,@Comments,1ENDELSE IF NOT EXISTS(SELECT * FROM SHORTLEAVE2 WHERE EID = @EIDAND CheckTime = DateAdd(d, DateDiff(d, 0, Cast(CONVERT(VARCHAR(30),@Date,110) As datetime)), Cast(CONVERT(VARCHAR(10),@TimeOut,108) as datetime)))BEGINSELECT @EID,DateAdd(d, DateDiff(d, 0, Cast(CONVERT(VARCHAR(30),@Date,110) As datetime)), Cast(CONVERT(VARCHAR(10),@TimeOut,108) as datetime)) AS CheckTime,'O' AS CheckType,@Remarks,@Comments,1ENDENDThanks in Advance.... |
|