UFN_FAFEVENT_GETEVENTEMAILTEMPLATE_FROMITEMLISTXML

/*
Generated by Blackbaud AppFx Platform
Date:  3/19/2013 1:17:35 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_FAFEVENT_GETEVENTEMAILTEMPLATE
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_FAFEVENT_GETEVENTEMAILTEMPLATE_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(CCEMAILADDRESSES)[1]','nvarchar(2000)') AS 'CCEMAILADDRESSES',
T.c.value('(CONTENTHTML)[1]','nvarchar(max)') AS 'CONTENTHTML',
T.c.value('(COPYBATCHGUID)[1]','uniqueidentifier') AS 'COPYBATCHGUID',
T.c.value('(COPYSOURCEID)[1]','int') AS 'COPYSOURCEID',
T.c.value('(CURRENTSTATUS)[1]','bit') AS 'CURRENTSTATUS',
T.c.value('(DATASOURCEID)[1]','int') AS 'DATASOURCEID',
T.c.value('(DELETED)[1]','bit') AS 'DELETED',
T.c.value('(DESCRIPTION)[1]','nvarchar(255)') AS 'DESCRIPTION',
T.c.value('(ENABLED)[1]','bit') AS 'ENABLED',
T.c.value('(ETYPECODE)[1]','tinyint') AS 'ETYPECODE',
T.c.value('(FAFTASKID)[1]','uniqueidentifier') AS 'FAFTASKID',
T.c.value('(FORCOMPLEADER)[1]','bit') AS 'FORCOMPLEADER',
T.c.value('(FORFUNDCOACH)[1]','bit') AS 'FORFUNDCOACH',
T.c.value('(FORHH)[1]','bit') AS 'FORHH',
T.c.value('(FORHHMEMBER)[1]','bit') AS 'FORHHMEMBER',
T.c.value('(FORINDIVIDUAL)[1]','bit') AS 'FORINDIVIDUAL',
T.c.value('(FORSPONSOR)[1]','bit') AS 'FORSPONSOR',
T.c.value('(FORTEAMLEADER)[1]','bit') AS 'FORTEAMLEADER',
T.c.value('(FORTEAMMEMBER)[1]','bit') AS 'FORTEAMMEMBER',
T.c.value('(FROMADDRESS)[1]','nvarchar(255)') AS 'FROMADDRESS',
T.c.value('(FROMDISPLAYNAME)[1]','nvarchar(255)') AS 'FROMDISPLAYNAME',
T.c.value('(GUID)[1]','varchar(36)') AS 'GUID',
T.c.value('(ID)[1]','int') AS 'ID',
T.c.value('(ISACTIVE)[1]','bit') AS 'ISACTIVE',
T.c.value('(ISDEFAULTFORTASK)[1]','bit') AS 'ISDEFAULTFORTASK',
T.c.value('(NAME)[1]','nvarchar(4000)') AS 'NAME',
T.c.value('(NCNOTIFICATIONID)[1]','int') AS 'NCNOTIFICATIONID',
T.c.value('(NOTICATIONDESCRIPTION)[1]','nvarchar(4000)') AS 'NOTICATIONDESCRIPTION',
T.c.value('(NOTICATIONNAME)[1]','nvarchar(4000)') AS 'NOTICATIONNAME',
T.c.value('(NOTIFICATIONTYPEID)[1]','int') AS 'NOTIFICATIONTYPEID',
T.c.value('(PREVIOUSSTATUS)[1]','bit') AS 'PREVIOUSSTATUS',
T.c.value('(PRIORITY)[1]','int') AS 'PRIORITY',
T.c.value('(RECIPIENTCOMPLEADER)[1]','bit') AS 'RECIPIENTCOMPLEADER',
T.c.value('(RECIPIENTDONOR)[1]','bit') AS 'RECIPIENTDONOR',
T.c.value('(RECIPIENTHHLEADER)[1]','bit') AS 'RECIPIENTHHLEADER',
T.c.value('(RECIPIENTHHMEMBER)[1]','bit') AS 'RECIPIENTHHMEMBER',
T.c.value('(RECIPIENTINDIVIDUAL)[1]','bit') AS 'RECIPIENTINDIVIDUAL',
T.c.value('(RECIPIENTPROSPECT)[1]','bit') AS 'RECIPIENTPROSPECT',
T.c.value('(RECIPIENTTEAMLEADER)[1]','bit') AS 'RECIPIENTTEAMLEADER',
T.c.value('(RECIPIENTTEAMMEMBER)[1]','bit') AS 'RECIPIENTTEAMMEMBER',
T.c.value('(REPLYADDRESS)[1]','nvarchar(255)') AS 'REPLYADDRESS',
T.c.value('(SUBJECT)[1]','nvarchar(255)') AS 'SUBJECT',
T.c.value('(TYPE)[1]','tinyint') AS 'TYPE'
FROM @ITEMLISTXML.nodes('/EVENTEMAILTEMPLATES/ITEM') T(c)
)