UFN_MKTRECORDSOURCE_GETUSAGESTATISTICSQUERYCOUNT

create function dbo.[UFN_MKTRECORDSOURCE_GETUSAGESTATISTICSQUERYCOUNT]
(
  @RECORDSOURCEID uniqueidentifier
)
returns integer
as
  begin
    declare @QUERYCOUNT integer;

    set @QUERYCOUNT = 0;

    with [RECORDTYPES] ([RECORDTYPEID]) as
    (
      select [ID] from dbo.[UFN_MKTRECORDSOURCE_GETRECORDTYPES](@RECORDSOURCEID, null, null)
      union all
      select [ID] from dbo.[UFN_MKTGIFTRECORDSOURCE_GETRECORDTYPES](@RECORDSOURCEID, null)
      union all
      select [ID] from dbo.[UFN_MKTMEMBERSHIPRECORDSOURCE_GETRECORDTYPES](@RECORDSOURCEID, null)
      union all
      select [ID] from dbo.[UFN_MKTSPONSORSHIPRECORDSOURCE_GETRECORDTYPES](@RECORDSOURCEID, null)
    ), [QUERYVIEWS] ([QUERYVIEWCATALOGID]) as
    (
      select [ID]
      from dbo.[QUERYVIEWCATALOG]
      inner join [RECORDTYPES] on [RECORDTYPES].[RECORDTYPEID] = [QUERYVIEWCATALOG].[RECORDTYPEID]
    )
    select 
      @QUERYCOUNT = 
        (select count([ADHOCQUERY].[ID])
         from dbo.[ADHOCQUERY]
         inner join [QUERYVIEWS] on [QUERYVIEWS].[QUERYVIEWCATALOGID] = [ADHOCQUERY].[QUERYVIEWCATALOGID])
        +
        (select count([SMARTQUERYINSTANCE].[ID])
         from dbo.[SMARTQUERYINSTANCE]
         inner join dbo.[SMARTQUERYCATALOG] on [SMARTQUERYCATALOG].[ID] = [SMARTQUERYINSTANCE].[SMARTQUERYCATALOGID]
         inner join [RECORDTYPES] on [RECORDTYPES].[RECORDTYPEID] = [SMARTQUERYCATALOG].[RECORDTYPEID])
        +
        (select count([IDSETREGISTER].[ID])
         from dbo.[IDSETREGISTER]
         inner join dbo.[IMPORTSELECTIONPROCESS] on [IMPORTSELECTIONPROCESS].[IDSETREGISTERID] = [IDSETREGISTER].[ID]
         inner join [RECORDTYPES] on [RECORDTYPES].[RECORDTYPEID] = [IMPORTSELECTIONPROCESS].[RECORDTYPEID]);

    return @QUERYCOUNT;
  end