USP_IDSETREGISTER_GETBYNAME

            create procedure dbo.USP_IDSETREGISTER_GETBYNAME(@NAME nvarchar(255))
            as
                select IDSETREGISTER.ID,
                    IDSETREGISTER.NAME,
                    IDSETREGISTER.DESCRIPTION,
                    IDSETREGISTER.RECORDTYPEID,
                    IDSETREGISTER.DBOBJECTNAME,
                    IDSETREGISTER.OBJECTTYPE,
                    IDSETREGISTER.STATIC,
                    IDSETREGISTER.NUMROWS,
                    IDSETREGISTER.USEINQUERYDESIGNER,
                    IDSETREGISTER.ADDEDBYID,
                    IDSETREGISTER.CHANGEDBYID,
                    IDSETREGISTER.DATEADDED,
                    IDSETREGISTER.DATECHANGED,
                    IDSETREGISTER.TS,
                    IDSETREGISTER.TSLONG,
                    IDSETREGISTERSMARTQUERYINSTANCE.SMARTQUERYINSTANCEID,
                    IDSETREGISTERADHOCQUERY.ADHOCQUERYID
                from dbo.IDSETREGISTER
                left join dbo.IDSETREGISTERSMARTQUERYINSTANCE on IDSETREGISTER.ID = IDSETREGISTERSMARTQUERYINSTANCE.IDSETREGISTERID
                left join dbo.IDSETREGISTERADHOCQUERY on IDSETREGISTER.ID = IDSETREGISTERADHOCQUERY.IDSETREGISTERID
                where IDSETREGISTER.NAME = @NAME