USP_DATALIST_TEAMSIZE

CREATE procedure dbo.USP_DATALIST_TEAMSIZE
(
@TEAMFUNDRAISINGTEAMID uniqueidentifier = null, 
@ROLETYPE tinyint = 1 --1: Team, 2:Company, 3:Household

)
as
    set nocount on;

  IF @ROLETYPE = 1
    BEGIN
      SELECT count(*) as Count FROM UFN_FAF_TEAMMEMBERLIST_BY_TEAMID(@TEAMFUNDRAISINGTEAMID)
    END

  IF @ROLETYPE = 2
    BEGIN
      SELECT count(*) as Count FROM UFN_FAF_COMPANYMEMBERLIST_BY_COMPANYID(@TEAMFUNDRAISINGTEAMID)
    END

  IF @ROLETYPE = 3
    BEGIN
      SELECT count(*) as Count FROM UFN_FAF_HOUSEHOLDMEMBERS_BY_HHTEAMID(@TEAMFUNDRAISINGTEAMID)
    END