UFN_MEMBER_VALIDISPRIMARYCOUNT
Validates the number of primary members in a membership.
Return
| Return Type |
|---|
| tinyint |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MEMBERSHIPID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_MEMBER_VALIDISPRIMARYCOUNT
(
@MEMBERSHIPID uniqueidentifier
)
returns tinyint
with execute as caller
as begin
return
(
select count(ID)
from dbo.MEMBER
where MEMBERSHIPID = @MEMBERSHIPID
and ISPRIMARY = 1
and ISDROPPED = 0
)
end