USP_DATALIST_NIMBUSSIMPLEDATALISTRESOURCE
Returns a list of simple data list resources.
Definition
Copy
CREATE procedure dbo.USP_DATALIST_NIMBUSSIMPLEDATALISTRESOURCE
as
with xmlnamespaces(default 'bb_appfx_datalist')
select SIMPLEDATALISTCATALOG.ID,
SIMPLEDATALISTCATALOG.NAME,
SIMPLEDATALISTCATALOG.DESCRIPTION,
SIMPLEDATALISTCATALOG.SIMPLEDATALISTSPECXML.value('SimpleDataListSpec[1]/@Author', 'nvarchar(4000)') AUTHOR,
SIMPLEDATALISTCATALOG.DATEADDED,
SIMPLEDATALISTCATALOG.DATECHANGED
from dbo.SIMPLEDATALISTCATALOG
order by SIMPLEDATALISTCATALOG.NAME;