USP_CONFIGURATIONDATACATALOG_AVAILABLEDEFINITIONS

            create procedure dbo.USP_CONFIGURATIONDATACATALOG_AVAILABLEDEFINITIONS
            as                
                set nocount on;

                select 
                    CONFIGURATIONDATACATALOG.ID as CONFIGURATIONDATAID, 
                    CONFIGURATIONDATACATALOG.DISPLAYNAME,                    
                    CONFIGURATIONDATACATALOG.CONFIGURATIONDATAFOLDER,
                    CONFIGURATIONDATACATALOG.CONFIGURATIONDATASPECXML
                from 
                    dbo.CONFIGURATIONDATACATALOG                
                where
                    coalesce(DISPLAYNAME,'') <> ''
                order by 
                    CONFIGURATIONDATACATALOG.CONFIGURATIONDATAFOLDER, CONFIGURATIONDATACATALOG.DISPLAYNAME