UFN_PROSPECTRESEARCHREQUESTCONSTITUENT_GETSOURCES
Returns all sources used in a given prospect research request constituent.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PROSPECTRESEARCHREQUESTCONSTITUENTID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_PROSPECTRESEARCHREQUESTCONSTITUENT_GETSOURCES(@PROSPECTRESEARCHREQUESTCONSTITUENTID uniqueidentifier)
returns table
as
return
(
select
ID,
PROSPECTRESEARCHREQUESTSOURCECODEID,
nullif(TIME, -1) as TIME,
nullif(USES, -1) as USES,
nullif(COST, -1) as COST
from dbo.PROSPECTRESEARCHREQUESTSOURCE where PROSPECTRESEARCHREQUESTCONSTITUENTID = @PROSPECTRESEARCHREQUESTCONSTITUENTID
)