UFN_CONSTITUENT_GETADDRESSES_FORUPDATEBATCH_TOITEMLISTXML

Used to convert the results of UFN_CONSTITUENT_GETADDRESSES_FORUPDATEBATCH to xml.

Return

Return Type
xml

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  3/19/2013 1:17:28 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_CONSTITUENT_GETADDRESSES_FORUPDATEBATCH
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_CONSTITUENT_GETADDRESSES_FORUPDATEBATCH_TOITEMLISTXML](
@CONSTITUENTID uniqueidentifier
    )
returns xml
as
BEGIN

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

)

END