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