UFN_FAFEVENT_GETREGISTRATIONOPTIONGOALS_TOITEMLISTXML
Used to convert the results of UFN_FAFEVENT_GETREGISTRATIONOPTIONGOALS to xml.
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTPRICEID | uniqueidentifier | IN |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 2/1/2011 9:06:15 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.9.1001.0, Culture=neutral, PublicKeyToken=null
Based on: UFN_FAFEVENT_GETREGISTRATIONOPTIONGOALS
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_FAFEVENT_GETREGISTRATIONOPTIONGOALS_TOITEMLISTXML](
@EVENTPRICEID uniqueidentifier
)
returns xml
as
BEGIN
RETURN (
SELECT [COMMUNICATIONS], [DONORRETENTION], [ID], [ISNOTLOWERCOMMUNICATION], [ISNOTLOWERDONORRETENTION], [ISNOTLOWERFUNDRAISING], [ISNOTLOWERRECRUITEMENT], [ISNOTLOWERTARGETFUNDRAISING], [ISNOTLOWERTEAMMEMBERRETENTION], [ISNOTLOWERTEAMMEMBERS], [ISNOTLOWERTEAMRETENTION], [ISNOTLOWERTEAMS], [ISNOTLOWERUNIT], [ISNOTLOWERVOLUNTEERRECRUITEMENT], [LABELFORUNIT], [MINFUNDRAISING], [PARTICIPANTMUSTPAYBALANCE], [PARTICIPANTPAYSBALANCEMESSAGE], [RECRUITEMENT], [REGTYPEGOALCODE], [TARGETFUNDRAISING], [TEAMMEMBERRETENTION], [TEAMMEMBERS], [TEAMRETENTION], [TEAMS], [UNIT], [VOLUNTEERRECRUITEMENT]
FROM dbo.[UFN_FAFEVENT_GETREGISTRATIONOPTIONGOALS](@EVENTPRICEID)
for xml raw('ITEM'),type,elements,root('REGOPTIONGOALS'),BINARY BASE64
)
END