fnGetClientRoleUserCount

CREATE function [dbo].[fnGetClientRoleUserCount]
( 
  @ClientRoleID int
)
    RETURNS int
AS
BEGIN
    declare @ROLEIDS table (ID int)
    insert into @ROLEIDS values(@ClientRoleID)

    insert into @ROLEIDS
    select * from dbo.UFN_CLIENTROLE_GETCHILDIDS(@ClientRoleID)            


    RETURN (                            
           select COUNT(distinct(UR.ClientUsersID))
           from dbo.UserRoles UR
           inner join @ROLEIDS R on R.ID = UR.ClientRolesID
           inner join dbo.ClientUsers CU on CU.ID = UR.ClientUsersID
           where CU.Deleted = 0
        )
END