UFN_WPBIOGRAPHICAL_GETHHMEMBERS2_FROMITEMLISTXML

/*
Generated by Blackbaud AppFx Platform
Date:  11/11/2014 4:18:38 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_WPBIOGRAPHICAL_GETHHMEMBERS2
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_WPBIOGRAPHICAL_GETHHMEMBERS2_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(AGE)[1]','int') AS 'AGE',
T.c.value('(BIRTHDATE)[1]','char(8)') AS 'BIRTHDATE',
T.c.value('(FIRSTNAME)[1]','nvarchar(100)') AS 'FIRSTNAME',
T.c.value('(FULLNAME)[1]','nvarchar(500)') AS 'FULLNAME',
T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
T.c.value('(LASTNAME)[1]','nvarchar(100)') AS 'LASTNAME',
T.c.value('(MARITALSTATUS)[1]','nvarchar(100)') AS 'MARITALSTATUS',
T.c.value('(MARITALSTATUSCODEID)[1]','uniqueidentifier') AS 'MARITALSTATUSCODEID',
T.c.value('(MIDDLENAME)[1]','nvarchar(100)') AS 'MIDDLENAME',
T.c.value('(OCCUPATION)[1]','nvarchar(100)') AS 'OCCUPATION',
T.c.value('(SEQUENCE)[1]','int') AS 'SEQUENCE',
T.c.value('(SUFFIX)[1]','nvarchar(100)') AS 'SUFFIX',
T.c.value('(SUFFIXCODEID)[1]','uniqueidentifier') AS 'SUFFIXCODEID',
T.c.value('(TITLE)[1]','nvarchar(100)') AS 'TITLE',
T.c.value('(TITLECODEID)[1]','uniqueidentifier') AS 'TITLECODEID'
FROM @ITEMLISTXML.nodes('/HHMEMBERS/ITEM') T(c)
)