How to use group by having clause in stored procedure

See more:

SQL

Hi Everyone,
I have CircleId as follows: 1,2,3,...10,11,12,13,14 and so on.
I have FileType as Follows: DBBH,NBH,DBH,BBH
I am totally confused in my Stored procedure.
There are two Condition in my Stored procedure as follows:
First Condition:if i found the number of records greater than equal to 4 for circleID = 14 then it will not allowed to save the record.
Second Condition:if records is already exists return zero.

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 OUT

AS	
BEGIN	
declare @Count int	
select @Count = count(*) from K2FILELOG where FILETYPE = @FILETYPE and	
                                              FILEDATE = @FILEDATE and	
                                              CIRCLEID = @CIRCLEID and	
                                              Processed = 1   	
IF (@Count = 1)	
BEGIN	
set @FILELOGID = -1	
return;	
  select FILETYPE,FILEDATE,CIRCLEID from K2FILELOG with (nolock) GROUP BY CIRCLEID
   having count(*) >= 4
/* where FILEPATH
          [FILENAME]
          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	*/
END	

ELSE IF	
@CIRCLEID >= 14 	
BEGIN	
SET @FILELOGID  = -1	
RETURN ;	
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