USP_EXPORTDEFINITIONFILELAYOUT_QUERYXML

create procedure dbo.USP_EXPORTDEFINITIONFILELAYOUT_QUERYXML
(
    @CLRDATALISTRESULTXML xml
)
as
begin
    declare @XML xml = @CLRDATALISTRESULTXML;    -- Implicit conversion


    select
        List.Item.value('FIELDPATH[1]', 'nvarchar(500)') as FIELDPATH,
        List.Item.value('HEADERNAME[1]', 'nvarchar(500)') as HEADERNAME,
        List.Item.value('DATATYPE[1]', 'nvarchar(30)') as DATATYPE,
        List.Item.value('SEQUENCE[1]', 'int') as SEQUENCE
    from
        @xml.nodes('//listItems/item') as List(Item);

end