I write a query for insert records but some times it insert duplicate records
my query like this
DECLARE @cnt AS INT
SET @cnt=(SELECT COUNT(*) FROM
tbltest
WHERE
Empcode= @Uid AND
SID= @Sid AND
PID= @Pid AND
EmpID=@EmpId AND
RMID= @RMId AND
EndTime IS NULL)
IF @cnt=0
BEGIN
insert into tbltest (EmpCode,sid,Pid,Empid,RmId,Param1,Starttime,Transtype) values(
@Uid,
@Sid,
@Pid,
@EmpId,
@RMId,
@processname_param1,@CURRDATE,'Input')
END
i used code for avoiding duplication but some times it insert duplicate records.