|
asif372
Yak Posting Veteran
Pakistan
94 Posts |
 Posted - 01/14/2013 : 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 it
my Query is
Alter PROCEDURE InsManualData2
(
@EID int,
@Date Datetime,
@TimeIn Datetime,
@TimeOut Datetime,
@Remarks varchar(50),
@Comments varchar(50)
)
AS
BEGIN
SET NOCOUNT ON;
IF EXISTS
(
SELECT * FROM ShortLeave2
WHERE EID = @EID
AND
--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))
)
BEGIN
UPDATE ShortLeave2
SET Remarks = @Remarks,
Comments = @Comments
WHERE
EID = @EID
AND
CheckTime = DateAdd(d, DateDiff(d, 0, Cast(CONVERT(VARCHAR(30),@Date,110) As datetime)), Cast(CONVERT(VARCHAR(10),@TimeOut,108) as datetime))
END
ELSE IF EXISTS(SELECT * FROM ShortLeave2
WHERE EID = @EID
AND
CheckTime = @TimeOut
)
BEGIN
UPDATE ShortLeave2
SET Remarks = @Remarks,
Comments = @Comments
WHERE
EID = @EID
AND
CheckTime = @TimeOut
END
ELSE IF NOT EXISTS(SELECT * FROM SHORTLEAVE2
WHERE
EID = @EID
AND
CheckTime = DateAdd(d, DateDiff(d, 0, Cast(CONVERT(VARCHAR(30),@Date,110) As datetime)), Cast(CONVERT(VARCHAR(10),@TIMEIN,108) as datetime))
)
BEGIN
INSERT INTO SHORTLEAVE2
SELECT
@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,
1
END
ELSE IF NOT EXISTS(SELECT * FROM SHORTLEAVE2
WHERE
EID = @EID
AND
CheckTime = DateAdd(d, DateDiff(d, 0, Cast(CONVERT(VARCHAR(30),@Date,110) As datetime)), Cast(CONVERT(VARCHAR(10),@TimeOut,108) as datetime))
)
BEGIN
SELECT
@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,
1
END
END
Thanks in Advance.... |
|
Condition Logic
