UFN_SPONSORSHIPOPPORTUNITYDIMENSIONLIST_FROMITEMLISTXML
Returns a list of sponsorship opportunity dimensions for use with sponsorship opportunity smart fields.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DIMENSIONLIST | xml | IN |
Definition
Copy
create function dbo.UFN_SPONSORSHIPOPPORTUNITYDIMENSIONLIST_FROMITEMLISTXML(
@DIMENSIONLIST xml
)
returns table
as
return (
select
T.c.value('(FIELDID)[1]','nvarchar(50)') AS 'FIELDID'
from @DIMENSIONLIST.nodes('/DIMENSIONLIST/ITEM') T(c)
)