USP_DATALIST_PROMOTIONSCHEDULE

Shows all of the promotion schedules within the system..

Definition

Copy 


            CREATE procedure dbo.USP_DATALIST_PROMOTIONSCHEDULE
            as
                set nocount on;

                select    dbo.PROMOTIONSCHEDULE.ID,
                        dbo.PROMOTIONSCHEDULE.SCHOOLID,
                        dbo.PROMOTIONSCHEDULE.NAME,
                        dbo.CONSTITUENT.KEYNAME,
                        dbo.PROMOTIONSCHEDULE.DESCRIPTION
                from dbo.PROMOTIONSCHEDULE
                join dbo.SCHOOL on SCHOOL.ID = PROMOTIONSCHEDULE.SCHOOLID
                join dbo.CONSTITUENT on CONSTITUENT.ID = SCHOOL.ID