UFN_MEMBERSHIPBENEFITS_SETIDSTONULL

create function dbo.UFN_MEMBERSHIPBENEFITS_SETIDSTONULL(@BENEFITS xml)
returns xml
with execute as caller
as begin

    declare @TempTbl table (
       [BENEFITID] uniqueidentifier,
       [DETAILS] nvarchar(255),
       [ID] uniqueidentifier,
       [QUANTITY] int,
       [SEQUENCE] int,
       [UNITVALUE] money)

    insert into @TempTbl
    SELECT
    T.c.value('(BENEFITID)[1]','uniqueidentifier') AS 'BENEFITID',
    T.c.value('(DETAILS)[1]','nvarchar(255)') AS 'DETAILS',
    T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
    T.c.value('(QUANTITY)[1]','int') AS 'QUANTITY',
    T.c.value('(SEQUENCE)[1]','int') AS 'SEQUENCE',
    T.c.value('(UNITVALUE)[1]','money') AS 'UNITVALUE'
    FROM @BENEFITS.nodes('/BENEFITS/ITEM') T(c)

    update @TempTbl set ID = null

    return (
            SELECT [BENEFITID], [DETAILS], [ID], [QUANTITY], [SEQUENCE], [UNITVALUE]
            FROM @TempTbl
            for xml raw('ITEM'),type,elements,root('BENEFITS'),BINARY BASE64
            )

end