UFN_MEMBERSHIPDUESBATCH_GETMEMBERSHIPPROGRAMADDONS_TOITEMLISTXML

Return

Return Type
xml

Parameters

Parameter	Parameter Type	Mode
@BATCHMEMBERSHIPDUESID	uniqueidentifier	IN
@MEMBERSHIPPROGRAMID	uniqueidentifier	IN
@TRANSACTIONCURRENCYID	uniqueidentifier	IN
@TRANSACTIONDATE	date	IN

Definition

Copy



CREATE function dbo.UFN_MEMBERSHIPDUESBATCH_GETMEMBERSHIPPROGRAMADDONS_TOITEMLISTXML
(
    @BATCHMEMBERSHIPDUESID uniqueidentifier,
    @MEMBERSHIPPROGRAMID uniqueidentifier,
    @TRANSACTIONCURRENCYID uniqueidentifier,
  @TRANSACTIONDATE date
)
returns xml
as begin
    declare @XML xml;

    set @XML = (
        select
            APPLY,
            ADDONID,
            ADDONTYPE,
            PRICE,
            NUMBEROFADDONS,
            MULTIPLEALLOWED,
            TRANSACTIONCURRENCYID
        from dbo.UFN_MEMBERSHIPDUESBATCH_GETMEMBERSHIPPROGRAMADDONS(@BATCHMEMBERSHIPDUESID, @MEMBERSHIPPROGRAMID, @TRANSACTIONCURRENCYID,@TRANSACTIONDATE)
        for xml raw('ITEM'),type,elements,root('MEMBERSHIPPROGRAMADDON'),BINARY BASE64
    );

    --set @XML = isnull(@XML, '<MEMBERSHIPPROGRAMADDONS></MEMBERSHIPPROGRAMADDONS>');


    return @XML;
end