UFN_CYCLEDAY_GETCYCLEDAY

Returns the cycledays in a cycle.

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@CYCLEID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_CYCLEDAY_GETCYCLEDAY( @CYCLEID uniqueidentifier )
returns table
as return(

    select 
        ID,
        DAY,
        DESCRIPTION,
        CODE,
        SEQUENCE,
        COLORSTYLECODE
    from 
        dbo.CYCLEDAY
    where 
        CYCLEID = @CYCLEID

    )