USP_IDSETREGISTER_GETFOREXECUTION

            create procedure dbo.USP_IDSETREGISTER_GETFOREXECUTION(@ID uniqueidentifier)
            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
                from dbo.IDSETREGISTER
                left join dbo.IDSETREGISTERSMARTQUERYINSTANCE on IDSETREGISTER.ID = IDSETREGISTERSMARTQUERYINSTANCE.IDSETREGISTERID            
                where IDSETREGISTER.ID = @ID