UFN_REGISTRATIONPACKAGE_GETPACKAGESPRICES_TOITEMLISTXML

Used to convert the results of UFN_REGISTRATIONPACKAGE_GETPACKAGESPRICES to xml.

Return

Return Type
xml

Parameters

Parameter Parameter Type Mode Description
@EVENTID uniqueidentifier IN

Definition

Copy
/*
Generated by Blackbaud AppFx Platform
Date:  8/2/2010 7:10:56 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.7.1654.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_REGISTRATIONPACKAGE_GETPACKAGESPRICES
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_REGISTRATIONPACKAGE_GETPACKAGESPRICES_TOITEMLISTXML](
@EVENTID uniqueidentifier
    )
returns xml
as
BEGIN

RETURN (
SELECT [AMOUNT], [EVENTNAME], [EVENTPRICEEVENTID], [EVENTPRICEID], [EVENTREGISTRATIONTYPEDESCRIPTION], [EVENTREGISTRATIONTYPEID], [ID], [NAME], [RECEIPTAMOUNT], [REGISTRATIONCOUNT]
 FROM dbo.[UFN_REGISTRATIONPACKAGE_GETPACKAGESPRICES](@EVENTID)
 order by NAME, EVENTNAME, EVENTREGISTRATIONTYPEDESCRIPTION
 for xml raw('ITEM'),type,elements,root('PACKAGESPRICES'),BINARY BASE64

)

END