UFN_RESEARCHGROUP_NUMRE7LINKEDMEMBERS
Return
| Return Type |
|---|
| int |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_RESEARCHGROUP_NUMRE7LINKEDMEMBERS(@ID uniqueidentifier)
returns Integer
with execute as caller
as begin
return
(select count(RE7INTEGRATIONCONSTITUENTMAP.ID) from RESEARCHGROUPMEMBER
left join RE7INTEGRATIONCONSTITUENTMAP on RE7INTEGRATIONCONSTITUENTMAP.ID = RESEARCHGROUPMEMBER.CONSTITUENTID
where RESEARCHGROUPMEMBER.RESEARCHGROUPID = @ID
)
end