i have used triger on table.This triger is fire when i insert data in LeaveFrom Table.In My Stored procedure if condition i have put.when i put if condition code in if condition is not working.If i remove if codition then insert work successfully.My I have try this code in Query builder.data is comming when if is fire.but what is problem in storeprocedure code,that i dont know.
My Triger is:
ALTER TRIGGER Trigger2
My Storeprocedure is..
ALTER PROCEDURE dbo.Biometrics_InsertFrom_LeaveForm
Declare @Count int
Declare @LeaveFrom datetime
Declare @LeaveTo datetime
Declare @Approve bit
select @Count=count(*) from LeaveForm where Approve=@Approve and (convert(varchar,@LeaveFrom,101)=convert(varchar,getdate(),101) or convert(varchar,@LeaveTo,101)=convert(varchar,getdate(),101))
if(@Count > 0)
INSERT INTO Biometrics (PCL,PLE)
Edited 4-Feb-13 21:00pm
It works for me, so my assumption is that your WHERE condition is returning no records.
I'm not quite sure what you are trying to do, but the condition does look a bit rubbish. If you are trying to see in the current date is between two leave dates, then why not just use BETWEEN? Never convert dates to a string to compare them!
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)