USP_DATALIST_SALESORDERMERCHANDISE2

create procedure dbo.USP_DATALIST_SALESORDERMERCHANDISE2
(
    @CONTEXTID uniqueidentifier
)
as
    set nocount on;

    -- Non-refunded merchandise

    select
        SALESORDERITEM.ID,
        SALESORDERITEM.[DESCRIPTION],
        MERCHANDISEPRODUCTINSTANCE.BARCODE,
        SALESORDERITEM.QUANTITY,
        SALESORDERITEM.PRICE,
        coalesce(sum(SALESORDERITEMITEMDISCOUNT.AMOUNT),0.0) as DISCOUNTS,
        SALESORDERITEM.TOTAL - coalesce(sum(SALESORDERITEMITEMDISCOUNT.AMOUNT),0.0) as TOTAL,
        SALESORDERITEM.TYPECODE
    from dbo.SALESORDERITEM
    inner join dbo.SALESORDERITEMMERCHANDISE on SALESORDERITEM.ID = SALESORDERITEMMERCHANDISE.ID
    inner join dbo.MERCHANDISEPRODUCTINSTANCE on SALESORDERITEMMERCHANDISE.MERCHANDISEPRODUCTINSTANCEID = MERCHANDISEPRODUCTINSTANCE.ID
    left join dbo.SALESORDERITEMITEMDISCOUNT on SALESORDERITEMITEMDISCOUNT.SALESORDERITEMID = SALESORDERITEM.ID
    where SALESORDERITEM.SALESORDERID = @CONTEXTID
    group by 
        SALESORDERITEM.ID,
        SALESORDERITEM.[DESCRIPTION],
        MERCHANDISEPRODUCTINSTANCE.BARCODE,
        SALESORDERITEM.QUANTITY,
        SALESORDERITEM.PRICE,
        SALESORDERITEM.TOTAL,
        SALESORDERITEM.TYPECODE;

    return 0;