USP_DATALIST_SALESORDER_DONATIONS2

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

    select
        SALESORDERITEM.ID,
        SALESORDERITEM.DESCRIPTION,
        SALESORDERITEM.PRICE,
        SALESORDERITEM.QUANTITY,
        SALESORDERITEM.TOTAL,
        SALESORDERITEM.TYPECODE,
        SALESORDERITEMDONATION.REVENUESPLITID,
        SALESORDERITEMDONATION.ECARDSDATA
    from
        dbo.SALESORDERITEM
    inner join
        dbo.SALESORDERITEMDONATION on SALESORDERITEM.ID = SALESORDERITEMDONATION.ID
    where
        SALESORDERITEM.SALESORDERID = @CONTEXTID;

    return 0;