UFN_BATCHCONSTITUENTUPDATE_GETADDRESSES_WITHDATES_TOITEMLISTXML

Used to convert the results of UFN_BATCHCONSTITUENTUPDATE_GETADDRESSES_WITHDATES to xml.

Return

Return Type
xml

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHCONSTITUENTUPDATEID	uniqueidentifier	IN

Definition

Copy



CREATE FUNCTION dbo.[UFN_BATCHCONSTITUENTUPDATE_GETADDRESSES_WITHDATES_TOITEMLISTXML](
@BATCHCONSTITUENTUPDATEID uniqueidentifier
    )
returns xml
as
BEGIN

RETURN (
 SELECT 
  [ADDRESSBLOCK],
  [ADDRESSID],
  [ADDRESSTYPECODEID],
  [CART],
  [CERTIFICATIONDATA],
  [CITY],
  [CONGRESSIONALDISTRICTCODEID],
  [COUNTRYID],
  [COUNTYCODEID],
  [DONOTMAIL],
  [DONOTMAILREASONCODEID],
  [DPC],
  [ENDDATE],
  [HISTORICALENDDATE],
  [HISTORICALSTARTDATE],
  [ID],
  [INFOSOURCECODEID],
  [INFOSOURCECOMMENTS],
  [ISPRIMARY],
  [LASTVALIDATIONATTEMPTDATE],
  [LOCALPRECINCTCODEID],
  [LOT],
  [OMITFROMVALIDATION],
  [POSTCODE],
  [REGIONCODEID],
  [ROWORIGINCODE],
  [SEQUENCE],
  [STARTDATE],
  [STATEHOUSEDISTRICTCODEID],
  [STATEID],
  [STATESENATEDISTRICTCODEID],
  [UPDATEHOUSEHOLD],
  [VALIDATIONMESSAGE]
 FROM dbo.[UFN_BATCHCONSTITUENTUPDATE_GETADDRESSES_WITHDATES](@BATCHCONSTITUENTUPDATEID)
 for xml path('ITEM'),type,elements,root('ADDRESSES'),BINARY BASE64

)

END