UFN_FAFEVENT_GETEVENTGOAL_TOITEMLISTXML
Used to convert the results of UFN_FAFEVENT_GETEVENTGOAL to xml.
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTID | uniqueidentifier | IN |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 2/1/2011 9:06:14 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.9.1001.0, Culture=neutral, PublicKeyToken=null
Based on: UFN_FAFEVENT_GETEVENTGOAL
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_FAFEVENT_GETEVENTGOAL_TOITEMLISTXML](
@EVENTID uniqueidentifier
)
returns xml
as
BEGIN
RETURN (
SELECT [COMMUNICATIONCOMPANY], [COMMUNICATIONDAILY], [COMMUNICATIONHOUSEHOLD], [COMMUNICATIONINDIVIDUAL], [COMMUNICATIONMONTHLY], [COMMUNICATIONSPONSOR], [COMMUNICATIONTEAM], [COMMUNICATIONTOTAL], [COMMUNICATIONWEEKLY], [COPYBATCHGUID], [COPYSOURCEID], [ID], [ISACTIVE], [MINIMIMUMDONORGOAL], [MINIMIMUMFUNDRAISINGGOAL], [MINIMIMUMNEWDONORGOAL], [MINIMIMUMNEWMEMBERGOAL], [MINIMIMUMPARTICIPANTGOAL], [MINIMIMUMTEAMMEMBERGOAL], [MINIMUMFUNDRAISEGOALPERMEMBER], [RECRUITMENTCOMPANY], [RECRUITMENTCOMPANYRETENTION], [RECRUITMENTDAILY], [RECRUITMENTDONOR], [RECRUITMENTDONORRETENTION], [RECRUITMENTFITNESSCOACHES], [RECRUITMENTFITNESSCOACHRETENTION], [RECRUITMENTFUNDRAISINGCOACHES], [RECRUITMENTFUNDRAISINGCOACHRETENTION], [RECRUITMENTHOUSEHOLD], [RECRUITMENTHOUSEHOLDRETENTION], [RECRUITMENTINDIVIDUAL], [RECRUITMENTINDIVIDUALRETENTION], [RECRUITMENTMONTHLY], [RECRUITMENTSPONSOR], [RECRUITMENTSPONSORRETENTION], [RECRUITMENTTEAM], [RECRUITMENTTEAMRETENTION], [RECRUITMENTTOTAL], [RECRUITMENTWEEKLY], [REVENUECOMPANY], [REVENUECOMPANYRETENTION], [REVENUEDAILY], [REVENUEHOUSEHOLD], [REVENUEHOUSEHOLDRETENTION], [REVENUEINDIVIDUAL], [REVENUEINDIVIDUALRETENTION], [REVENUEMONTHLY], [REVENUEREGISTRATION], [REVENUEREGISTRATIONRETENTION], [REVENUERETENTION], [REVENUESPONSOR], [REVENUESPONSORRETENTION], [REVENUETEAM], [REVENUETEAMRETENTION], [REVENUETOTAL], [REVENUEWEEKLY]
FROM dbo.[UFN_FAFEVENT_GETEVENTGOAL](@EVENTID)
for xml raw('ITEM'),type,elements,root('EVENTGOAL'),BINARY BASE64
)
END