USP_DATALIST_RELATIONSHIPMANAGER

List of relationship managers on a constituent

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_RELATIONSHIPMANAGER(@CONTEXTID uniqueidentifier)
as
    set nocount on;

    select RELATIONSHIPMANAGER.ID,
           NF.NAME
    from dbo.RELATIONSHIPMANAGER
        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(RELATIONSHIPMANAGER.FUNDRAISERID) NF
    where RELATIONSHIPMANAGER.CONSTITUENTID = @CONTEXTID