USP_BBNC_GETQUERYDATA

            CREATE procedure dbo.USP_BBNC_GETQUERYDATA
            (
                @QUERYID int
            )
            as
            set nocount on;

            select 
                IDSETREGISTER.DATEADDED,
                IDSETREGISTER.DATECHANGED,
                IDSETREGISTER.DESCRIPTION,
                IDSETREGISTER.STATIC,
                IDSETREGISTER.NAME as [QUERYNAME],
                RECORDTYPE.NAME as [RECORDTYPE],
                coalesce(IDSETREGISTER.NUMROWS,0) as [NUMBEROFRECORDS]

            from dbo.IDSETREGISTER
            inner join dbo.BBNCIDSETIDMAP on BBNCIDSETIDMAP.IDSETREGISTERID = IDSETREGISTER.ID
            inner join dbo.RECORDTYPE on RECORDTYPE.ID = IDSETREGISTER.RECORDTYPEID
            where BBNCIDSETIDMAP.ID = @QUERYID;