UFN_BENEFIT_GETBENEFITOPTIONS_TOITEMLISTXML
return benefit options of a given benefit in xml format
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BENEFITID | uniqueidentifier | IN |
Definition
Copy
CREATE FUNCTION dbo.UFN_BENEFIT_GETBENEFITOPTIONS_TOITEMLISTXML(
@BENEFITID uniqueidentifier
)
returns xml
as
BEGIN
RETURN (
SELECT [BENEFITOPTIONID], [NAME], [DETAILS], [ID]
FROM dbo.UFN_BENEFIT_GETBENEFITOPTIONS(@BENEFITID)
for xml raw('ITEM'),type,elements,root('BENEFITOPTIONS'),BINARY BASE64
)
END