UFN_SALESORDERITEMMEMBERSHIP_GETMEMBERSHIPCARDS_FROMITEMLISTXML

Returns a table containing sales order item membership card information.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ITEMLISTXML	xml	IN

Definition

Copy



            CREATE function [dbo].[UFN_SALESORDERITEMMEMBERSHIP_GETMEMBERSHIPCARDS_FROMITEMLISTXML](@ITEMLISTXML xml) 
            returns table as
                return 
                (
                    select
                        T.cards.value('(ID)[1]','uniqueidentifier') as 'ID',
                        T.cards.value('(MEMBERSHIPCARDID)[1]','uniqueidentifier') as 'MEMBERSHIPCARDID',
                        T.cards.value('(NAMEONCARD)[1]','nvarchar(700)') as 'NAMEONCARD',
                        T.cards.value('(EXPIRATIONDATE)[1]','datetime') as 'EXPIRATIONDATE',
                        T.cards.value('(../../ID)[1]','uniqueidentifier') as 'MEMBERID'
                    from 
                        @ITEMLISTXML.nodes('/MEMBERS/ITEM/MEMBERSHIPCARDS/ITEM') T(cards)
                )