UFN_STEWARDSHIPPLAN_TOP4STEWARDS_TOITEMLISTXML

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

Return

Return Type
xml

Parameters

Parameter Parameter Type Mode Description
@PLANID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_STEWARDSHIPPLAN_TOP4STEWARDS_TOITEMLISTXML
(
    @PLANID uniqueidentifier

returns xml
as begin
    return dbo.UFN_STEWARDSHIPPLAN_TOPNSTEWARDS_TOITEMLISTXML(@PLANID, 1, 4);
end