UFN_FAFEVENT_GETEVENTGOAL_FROMITEMLISTXML

/*
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_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(COMMUNICATIONCOMPANY)[1]','int') AS 'COMMUNICATIONCOMPANY',
T.c.value('(COMMUNICATIONDAILY)[1]','int') AS 'COMMUNICATIONDAILY',
T.c.value('(COMMUNICATIONHOUSEHOLD)[1]','int') AS 'COMMUNICATIONHOUSEHOLD',
T.c.value('(COMMUNICATIONINDIVIDUAL)[1]','int') AS 'COMMUNICATIONINDIVIDUAL',
T.c.value('(COMMUNICATIONMONTHLY)[1]','int') AS 'COMMUNICATIONMONTHLY',
T.c.value('(COMMUNICATIONSPONSOR)[1]','int') AS 'COMMUNICATIONSPONSOR',
T.c.value('(COMMUNICATIONTEAM)[1]','int') AS 'COMMUNICATIONTEAM',
T.c.value('(COMMUNICATIONTOTAL)[1]','int') AS 'COMMUNICATIONTOTAL',
T.c.value('(COMMUNICATIONWEEKLY)[1]','int') AS 'COMMUNICATIONWEEKLY',
T.c.value('(COPYBATCHGUID)[1]','uniqueidentifier') AS 'COPYBATCHGUID',
T.c.value('(COPYSOURCEID)[1]','uniqueidentifier') AS 'COPYSOURCEID',
T.c.value('(ID)[1]','varchar(36)') AS 'ID',
T.c.value('(ISACTIVE)[1]','bit') AS 'ISACTIVE',
T.c.value('(MINIMIMUMDONORGOAL)[1]','int') AS 'MINIMIMUMDONORGOAL',
T.c.value('(MINIMIMUMFUNDRAISINGGOAL)[1]','money') AS 'MINIMIMUMFUNDRAISINGGOAL',
T.c.value('(MINIMIMUMNEWDONORGOAL)[1]','int') AS 'MINIMIMUMNEWDONORGOAL',
T.c.value('(MINIMIMUMNEWMEMBERGOAL)[1]','int') AS 'MINIMIMUMNEWMEMBERGOAL',
T.c.value('(MINIMIMUMPARTICIPANTGOAL)[1]','int') AS 'MINIMIMUMPARTICIPANTGOAL',
T.c.value('(MINIMIMUMTEAMMEMBERGOAL)[1]','int') AS 'MINIMIMUMTEAMMEMBERGOAL',
T.c.value('(MINIMUMFUNDRAISEGOALPERMEMBER)[1]','money') AS 'MINIMUMFUNDRAISEGOALPERMEMBER',
T.c.value('(RECRUITMENTCOMPANY)[1]','int') AS 'RECRUITMENTCOMPANY',
T.c.value('(RECRUITMENTCOMPANYRETENTION)[1]','decimal(6, 5)') AS 'RECRUITMENTCOMPANYRETENTION',
T.c.value('(RECRUITMENTDAILY)[1]','int') AS 'RECRUITMENTDAILY',
T.c.value('(RECRUITMENTDONOR)[1]','int') AS 'RECRUITMENTDONOR',
T.c.value('(RECRUITMENTDONORRETENTION)[1]','decimal(6, 5)') AS 'RECRUITMENTDONORRETENTION',
T.c.value('(RECRUITMENTFITNESSCOACHES)[1]','int') AS 'RECRUITMENTFITNESSCOACHES',
T.c.value('(RECRUITMENTFITNESSCOACHRETENTION)[1]','decimal(6, 5)') AS 'RECRUITMENTFITNESSCOACHRETENTION',
T.c.value('(RECRUITMENTFUNDRAISINGCOACHES)[1]','int') AS 'RECRUITMENTFUNDRAISINGCOACHES',
T.c.value('(RECRUITMENTFUNDRAISINGCOACHRETENTION)[1]','decimal(6, 5)') AS 'RECRUITMENTFUNDRAISINGCOACHRETENTION',
T.c.value('(RECRUITMENTHOUSEHOLD)[1]','int') AS 'RECRUITMENTHOUSEHOLD',
T.c.value('(RECRUITMENTHOUSEHOLDRETENTION)[1]','decimal(6, 5)') AS 'RECRUITMENTHOUSEHOLDRETENTION',
T.c.value('(RECRUITMENTINDIVIDUAL)[1]','int') AS 'RECRUITMENTINDIVIDUAL',
T.c.value('(RECRUITMENTINDIVIDUALRETENTION)[1]','decimal(6, 5)') AS 'RECRUITMENTINDIVIDUALRETENTION',
T.c.value('(RECRUITMENTMONTHLY)[1]','int') AS 'RECRUITMENTMONTHLY',
T.c.value('(RECRUITMENTSPONSOR)[1]','int') AS 'RECRUITMENTSPONSOR',
T.c.value('(RECRUITMENTSPONSORRETENTION)[1]','decimal(6, 5)') AS 'RECRUITMENTSPONSORRETENTION',
T.c.value('(RECRUITMENTTEAM)[1]','int') AS 'RECRUITMENTTEAM',
T.c.value('(RECRUITMENTTEAMRETENTION)[1]','decimal(6, 5)') AS 'RECRUITMENTTEAMRETENTION',
T.c.value('(RECRUITMENTTOTAL)[1]','int') AS 'RECRUITMENTTOTAL',
T.c.value('(RECRUITMENTWEEKLY)[1]','int') AS 'RECRUITMENTWEEKLY',
T.c.value('(REVENUECOMPANY)[1]','money') AS 'REVENUECOMPANY',
T.c.value('(REVENUECOMPANYRETENTION)[1]','decimal(6, 5)') AS 'REVENUECOMPANYRETENTION',
T.c.value('(REVENUEDAILY)[1]','money') AS 'REVENUEDAILY',
T.c.value('(REVENUEHOUSEHOLD)[1]','money') AS 'REVENUEHOUSEHOLD',
T.c.value('(REVENUEHOUSEHOLDRETENTION)[1]','decimal(6, 5)') AS 'REVENUEHOUSEHOLDRETENTION',
T.c.value('(REVENUEINDIVIDUAL)[1]','money') AS 'REVENUEINDIVIDUAL',
T.c.value('(REVENUEINDIVIDUALRETENTION)[1]','decimal(6, 5)') AS 'REVENUEINDIVIDUALRETENTION',
T.c.value('(REVENUEMONTHLY)[1]','money') AS 'REVENUEMONTHLY',
T.c.value('(REVENUEREGISTRATION)[1]','money') AS 'REVENUEREGISTRATION',
T.c.value('(REVENUEREGISTRATIONRETENTION)[1]','decimal(6, 5)') AS 'REVENUEREGISTRATIONRETENTION',
T.c.value('(REVENUERETENTION)[1]','decimal(6, 5)') AS 'REVENUERETENTION',
T.c.value('(REVENUESPONSOR)[1]','money') AS 'REVENUESPONSOR',
T.c.value('(REVENUESPONSORRETENTION)[1]','decimal(6, 5)') AS 'REVENUESPONSORRETENTION',
T.c.value('(REVENUETEAM)[1]','money') AS 'REVENUETEAM',
T.c.value('(REVENUETEAMRETENTION)[1]','decimal(6, 5)') AS 'REVENUETEAMRETENTION',
T.c.value('(REVENUETOTAL)[1]','money') AS 'REVENUETOTAL',
T.c.value('(REVENUEWEEKLY)[1]','money') AS 'REVENUEWEEKLY'
FROM @ITEMLISTXML.nodes('/EVENTGOAL/ITEM') T(c)
)