UFN_STEWARDSHIPPLANSTEP_GETSITELIST

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

Return

Return Type
nvarchar(1024)

Parameters

Parameter	Parameter Type	Mode	Description
@STEWARDSHIPPLANSTEPID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_STEWARDSHIPPLANSTEP_GETSITELIST(
                @STEWARDSHIPPLANSTEPID uniqueidentifier
            )
            returns nvarchar(1024)
            as
            begin
                declare @SITES nvarchar(1024) = 
                (
                  select 
                    dbo.UFN_STEWARDSHIPPLAN_GETSITELIST(STEWARDSHIPPLANSTEP.PLANID)
                  from dbo.STEWARDSHIPPLANSTEP
                  where STEWARDSHIPPLANSTEP.ID = @STEWARDSHIPPLANSTEPID
                );

                return @SITES;            
            end