UFN_PROMOTIONSCHEDULE_GETSCHOOLID

Returns the SchoolID for a given PromotionScheduleID

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@PROMOTIONSCHEDULEID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_PROMOTIONSCHEDULE_GETSCHOOLID
        (
            @PROMOTIONSCHEDULEID uniqueidentifier
        )
        returns uniqueidentifier
        as begin
            declare @RETVAL uniqueidentifier;

            SELECT @RETVAL = dbo.PROMOTIONSCHEDULE.[SCHOOLID]
            FROM dbo.PROMOTIONSCHEDULE
            WHERE dbo.PROMOTIONSCHEDULE.[ID] = @PROMOTIONSCHEDULEID

            return @RETVAL;
        end