UFN_CYCLEDAY_GETDAYS

Returns a comma delimited list of days in a cycle.

Return

Return Type
varchar(1000)

Parameters

Parameter	Parameter Type	Mode	Description
@CYCLEID	uniqueidentifier	IN

Definition

Copy



            CREATE FUNCTION dbo.UFN_CYCLEDAY_GETDAYS
            (
                @CYCLEID uniqueidentifier
            )
            RETURNS VARCHAR(1000)
            AS
            BEGIN
                DECLARE @DayList varchar(1000)

                SELECT @DayList = COALESCE(@DayList + '; ', '') + CD.DAY
                FROM DBO.CYCLEDAY CD
                WHERE CD.CYCLEID = @CYCLEID
                ORDER BY SEQUENCE ASC
                RETURN @DayList
            END