UFN_BBIS_CONSTITUENTLOOKUPIDEXISTS
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @LOOKUPID | nvarchar(100) | IN |
Definition
Copy
create function dbo.UFN_BBIS_CONSTITUENTLOOKUPIDEXISTS(@LOOKUPID nvarchar(100))
returns bit
with execute as caller
as begin
return
(select
case when (count(*)) > 0 then 1 else 0 end
from
dbo.CONSTITUENT
where
LOOKUPID = @LOOKUPID);
end