UFN_SMARTFIELDVALUEGROUP_GETGROUPS_2_SETITEMLISTXMLDEFAULTVALUES
Returns the ID of a state given it's description.
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @XML | xml | IN |
Definition
Copy
CREATE function dbo.UFN_SMARTFIELDVALUEGROUP_GETGROUPS_2_SETITEMLISTXMLDEFAULTVALUES
(
@XML xml
)
returns xml
with execute as caller
as begin
return (
select
[GROUPNAME],
[ID],
[INTEGERVALUERANGE],
[MONEYVALUERANGE],
coalesce([DATEVALUERANGE], 0) [DATEVALUERANGE]
from
dbo.[UFN_SMARTFIELDVALUEGROUP_GETGROUPS_2_FROMITEMLISTXML](@XML)
order by
MONEYVALUERANGE, INTEGERVALUERANGE, DATEVALUERANGE
for xml raw('ITEM'),type,elements,root('SMARTFIELDVALUEGROUPS'),BINARY BASE64
);
end