UFN_CONSTITUENTID_GETRE7ID

Return

Return Type
int

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_CONSTITUENTID_GETRE7ID(@ID uniqueidentifier) returns int
as
begin
    declare @i int = -1;

  select @i = RE7INTEGRATIONCONSTITUENTMAP.RE7RECORDID
    from
        dbo.RE7INTEGRATIONCONSTITUENTMAP
    where
        RE7INTEGRATIONCONSTITUENTMAP.ID = @ID;

    return @i;
end