UFN_DISCOUNT_GETDISCOUNTEDPROGRAMS

This function returns a discount's programs.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@DISCOUNTID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_DISCOUNT_GETDISCOUNTEDPROGRAMS
    (
      @DISCOUNTID uniqueidentifier
    )
        returns table
        as return
            select                
                DISCOUNTGROUPDETAIL.DISCOUNTGROUPID,
                DISCOUNTGROUPDETAIL.ID,
                DISCOUNTGROUPDETAILPROGRAM.PROGRAMID
            from
                dbo.DISCOUNTGROUP
            inner join
                dbo.DISCOUNTGROUPDETAIL
            on DISCOUNTGROUP.ID = DISCOUNTGROUPDETAIL.DISCOUNTGROUPID
            inner join
                dbo.DISCOUNTGROUPDETAILPROGRAM
            on DISCOUNTGROUPDETAIL.ID = DISCOUNTGROUPDETAILPROGRAM.ID
            where
                DISCOUNTGROUP.DISCOUNTID=@DISCOUNTID;