USP_DATALIST_FAFEVENTCAMPAIGN_NFG_LIST

CREATE procedure dbo.USP_DATALIST_FAFEVENTCAMPAIGN_NFG_LIST
(
  @CONTEXTID uniqueidentifier,
  @NAME nvarchar(200)='',
  @TYPECODE uniqueidentifier=NULL
)
as
    set nocount on;

  if @NAME=''
    SET @NAME = null

    select FNC.ID,
       FNC.NAME,
           C.NAME AS CONTACTNAME,
           FNTC.DESCRIPTION AS TYPE,
           NFGS.TOTALRAISED,
       FNC.TOTALREVENUEGOAL,
       NFGS.TOTALPARTICIPANTS
    from dbo.FAFNFGCAMPAIGN FNC (nolock)
  left join dbo.V_NFG_SUMMARYINFO NFGS on NFGS.ID = FNC.ID
  left JOIN dbo.CONSTITUENT C on C.ID = FNC.CONTACTID
  left JOIN dbo.FAFNFGTYPECODE FNTC ON FNTC.ID = FNC.NFGTYPECODEID
  where FNC.CAMPAIGNID = @CONTEXTID
  AND (@NAME is null or FNC.NAME like @NAME + '%')
  AND (@TYPECODE is null or FNC.NFGTYPECODEID = @TYPECODE)