UFN_PHONE_NEEDSATTENTION
Return
Return Type |
---|
bit |
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@ID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_PHONE_NEEDSATTENTION(@ID uniqueidentifier) returns bit with execute as caller
as
begin
declare @RETVAL bit = 0;
select @RETVAL =
case when DONOTCALL = 1 or ISCONFIDENTIAL = 1 then 1
else 0 end
from dbo.PHONE where ID = @ID
return @RETVAL
end