USP_SMARTQUERY_GETLIST

CREATE procedure dbo.USP_SMARTQUERY_GETLIST
as

select
    SMARTQUERYCATALOG.ID,
    SMARTQUERYCATALOG.NAME,
    SMARTQUERYCATALOG.DESCRIPTION,
    RECORDTYPE.NAME 'RECORDTYPE',
    SMARTQUERYCATALOG.UINAME
from
    dbo.SMARTQUERYCATALOG
    inner join dbo.RECORDTYPE on SMARTQUERYCATALOG.RECORDTYPEID = RECORDTYPE.ID
order by
    SMARTQUERYCATALOG.UINAME;