UFN_BBIS_GETPHONEIDFORCONSTITUENT
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITID | uniqueidentifier | IN | |
| @PHONETYPECODEID | uniqueidentifier | IN | |
| @NUMBER | nvarchar(100) | IN |
Definition
Copy
CREATE function dbo.UFN_BBIS_GETPHONEIDFORCONSTITUENT(
@CONSTITID uniqueidentifier,
@PHONETYPECODEID uniqueidentifier,
@NUMBER as nvarchar(100)
)
returns uniqueidentifier
with execute as caller
as begin
return (
select top 1 ID
from dbo.PHONE
where
CONSTITUENTID = @CONSTITID and
isnull(PHONETYPECODEID,'00000000-0000-0000-0000-000000000000') = isnull(@PHONETYPECODEID,'00000000-0000-0000-0000-000000000000') and
NUMBERNOFORMAT = @NUMBER
)
end