UFN_MATCHFINDER_GETCONSTITUENTLINKID
Returns the constituent record ID that has been linked to a MatchFinder Online record.
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MATCHFINDERRECORDID | int | IN |
Definition
Copy
create function dbo.UFN_MATCHFINDER_GETCONSTITUENTLINKID
(
@MATCHFINDERRECORDID int
)
returns uniqueidentifier
as
begin
return
(
select top 1
ID
from dbo.MATCHFINDERCONSTITUENT
where MATCHFINDERRECORDID = @MATCHFINDERRECORDID
)
end