UFN_CONSTITUENTIDS_GETRE7IDS
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @IDS | xml | IN |
Definition
Copy
CREATE function dbo.UFN_CONSTITUENTIDS_GETRE7IDS(@IDS xml) returns table
as
return select cmap.ID, cmap.RE7RECORDID
from dbo.RE7INTEGRATIONCONSTITUENTMAP cmap
inner join @IDS.nodes('/CONSTITUENTS/ITEM') T(c) on T.c.value('(@ID)[1]','uniqueidentifier') = cmap.ID