USP_DATALIST_DISCOUNTGROUPDETAILQUALIFIEDMERCHANDISEITEM

Returns a list of merchandise items that trigger a discount.

Parameters

Parameter	Parameter Type	Mode	Description
@DISCOUNTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_DISCOUNTGROUPDETAILQUALIFIEDMERCHANDISEITEM(@DISCOUNTID uniqueidentifier)
as
    set nocount on;

    select 
        DISCOUNTGROUPDETAILMERCHANDISEITEM.ID,
        PRODUCT.NAME         
    from dbo.MERCHANDISEPRODUCT
    inner join dbo.PRODUCT
        on MERCHANDISEPRODUCT.ID = PRODUCT.ID
    inner join dbo.DISCOUNTGROUPDETAILMERCHANDISEITEM
        on DISCOUNTGROUPDETAILMERCHANDISEITEM.MERCHANDISEITEMID = MERCHANDISEPRODUCT.ID
    inner join dbo.DISCOUNTGROUPDETAIL
        on DISCOUNTGROUPDETAILMERCHANDISEITEM.ID = DISCOUNTGROUPDETAIL.ID
    inner join dbo.DISCOUNTGROUP
        on DISCOUNTGROUP.ID = DISCOUNTGROUPDETAIL.DISCOUNTGROUPID
    where DISCOUNTGROUP.DISCOUNTID = @DISCOUNTID
        and DISCOUNTGROUPDETAIL.DISCOUNTEDITEM = 0