USP_DATALIST_NIMBUSCODETABLERESOURCE

CREATE procedure dbo.USP_DATALIST_NIMBUSCODETABLERESOURCE
as
    with xmlnamespaces(default 'bb_appfx_codetable')
    select CODETABLECATALOG.ID,
        CODETABLECATALOG.CODETABLENAME NAME,
        N'' DESCRIPTION,
        CODETABLECATALOG.CODETABLESPECXML.value('CodeTableSpec[1]/@Author', 'nvarchar(4000)') AUTHOR,
        CODETABLECATALOG.DATEADDED,
        CODETABLECATALOG.DATECHANGED,
        CODETABLECATEGORY.DESCRIPTION CATEGORY,
        CODETABLECATALOG.DBTABLENAME
    from dbo.CODETABLECATALOG
    left join dbo.CODETABLECATEGORY on CODETABLECATALOG.CATEGORYID = CODETABLECATEGORY.ID
    order by CODETABLECATALOG.CODETABLENAME;