USP_GET_DIRECTORYOPTSTATUS_BYRECORDID

create procedure dbo.USP_GET_DIRECTORYOPTSTATUS_BYRECORDID
@RecordID uniqueidentifier 
as
begin    
    declare @isOptout as bit =0
    select @isOptout =[OptOut] from [DirectoryOptStatus] where [RecordID] = @RecordID 
    select isnull(@isOptout,0) as OptOut 
end