ALTER PROCEDURE [dbo].[WEB_Account_Login2]
 @in_EMail varchar(100),
 @in_Password varchar(100)
AS
BEGIN
 SET NOCOUNT ON;
 --declare @CustomerID int
 declare @MD5Password varchar(100)
 --declare @AccountStatus int = 0 -- this is Accounts.AccountStatus

 -- this call is always valid
 --select 0 as ResultCode

 -- search for record with username
   SELECT
  --@CustomerID=CustomerID,
  @MD5Password=MD5Password
 FROM Accounts
 WHERE email=@in_Email
 if (@@RowCount = 0) begin
  --
  select
   1 as LoginResult
   --0 as CustomerID,
  return
 end
end