USP_DATALIST_NIMBUSSEARCHLISTRESOURCE

CREATE procedure dbo.USP_DATALIST_NIMBUSSEARCHLISTRESOURCE
as
    with xmlnamespaces(default 'bb_appfx_searchlist',
        'bb_appfx_commontypes' as c)
    select SEARCHLISTCATALOG.ID,
        SEARCHLISTCATALOG.NAME,
        SEARCHLISTCATALOG.DESCRIPTION,
        SEARCHLISTCATALOG.SEARCHLISTSPEC.value('SearchListSpec[1]/@Author', 'nvarchar(4000)') AUTHOR,
        SEARCHLISTCATALOG.DATEADDED,
        SEARCHLISTCATALOG.DATECHANGED,
        SEARCHLISTCATALOG.SEARCHLISTSPEC.value('SearchListSpec[1]/@c:SecurityUIFolder', 'nvarchar(4000)') SECURITYUIFOLDER
    from dbo.SEARCHLISTCATALOG
    order by SEARCHLISTCATALOG.NAME;