USP_DATALIST_CONSTITUENTPROFILEDASHBOARDRELATIONSHIPMANAGER

CREATE procedure dbo.USP_DATALIST_CONSTITUENTPROFILEDASHBOARDRELATIONSHIPMANAGER(@CONSTITUENTID uniqueidentifier, @ISVISIBLE bit = 1)
as
    set nocount on;

    if @ISVISIBLE = 1
        select NF.NAME as FUNDRAISER
        from dbo.RELATIONSHIPMANAGER
        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(RELATIONSHIPMANAGER.FUNDRAISERID) NF
        where RELATIONSHIPMANAGER.CONSTITUENTID = @CONSTITUENTID;