USP_SELECTIONBRIEF_PREVIOUSEXCLUSIONS

create procedure dbo.USP_SELECTIONBRIEF_PREVIOUSEXCLUSIONS
(
    @XML xml
)
as
begin

    select
        ListItems.Item.value('ID[1]', 'uniqueidentifier') as ID,
        ListItems.Item.value('SEGMENTATIONFILTERID[1]', 'uniqueidentifier') as SEGMENTATIONFILTERID,
        ListItems.Item.value('IMAGEKEY[1]', 'nvarchar(100)') as IMAGEKEY,
        ListItems.Item.value('NAME[1]', 'nvarchar(100)') as NAME,
        ListItems.Item.value('DESCRIPTION[1]', 'nvarchar(255)') as DESCRIPTION
    from
        @XML.nodes('//listItems/item') as ListItems(Item)

end