Hi, try this...
Create PROCEDURE [dbo].[USP_GetUserDetails]
(
@UserName NVARCHAR(10),
@UserPassword NVARCHAR(100),
@LoginStatus BIT,
@IsActive NCHAR(1)
)
AS
BEGIN
DECLARE @USERID INT
SELECT USERID,UserName,UserPassword,LoginStatus,IsActive,DeptID
FROM dbo.UserLogin
WHERE UserName=@UserName AND UserPassword=@UserPassword AND LoginStatus =@LoginStatus AND IsActive=@IsActive
SELECT @USERID=USERID
FROM dbo.UserLogin
WHERE UserName=@UserName AND UserPassword=@UserPassword AND LoginStatus =@LoginStatus AND IsActive=@IsActive
UPDATE UserLogin set VisitCount=ISNULL(VisitCount,0)+1 where UserID=@USERID
END
GVPRabu