UFN_STEWARDSHIPPLANTEMPLATE_GETSITELIST

Returns a semi-colon delimited list of sites associated with the given stewardship plan.

Return

Return Type
nvarchar(1024)

Parameters

Parameter	Parameter Type	Mode	Description
@STEWARDSHIPPLANTEMPLATEID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_STEWARDSHIPPLANTEMPLATE_GETSITELIST
(
    @STEWARDSHIPPLANTEMPLATEID uniqueidentifier
)
returns nvarchar(1024)
as
begin
    declare @SITES nvarchar(1024);
    select 
        @SITES = dbo.UDA_BUILDLIST(NAME) 
    from 
        (select top 1000 SITE.NAME 
        from dbo.UFN_STEWARDSHIPPLANTEMPLATE_GETSITES(@STEWARDSHIPPLANTEMPLATEID) TEMPLATESITE
        inner join dbo.SITE on SITE.ID = TEMPLATESITE.SITEID
        order by SITE.NAME) ORDEREDSITES;

    return @SITES;            
end