UFN_FAFEVENT_GETREGISTRATIONOPTIONGOALS_FROMITEMLISTXML
Used to convert an xml string to a table based on UFN_FAFEVENT_GETREGISTRATIONOPTIONGOALS.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ITEMLISTXML | xml | 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_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT
T.c.value('(COMMUNICATIONS)[1]','int') AS 'COMMUNICATIONS',
T.c.value('(DONORRETENTION)[1]','decimal(7, 4)') AS 'DONORRETENTION',
T.c.value('(ID)[1]','varchar(36)') AS 'ID',
T.c.value('(ISNOTLOWERCOMMUNICATION)[1]','bit') AS 'ISNOTLOWERCOMMUNICATION',
T.c.value('(ISNOTLOWERDONORRETENTION)[1]','bit') AS 'ISNOTLOWERDONORRETENTION',
T.c.value('(ISNOTLOWERFUNDRAISING)[1]','bit') AS 'ISNOTLOWERFUNDRAISING',
T.c.value('(ISNOTLOWERRECRUITEMENT)[1]','bit') AS 'ISNOTLOWERRECRUITEMENT',
T.c.value('(ISNOTLOWERTARGETFUNDRAISING)[1]','bit') AS 'ISNOTLOWERTARGETFUNDRAISING',
T.c.value('(ISNOTLOWERTEAMMEMBERRETENTION)[1]','bit') AS 'ISNOTLOWERTEAMMEMBERRETENTION',
T.c.value('(ISNOTLOWERTEAMMEMBERS)[1]','bit') AS 'ISNOTLOWERTEAMMEMBERS',
T.c.value('(ISNOTLOWERTEAMRETENTION)[1]','bit') AS 'ISNOTLOWERTEAMRETENTION',
T.c.value('(ISNOTLOWERTEAMS)[1]','bit') AS 'ISNOTLOWERTEAMS',
T.c.value('(ISNOTLOWERUNIT)[1]','bit') AS 'ISNOTLOWERUNIT',
T.c.value('(ISNOTLOWERVOLUNTEERRECRUITEMENT)[1]','bit') AS 'ISNOTLOWERVOLUNTEERRECRUITEMENT',
T.c.value('(LABELFORUNIT)[1]','nvarchar(50)') AS 'LABELFORUNIT',
T.c.value('(MINFUNDRAISING)[1]','money') AS 'MINFUNDRAISING',
T.c.value('(PARTICIPANTMUSTPAYBALANCE)[1]','bit') AS 'PARTICIPANTMUSTPAYBALANCE',
T.c.value('(PARTICIPANTPAYSBALANCEMESSAGE)[1]','nvarchar(1000)') AS 'PARTICIPANTPAYSBALANCEMESSAGE',
T.c.value('(RECRUITEMENT)[1]','int') AS 'RECRUITEMENT',
T.c.value('(REGTYPEGOALCODE)[1]','tinyint') AS 'REGTYPEGOALCODE',
T.c.value('(TARGETFUNDRAISING)[1]','money') AS 'TARGETFUNDRAISING',
T.c.value('(TEAMMEMBERRETENTION)[1]','decimal(7, 4)') AS 'TEAMMEMBERRETENTION',
T.c.value('(TEAMMEMBERS)[1]','int') AS 'TEAMMEMBERS',
T.c.value('(TEAMRETENTION)[1]','decimal(7, 4)') AS 'TEAMRETENTION',
T.c.value('(TEAMS)[1]','int') AS 'TEAMS',
T.c.value('(UNIT)[1]','int') AS 'UNIT',
T.c.value('(VOLUNTEERRECRUITEMENT)[1]','int') AS 'VOLUNTEERRECRUITEMENT'
FROM @ITEMLISTXML.nodes('/REGOPTIONGOALS/ITEM') T(c)
)