Hi Everyone ,
I have a CircleId like Gujarat,maharashtra,uttarPradesh ..and So on
I want to perform three condition:
1 st Condition :If i found the same record in database,it should not save the Record.
2 nd Condition: New Record should get Add.
3 rd Condition:if i found more than 4 record for the same CircleId it should not allow to save.
But I am getting a Error as follows .
Msg 156, Level 15, State 1, Procedure K2_CHECKENTRYINFILELOG, Line 50
Incorrect syntax near the keyword 'begin'.
Msg 156, Level 15, State 1, Procedure K2_CHECKENTRYINFILELOG, Line 56
Incorrect syntax near the keyword 'else'.
Stored Procedure is As follows:
ALTER PROCEDURE [dbo].[K2_CHECKENTRYINFILELOG]
@FILENAME VARCHAR(150),
@FILEPATH VARCHAR(MAX),
@FILETYPE int,
@FILEDATE datetime,
@CIRCLEID INT,
@TOTALROWS int,
@SUCCESSCOUNT int,
@FAILURECOUNT int,
@PROCESSED bit,
@ERROR varchar(MAX),
@VENDORID int,
@CREATEDBY INT = 1,
@CREATEDON DATETIME,
@DELETED BIT=0,
@FILELOGID bigINT
AS
BEGIN
IF NOT EXISTS (
select count(CIRCLEID) from K2FILELOG where FILEPATH = @FILEPATH and
[FILENAME] = @FILENAME and
FILETYPE = @FILETYPE and
FILEDATE = @FILEDATE and
CIRCLEID = @CIRCLEID and
TOTALROWS = @TOTALROWS and
SUCCESSCOUNT = @SUCCESSCOUNT and
FAILURECOUNT = @FAILURECOUNT and
PROCESSED = @PROCESSED and
ERROR = @ERROR and
VENDORID = @VENDORID and
CREATEDBY = @CREATEDBY and
CREATEDON = @CREATEDON and
DELETED = @DELETED)
begin
INSERT INTO K2FILELOG
(FILEPATH, [FILENAME],FILETYPE,FILEDATE,CIRCLEID,TOTALROWS,SUCCESSCOUNT,FAILURECOUNT,PROCESSED,ERROR,VENDORID,CREATEDBY, CREATEDON, DELETED)
values (@FILEPATH ,@FILENAME,@FILETYPE,@FILEDATE,@CIRCLEID,@TOTALROWS,@SUCCESSCOUNT,@FAILURECOUNT,@PROCESSED,@ERROR ,@VENDORID,@CREATEDBY,@CREATEDON,@DELETED);
set @FILELOGID =@@identity
END
ELSE if
begin
select count (CIRCLEID) from K2FILELOG with (nolock) where FILETYPE = @FILETYPE and
FILEDATE = @FILEDATE and
CIRCLEID = @CIRCLEID
GROUP BY CIRCLEID having count(CIRCLEID) >= 4
END
else
begin
INSERT INTO K2FILELOG
(FILEPATH, [FILENAME],FILETYPE,FILEDATE,CIRCLEID,TOTALROWS,SUCCESSCOUNT,FAILURECOUNT,PROCESSED,ERROR,VENDORID,CREATEDBY, CREATEDON, DELETED)
values (@FILEPATH ,@FILENAME,@FILETYPE,@FILEDATE,@CIRCLEID,@TOTALROWS,@SUCCESSCOUNT,@FAILURECOUNT,@PROCESSED,@ERROR ,@VENDORID,@CREATEDBY,@CREATEDON,@DELETED);
set @FILELOGID =@@identity
end
END
Please Guide me .