UFN_INTERACTION_ISPLANSTEP
Returns true if the given interaction is linked to a prospect plan.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @INTERACTIONID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_INTERACTION_ISPLANSTEP(
@INTERACTIONID uniqueidentifier
)
returns bit
as
begin
declare @ISSTEP bit;
select
@ISSTEP =
case
when PROSPECTPLANID is null then 0
else 1
end
from dbo.INTERACTION
where ID = @INTERACTIONID;
return @ISSTEP;
end