USP_SMARTFIELD_AVAILABLESMARTFIELDS

CREATE procedure dbo.USP_SMARTFIELD_AVAILABLESMARTFIELDS
as                
    set nocount on;

    select 
        V_INSTALLED_SMARTFIELDCATALOG.ID as SMARTFIELDID, 
        V_INSTALLED_SMARTFIELDCATALOG.DISPLAYNAME,
        dbo.UFN_RECORDTYPE_GETNAMEBYID(V_INSTALLED_SMARTFIELDCATALOG.RECORDTYPEID) as SMARTFIELDRECORDTYPE,
        V_INSTALLED_SMARTFIELDCATALOG.DATATYPECODE as SMARTFIELDDATATYPE,
        V_INSTALLED_SMARTFIELDCATALOG.SMARTFIELDFOLDER,
        V_INSTALLED_SMARTFIELDCATALOG.SMARTFIELDSPECXML
    from 
        dbo.V_INSTALLED_SMARTFIELDCATALOG                
    where
        coalesce(DISPLAYNAME,'') <> ''
    order by 
        V_INSTALLED_SMARTFIELDCATALOG.SMARTFIELDFOLDER, dbo.UFN_RECORDTYPE_GETNAMEBYID(V_INSTALLED_SMARTFIELDCATALOG.RECORDTYPEID), V_INSTALLED_SMARTFIELDCATALOG.DISPLAYNAME;