USP_SIMPLEDATALIST_PROMOTIONSCHEDULE

Returns a list of promotion schedules

Parameters

Parameter	Parameter Type	Mode	Description
@SCHOOLID	uniqueidentifier	IN	School

Definition

Copy



            create procedure dbo.USP_SIMPLEDATALIST_PROMOTIONSCHEDULE
                (
                    @SCHOOLID uniqueidentifier = null
                ) as
                    select 
                        ID as VALUE, 
                        NAME as LABEL
                    from dbo.PROMOTIONSCHEDULE
                    where (SCHOOLID = @SCHOOLID)
                    order by NAME