There is error while executing stored procedure

Getting error in SQL server stored procedure when executing it:

    USE [ConsumerBanking]  
    GO  
    SET ANSI_NULLS ON  
    GO  
    SET QUOTED_IDENTIFIER ON  
    GO  
      
    CREATE  PROCEDURE [dbo].[GetCBLoginInfo]  
        @UserName VARCHAR(20),  
        @Password varchar(20)  
    AS  
    SET NOCOUNT ON  
    Declare @Failedcount AS INT  
    SET @Failedcount = (SELECT LoginFailedCount from CBLoginInfo WHERE UserName = @UserName)  
      
    IF EXISTS(SELECT * FROM CBLoginInfo WHERE UserName = @UserName)  
      
     BEGIN  
      
     IF EXISTS(SELECT * FROM CBLoginInfo WHERE UserName = @UserName AND Password = @Password )  
        SELECT 'Success' AS UserExists  
    ELSE  
      
    Update CBLoginInfo set  LoginFailedCount = @Failedcount+1  WHERE UserName = @UserName  
      
    Update CBLoginInfo set LastLoginDate=GETDATE()  WHERE UserName = @UserName  
     BEGIN  
    IF @Failedcount >=5  
      
      
    SELECT 'Maximum Attempt Reached (5 times) .Your Account is locked now.' AS UserExists  
    ELSE  
      
    select CONVERT(varchar(10), (SELECT LoginFailedCount from CBLoginInfo   WHERE UserName = @UserName))   AS UserFailedcount  
    END   
    END  
     ELSE  
      
     BEGIN   
      
    SELECT 'User Does not Exists' AS UserExists  
     END  

---

1 Answers