UFN_PROSPECTFUNDINGINTEREST_GETSITES
Returns a table of sites for the prospect funding interest.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PROSPECTFUNDINGINTERESTID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_PROSPECTFUNDINGINTEREST_GETSITES(@PROSPECTFUNDINGINTERESTID uniqueidentifier)
returns table
as return
select ID,
SITEID
from dbo.PROSPECTFUNDINGINTERESTSITE
where PROSPECTFUNDINGINTERESTID = @PROSPECTFUNDINGINTERESTID;