UFN_BBNC_CONSTITUENTHASSPOUSE
Returns true if the specified constituent has a spouse for Blackbaud Internet Solutions.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITUENTID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_BBNC_CONSTITUENTHASSPOUSE
(
@CONSTITUENTID uniqueidentifier
)
returns bit
as
begin
return
(
select
case
when exists
(
select
1
from
dbo.RELATIONSHIP
where
RELATIONSHIP.RELATIONSHIPCONSTITUENTID = @CONSTITUENTID
and RELATIONSHIP.ISSPOUSE = 1
)
then
1
else
0
end
)
end