USP_DATALIST_TEAMMEMBERCOUNTSEARCH

      CREATE procedure dbo.USP_DATALIST_TEAMMEMBERCOUNTSEARCH
      (@EVENTID uniqueidentifier,
       @TEAMFUNDRAISINGTEAMID uniqueidentifier = NULL
      )
      as
          set nocount on;

        DECLARE @TEAMMEMBERSCOUNT integer
        DECLARE @HOUSEHOLDMEMBERSCOUNT integer
        DECLARE @COMPANYMEMBERSCOUNT integer
        DECLARE @COMPANYTEAMSCOUNT integer

        SET @TEAMMEMBERSCOUNT = (SELECT COUNT(*) FROM dbo.UFN_FAF_TEAMMEMBERLIST_BY_TEAMID(@TEAMFUNDRAISINGTEAMID))  

        SET @HOUSEHOLDMEMBERSCOUNT = (SELECT COUNT(*) FROM dbo.UFN_FAF_HOUSEHOLDMEMBERS_BY_HHTEAMID(@TEAMFUNDRAISINGTEAMID))  

        SET @COMPANYMEMBERSCOUNT = (SELECT COUNT(*) FROM dbo.UFN_FAF_COMPANYINDIVIDUALLIST_BY_COMPANYID(@TEAMFUNDRAISINGTEAMID))

        SET @COMPANYTEAMSCOUNT = (SELECT COUNT(*) FROM dbo.UFN_FAF_GETTEAMHIEARACHY(@TEAMFUNDRAISINGTEAMID) WHERE [level] > 0 and TEAMID IN   
                                    (SELECT TEAMFUNDRAISINGTEAMID FROM dbo.TEAMEXTENSION where EVENTID=@EVENTID and (TYPECODE = 1 OR TYPECODE = 3))  
                                  )  

          select @TEAMMEMBERSCOUNT,
                   @HOUSEHOLDMEMBERSCOUNT,
               @COMPANYMEMBERSCOUNT,
               @COMPANYTEAMSCOUNT