USP_DATALIST_IDSETREGISTERADHOCQUERY

      CREATE procedure dbo.USP_DATALIST_IDSETREGISTERADHOCQUERY
      (
            @QUERYID int = null
        )
        as
            set nocount on;

            SELECT 
              A.ID, 
              A.NAME
          from dbo.ADHOCQUERY A (NOLOCK)
          INNER JOIN dbo.IDSETREGISTERADHOCQUERY I (NOLOCK)
          ON A.ID = I.ADHOCQUERYID
          INNER JOIN dbo.BBNCIDSETIDMAP M (NOLOCK)
          ON M.IDSETREGISTERID = I.IDSETREGISTERID
          WHERE M.ID = ISNULL(@QUERYID,M.ID)