UFN_STEWARDSHIPPLAN_TOP5STEWARDS_TOITEMLISTXML

Returns the top 5 stewards for a stewardship plan in alphabetical order.

Return

Return Type
xml

Parameters

Parameter Parameter Type Mode Description
@PLANID uniqueidentifier IN
@VIEWINACTIVE bit IN

Definition

Copy


CREATE function dbo.UFN_STEWARDSHIPPLAN_TOP5STEWARDS_TOITEMLISTXML
(
    @PLANID uniqueidentifier,
    @VIEWINACTIVE bit = 0
)
returns xml
as begin
    return dbo.UFN_STEWARDSHIPPLAN_TOPNSTEWARDS_TOITEMLISTXML(@PLANID, @VIEWINACTIVE, 5);
end