UFN_PROSPECTRESEARCHREQUEST_GETSITES

Returns the sites for a prospect research request.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTRESEARCHREQUESTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PROSPECTRESEARCHREQUEST_GETSITES
            (
                @PROSPECTRESEARCHREQUESTID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    ID, SITEID
                from dbo.PROSPECTRESEARCHREQUESTSITE
                where PROSPECTRESEARCHREQUESTID = @PROSPECTRESEARCHREQUESTID
            );