Where you use

if (select count(*)

from MyTable

where email = @email

and active = 1

) > 1

select @allow = 0

would this be...