UFN_DISCOUNT_GETDISCOUNTPROGRAMS_FROMITEMLISTXML

This function returns a table from the XML for discounted programs.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ITEMLISTXML	xml	IN

Definition

Copy



            create function [dbo].[UFN_DISCOUNT_GETDISCOUNTPROGRAMS_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
            return (
            select            
            T.c.value('(DISCOUNTITEMID)[1]','uniqueidentifier') as 'DISCOUNTITEMID',            
            T.c.value('(QUALIFYINGITEMID)[1]','uniqueidentifier') as 'QUALIFYINGITEMID',
            T.c.value('(DISCOUNTGROUPID)[1]','uniqueidentifier') as 'DISCOUNTGROUPID',
            T.c.value('(PROGRAMID)[1]','uniqueidentifier') as 'PROGRAMID'
            from @ITEMLISTXML.nodes('/DISCOUNTPROGRAMS/ITEM') T(c)
            )