UFN_PROMOTIONSCHEDULE_GETPROMOTIONSCHEDULEENTRIES

Returns promotion schedule entries linked to a promotion schedule.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PROMOTIONSCHEDULEID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_PROMOTIONSCHEDULE_GETPROMOTIONSCHEDULEENTRIES
            (
                @PROMOTIONSCHEDULEID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    ID,
                    SCHOOLGRADELEVELID,
                    GRADUATES,
                    NEXTSCHOOLGRADELEVELID
                from
                    dbo.PROMOTIONSCHEDULEENTRY
                where
                    PROMOTIONSCHEDULEID = @PROMOTIONSCHEDULEID
            )