USP_DATALIST_RegistrantBatchVerifyUserName

CREATE procedure dbo.USP_DATALIST_RegistrantBatchVerifyUserName(@UserName nvarchar(100))
as
    set nocount on;

  declare @status tinyint
  set @status = 0

  select @status = dbo.fnUserInformationExists(1, @UserName)

  if @status = 0 and EXISTS (SELECT TOP 1 ID FROM dbo.REGISTRANTBATCH WHERE USERID = @UserName)
        set @status = 1

  select @status as STATUS