UFN_PROSPECTFUNDINGINTEREST_GETSITELIST

Returns all sites for a given prospect funding interest.

Return

Return Type
nvarchar(1024)

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTFUNDINGINTERESTID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_PROSPECTFUNDINGINTEREST_GETSITELIST(@PROSPECTFUNDINGINTERESTID uniqueidentifier)
returns nvarchar(1024)
as

begin
    declare @SITES nvarchar(1024) = 
                    (
                        select 
                            dbo.UDA_BUILDLIST(SITE.NAME)
                        from 
                            dbo.UFN_PROSPECTFUNDINGINTEREST_GETSITES(@PROSPECTFUNDINGINTERESTID) PROSPECTFUNDINGINTERESTSITE
                        inner join 
                            dbo.SITE 
                        on 
                            SITE.ID = PROSPECTFUNDINGINTERESTSITE.SITEID
                    );

                return @SITES;            
            end