-- validate that email is unique
if exists (SELECT CustomerID from Accounts WHERE email=@in_Email) begin
select 2 as ResultCode, 'Email already in use' as ResultMsg;
return;
end
-- validate that IP is unique --mt
if exists (SELECT CustomerID from Accounts WHERE lastloginIP=@in_IP) begin
select 2 as ResultCode, 'Already registered' as ResultMsg;
return;
end