UFN_CONSTITUENT_ADDRESSES_TOITEMLISTXML

Return

Return Type
xml

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN
@INCLUDEFORMER	bit	IN

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  11/11/2014 4:11:24 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_CONSTITUENT_ADDRESSES
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_CONSTITUENT_ADDRESSES_TOITEMLISTXML](
@CONSTITUENTID uniqueidentifier
, @INCLUDEFORMER bit
    )
returns xml
as
BEGIN

RETURN (
 SELECT 
  [ADDRESSTYPE],
  [DATEADDED],
  [DESCRIPTION],
  [DONOTMAIL],
  [ENDDATE_SORT],
  [HISTORICALENDDATE],
  [HISTORICALSTARTDATE],
  [ID],
  [IMAGEKEY],
  [INVALIDGEOCODE],
  [ISCONFIDENTIAL],
  [ISFORMER],
  [ISGEOCODED],
  [ISPRIMARY],
  [MAPCONTEXTID],
  [PENDINGGEOCODE],
  [SEASONALENDDATE],
  [SEASONALSTARTDATE],
  [STARTDATE_SORT]
 FROM dbo.[UFN_CONSTITUENT_ADDRESSES](@CONSTITUENTID, @INCLUDEFORMER)
 order by ISPRIMARY desc, ISFORMER asc, ENDDATE_SORT desc, STARTDATE_SORT desc, DATEADDED desc
 for xml path('ITEM'),type,elements,root('ADDRESSES'),BINARY BASE64

)

END