USP_DATALIST_NFGCAMPAIGNVIEW

    CREATE procedure dbo.USP_DATALIST_NFGCAMPAIGNVIEW(@CONSTITUENTID uniqueidentifier)
    as
        set nocount on;

        select CAMPAIGN.ID,
          NFG.ID as NFGID,
          NFG.NAME as GROUPNAME, 
          CAMPAIGN.NAME as CAMPAIGNNAME,
          isnull(SI.TOTALRAISED,0) as AMOUNTRAISED, 
          isnull(SI.TOTALPARTICIPANTS,0) as TOTALPARTICIPANTS,
          NFG.DATEADDED,
          NFG.GROUPCONSTITUENTID as CONSTITUENTID,
          COUNTNO = (select COUNT(*) from dbo.FAFNFGCAMPAIGN NFG where NFG.GROUPCONSTITUENTID = @CONSTITUENTID)
      from dbo.FAFPROGRAM CAMPAIGN
      inner join dbo.FAFNFGCAMPAIGN NFG on CAMPAIGN .ID = NFG.CAMPAIGNID 
      left join V_NFG_SUMMARYINFO SI on SI.ID = NFG.ID
      where NFG.GROUPCONSTITUENTID = @CONSTITUENTID