USP_GET_REGISTEREDUSERLISTCOUNT

      create procedure dbo.USP_GET_REGISTEREDUSERLISTCOUNT  
      (
            @CLIENTSID int 
      )
      as
      begin
        -- SET NOCOUNT ON added to prevent extra result sets from

          -- interfering with SELECT statements.

          set nocount on;
        select count(1) as RecordCount from dbo.CLIENTUSERS where (CLIENTSID=@CLIENTSID or INTERNALUSER<>0) and DELETED=0    and ACTIVE = 1
      end