USP_SELECTIONBRIEF_PACKAGEEXPENSES

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

    select
        ListItems.Item.value('ID[1]', 'uniqueidentifier') as ID,
        ListItems.Item.value('IMAGEKEY[1]', 'nvarchar(12)') as IMAGEKEY,
        ListItems.Item.value('PACKAGEID[1]', 'uniqueidentifier') as PACKAGEID,
        ListItems.Item.value('NAME[1]', 'nvarchar(100)') as NAME,
        ListItems.Item.value('CODE[1]', 'nvarchar(10)') as CODE,
        ListItems.Item.value('OFFERS[1]', 'nvarchar(20)') as OFFERS,
        ListItems.Item.value('COSTPERPIECE[1]', 'money') as COSTPERPIECE,
        ListItems.Item.value('RESPONSES[1]', 'nvarchar(20)') as RESPONSES,
        ListItems.Item.value('COSTPERRESPONSE[1]', 'money') as COSTPERRESPONSE,
        ListItems.Item.value('VARIABLECOST[1]', 'nvarchar(20)') as VARIABLECOST,
        ListItems.Item.value('FIXEDCOST[1]', 'nvarchar(20)') as FIXEDCOST,
        ListItems.Item.value('TOTALCOST[1]', 'nvarchar(20)') as TOTALCOST,
        ListItems.Item.value('CHANNEL[1]', 'nvarchar(50)') as CHANNEL,
        ListItems.Item.value('CHANNELCODE[1]', 'int') as CHANNELCODE,
        ListItems.Item.value('BASECURRENCYID[1]', 'uniqueidentifier') as BASECURRENCYID,
        ListItems.Item.value('CURRENCYISOCURRENCYCODE[1]', 'nvarchar(3)') as CURRENCYISOCURRENCYCODE,
        ListItems.Item.value('CURRENCYDECIMALDIGITS[1]', 'int') as CURRENCYDECIMALDIGITS,
        ListItems.Item.value('CURRENCYSYMBOL[1]', 'nvarchar(10)') as CURRENCYSYMBOL,
        ListItems.Item.value('CURRENCYSYMBOLDISPLAYSETTINGCODE[1]', 'int') as CURRENCYSYMBOLDISPLAYSETTINGCODE,
        ListItems.Item.value('TOTALCOSTFORDISPLAY[1]', 'nvarchar(50)') as TOTALCOSTFORDISPLAY
    from
        @XML.nodes('//listItems/item') as ListItems(Item)

end