USP_SIMPLEDATALIST_FEEDALERTINSTANCEDATALISTOUTPUTFIELDS

create procedure dbo.USP_SIMPLEDATALIST_FEEDALERTINSTANCEDATALISTOUTPUTFIELDS
(
    @FEEDALERTINSTANCEID uniqueidentifier
)
as

    set nocount on;

    with xmlnamespaces ('bb_appfx_datalist' as tns, 'bb_appfx_commontypes' as common)
    select 
        datalistoutput.fields.value('@FieldID', 'nvarchar(200)') as VALUE
    from dbo.FEEDALERTINSTANCE as INSTANCE 
        inner join dbo.ALERTTYPE on INSTANCE.ALERTTYPEID = ALERTTYPE.ID
        inner join dbo.DATALISTCATALOG as D on ALERTTYPE.DATALISTID = D.ID
        cross apply D.DATALISTSPEC.nodes('tns:DataListSpec/tns:Output/tns:OutputFields/tns:OutputField') as datalistoutput(fields)
    where INSTANCE.ID = @FEEDALERTINSTANCEID