USP_DATALIST_DISCOUNTGROUPDETAILQUALIFIEDMERCHANDISEDEPARTMENT

Returns a list of merchandise departments that can 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_DISCOUNTGROUPDETAILQUALIFIEDMERCHANDISEDEPARTMENT(@DISCOUNTID uniqueidentifier)
as
    set nocount on;

    select 
        DISCOUNTGROUPDETAILMERCHANDISEDEPARTMENT.ID,
        MERCHANDISEDEPARTMENT.NAME         
    from dbo.MERCHANDISEDEPARTMENT
    inner join dbo.DISCOUNTGROUPDETAILMERCHANDISEDEPARTMENT
        on DISCOUNTGROUPDETAILMERCHANDISEDEPARTMENT.MERCHANDISEDEPARTMENTID = MERCHANDISEDEPARTMENT.ID
    inner join dbo.DISCOUNTGROUPDETAIL
        on DISCOUNTGROUPDETAILMERCHANDISEDEPARTMENT.ID = DISCOUNTGROUPDETAIL.ID
    inner join dbo.DISCOUNTGROUP
        on DISCOUNTGROUP.ID = DISCOUNTGROUPDETAIL.DISCOUNTGROUPID
    where DISCOUNTGROUP.DISCOUNTID = @DISCOUNTID
        and DISCOUNTGROUPDETAIL.DISCOUNTEDITEM = 0