USP_DATALIST_NIMBUSDATALISTRESOURCE

CREATE procedure dbo.USP_DATALIST_NIMBUSDATALISTRESOURCE(@RECORDTYPEID uniqueidentifier = null)
as
    with xmlnamespaces(default 'bb_appfx_datalist')
    select DATALISTCATALOG.ID,
        DATALISTCATALOG.NAME,
        DATALISTCATALOG.DESCRIPTION,
        DATALISTCATALOG.DATALISTSPEC.value('DataListSpec[1]/@Author', 'nvarchar(4000)') AUTHOR,
        DATALISTCATALOG.DATEADDED,
        DATALISTCATALOG.DATECHANGED,
        DATALISTCATALOG.SECURITYUIFOLDER
    from dbo.DATALISTCATALOG
    where (@RECORDTYPEID is null and DATALISTCATALOG.RECORDTYPEID is null) or DATALISTCATALOG.RECORDTYPEID = @RECORDTYPEID
    order by DATALISTCATALOG.NAME;