USP_SELECTIONBRIEF_INCLUSIONS

create procedure dbo.USP_SELECTIONBRIEF_INCLUSIONS
(
    @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(20)') as IMAGEKEY,
        ListItems.Item.value('NAME[1]', 'nvarchar(600)') as NAME,
        ListItems.Item.value('DESCRIPTION[1]', 'nvarchar(2048)') as DESCRIPTION,
        ListItems.Item.value('QUERYID[1]', 'uniqueidentifier') as QUERYID,
        ListItems.Item.value('QUERYTYPE[1]', 'int') as QUERYTYPE,
        ListItems.Item.value('RECORDTYPE[1]', 'nvarchar(100)') as RECORDTYPE,
        ListItems.Item.value('CANEDIT[1]', 'bit') as CANEDIT,
        ListItems.Item.value('USERGRANTEDRIGHTS[1]', 'bit') as USERGRANTEDRIGHTS
    from
        @XML.nodes('//listItems/item') as ListItems(Item)
end