UFN_SCREENPLAN_GETSTEPS

Returns all steps for a given screen plan.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@SCREENPLANID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SCREENPLAN_GETSTEPS(@SCREENPLANID uniqueidentifier)
            returns table
            as
            return
            (
                select ID, SEQUENCE, STEPCODEID, DAYSTOCOMPLETE from dbo.SCREENPLANSTEP where SCREENPLANID = @SCREENPLANID
            )