UFN_BATCHCONSTITUENTUPDATE_GETADDRESSES_WITHDATES_FROMITEMLISTXML

CREATE FUNCTION dbo.[UFN_BATCHCONSTITUENTUPDATE_GETADDRESSES_WITHDATES_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(ADDRESSBLOCK)[1]','nvarchar(150)') AS 'ADDRESSBLOCK',
T.c.value('(ADDRESSID)[1]','uniqueidentifier') AS 'ADDRESSID',
T.c.value('(ADDRESSTYPECODEID)[1]','uniqueidentifier') AS 'ADDRESSTYPECODEID',
T.c.value('(CART)[1]','nvarchar(max)') AS 'CART',
T.c.value('(CERTIFICATIONDATA)[1]','int') AS 'CERTIFICATIONDATA',
T.c.value('(CITY)[1]','nvarchar(max)') AS 'CITY',
T.c.value('(CONGRESSIONALDISTRICTCODEID)[1]','uniqueidentifier') AS 'CONGRESSIONALDISTRICTCODEID',
T.c.value('(COUNTRYID)[1]','uniqueidentifier') AS 'COUNTRYID',
T.c.value('(COUNTYCODEID)[1]','uniqueidentifier') AS 'COUNTYCODEID',
T.c.value('(DONOTMAIL)[1]','bit') AS 'DONOTMAIL',
T.c.value('(DONOTMAILREASONCODEID)[1]','uniqueidentifier') AS 'DONOTMAILREASONCODEID',
T.c.value('(DPC)[1]','nvarchar(max)') AS 'DPC',
T.c.value('(ENDDATE)[1]','char(4)') AS 'ENDDATE',
T.c.value('(HISTORICALENDDATE)[1]','date') AS 'HISTORICALENDDATE',
T.c.value('(HISTORICALSTARTDATE)[1]','date') AS 'HISTORICALSTARTDATE',
T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
T.c.value('(INFOSOURCECODEID)[1]','uniqueidentifier') AS 'INFOSOURCECODEID',
T.c.value('(INFOSOURCECOMMENTS)[1]','nvarchar(256)') AS 'INFOSOURCECOMMENTS',
T.c.value('(ISPRIMARY)[1]','bit') AS 'ISPRIMARY',
T.c.value('(LASTVALIDATIONATTEMPTDATE)[1]','date') AS 'LASTVALIDATIONATTEMPTDATE',
T.c.value('(LOCALPRECINCTCODEID)[1]','uniqueidentifier') AS 'LOCALPRECINCTCODEID',
T.c.value('(LOT)[1]','nvarchar(5)') AS 'LOT',
T.c.value('(OMITFROMVALIDATION)[1]','bit') AS 'OMITFROMVALIDATION',
T.c.value('(POSTCODE)[1]','nvarchar(12)') AS 'POSTCODE',
T.c.value('(REGIONCODEID)[1]','uniqueidentifier') AS 'REGIONCODEID',
coalesce(T.c.value('(ROWORIGINCODE)[1]','tinyint'), cast(0 as tinyint)) AS 'ROWORIGINCODE',
T.c.value('(SEQUENCE)[1]','int') AS 'SEQUENCE',
T.c.value('(STARTDATE)[1]','char(4)') AS 'STARTDATE',
T.c.value('(STATEHOUSEDISTRICTCODEID)[1]','uniqueidentifier') AS 'STATEHOUSEDISTRICTCODEID',
T.c.value('(STATEID)[1]','uniqueidentifier') AS 'STATEID',
T.c.value('(STATESENATEDISTRICTCODEID)[1]','uniqueidentifier') AS 'STATESENATEDISTRICTCODEID',
T.c.value('(UPDATEHOUSEHOLD)[1]','bit') AS 'UPDATEHOUSEHOLD',
T.c.value('(VALIDATIONMESSAGE)[1]','nvarchar(200)') AS 'VALIDATIONMESSAGE'
FROM @ITEMLISTXML.nodes('/ADDRESSES/ITEM') T(c)
)