USP_DATALIST_ACQUISITIONLISTMEMBERNAME

Returns an acquisition list members name given a constituent ID.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN
@REVENUEBATCH	bit	IN

Definition

Copy



                create procedure dbo.USP_DATALIST_ACQUISITIONLISTMEMBERNAME
                (
                    @CONSTITUENTID uniqueidentifier,
          @REVENUEBATCH bit = 0
                )
                as
                    set nocount on;
          if @REVENUEBATCH = 0
              select [NAME] from dbo.[MKTFINDERNUMBERCONSTITUENT] where [ID] = @CONSTITUENTID;
          else
            select [NAME] from dbo.[BATCHREVENUECONSTITUENT] where [ID] = @CONSTITUENTID;
                    return 0;