UFN_STEWARDSHIPPLAN_GETSITELIST

Returns a comma delimited list of sites associated with the given stewardship plan.

Return

Return Type
nvarchar(1024)

Parameters

Parameter	Parameter Type	Mode	Description
@STEWARDSHIPPLANID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_STEWARDSHIPPLAN_GETSITELIST(
                @STEWARDSHIPPLANID 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_STEWARDSHIPPLAN_GETSITES(@STEWARDSHIPPLANID) PLANSITE
                    inner join dbo.SITE on SITE.ID = PLANSITE.SITEID
                    order by SITE.NAME) ORDEREDSITES;

                return @SITES;            
            end