UFN_STEP_PROSPECTPLAN

Returns the parent plan for an step.

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@INTERACTIONID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_STEP_PROSPECTPLAN(@INTERACTIONID uniqueidentifier)
            returns uniqueidentifier
            as begin
                return (
                    select PROSPECTPLANID from dbo.INTERACTION where ID=@INTERACTIONID
                )
            end