UFN_MKTSEGMENTATIONSEED_GETSEEDS_FROMITEMLISTXML

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:32:20 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_MKTSEGMENTATIONSEED_GETSEEDS
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_MKTSEGMENTATIONSEED_GETSEEDS_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(ADDRESSBLOCK)[1]','nvarchar(150)') AS 'ADDRESSBLOCK',
T.c.value('(CART)[1]','nvarchar(10)') AS 'CART',
T.c.value('(CITY)[1]','nvarchar(50)') AS 'CITY',
T.c.value('(COUNTRY)[1]','nvarchar(5)') AS 'COUNTRY',
T.c.value('(DPC)[1]','nvarchar(8)') AS 'DPC',
T.c.value('(EMAILADDRESS)[1]','nvarchar(100)') AS 'EMAILADDRESS',
T.c.value('(FIRSTNAME)[1]','nvarchar(50)') AS 'FIRSTNAME',
T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
T.c.value('(INACTIVE)[1]','bit') AS 'INACTIVE',
T.c.value('(LASTNAME)[1]','nvarchar(100)') AS 'LASTNAME',
T.c.value('(LOT)[1]','nvarchar(5)') AS 'LOT',
T.c.value('(MIDDLENAME)[1]','nvarchar(50)') AS 'MIDDLENAME',
T.c.value('(PHONENUMBER)[1]','nvarchar(100)') AS 'PHONENUMBER',
T.c.value('(POSTCODE)[1]','nvarchar(12)') AS 'POSTCODE',
T.c.value('(SELECTED)[1]','int') AS 'SELECTED',
T.c.value('(SITE)[1]','nvarchar(1024)') AS 'SITE',
T.c.value('(STATE)[1]','nvarchar(5)') AS 'STATE',
T.c.value('(SUFFIX)[1]','nvarchar(100)') AS 'SUFFIX',
T.c.value('(TITLE)[1]','nvarchar(100)') AS 'TITLE'
FROM @ITEMLISTXML.nodes('/SEEDS/ITEM') T(c)
)