UFN_CONSTITUENTBATCH_GETPHONESWITHSEASONAL_TOITEMLISTXML
Used to convert the results of UFN_CONSTITUENTBATCH_GETPHONESWITHSEASONAL to xml.
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHCONSTITUENTID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_CONSTITUENTBATCH_GETPHONESWITHSEASONAL_TOITEMLISTXML
(
@BATCHCONSTITUENTID uniqueidentifier
)
returns xml
as
begin
return
(
select
[COUNTRYID],
[ENDTIME],
[ID],
[ISPRIMARY],
[NUMBER],
[PHONETYPECODEID],
[SEASONALENDDATE],
[SEASONALSTARTDATE],
[SEQUENCE],
[STARTDATE],
[STARTTIME],
[INFOSOURCECODEID],
[INFOSOURCECOMMENTS]
from
dbo.[UFN_CONSTITUENTBATCH_GETPHONESWITHSEASONAL](@BATCHCONSTITUENTID)
for
xml path('ITEM'),type,elements,root('PHONES'),BINARY BASE64
)
end