spEmailIDAndEmailLinkIsValidFromEmailJobRecipientIDAndLink

CREATE PROCEDURE [dbo].[spEmailIDAndEmailLinkIsValidFromEmailJobRecipientIDAndLink]
( @EmailJobRecipientID int, @URL nvarchar(448)) AS
BEGIN
    set nocount on

    declare @emaillink table (url nvarchar(1784))
    declare @result bit
    set @result = 0
    declare @EmailID int

    select @EmailID = EmailID
    from emailjob_recipient
    where id = @EmailJobRecipientID

    if isnull(@EmailID,0) > 0
    begin
        insert into @emaillink(url)
        select url
        from emaillink
        where emailid = @EmailID
        and isnull(pid,0) = 0

        select @result = case when count(*) > 0 then 1 else 0 end
        from @emaillink
        where url = @url

  end

    select @EmailID EmailID, @result Valid
END