USP_DATALIST_MERCHANDISEPRODUCTINSTANCE

            CREATE procedure dbo.USP_DATALIST_MERCHANDISEPRODUCTINSTANCE
            (
                @CONTEXTID uniqueidentifier,
                @INCLUDEINACTIVE bit = 1
            )
            as
            set nocount on;

            select distinct
                   MPI.ID,
                   MPI.BARCODE,
                   MPI.ONHANDQUANTITY,
                   MPI.ITEMDETAILS,
                   MPI.SALEPRICE,
                   MPI.COST,
                   MPI.MARKUP,
                   MPI.LOOKUPCODE,
                   MPI.ISACTIVE,
                   isnull(cast(cast((100 * (MPI.SALEPRICE-MPI.COST)/nullif(MPI.SALEPRICE,0)) as decimal(5,2)) as nvarchar(8)) +' %','N/A') as MARGIN,
                   MERCHANDISEPRODUCTINSTANCEVENDOR.COST as VENDORCOST
            from dbo.MERCHANDISEPRODUCTINSTANCE MPI
            inner join dbo.MERCHANDISEPRODUCT MP on MP.ID = MPI.MERCHANDISEPRODUCTID
            left outer join dbo.MERCHANDISEPRODUCTINSTANCEOPTIONVALUE MPIOV on MPI.ID = MPIOV.MERCHANDISEPRODUCTINSTANCEID
            left outer join dbo.MERCHANDISEPRODUCTOPTIONVALUE MPOV on MPIOV.MERCHANDISEPRODUCTOPTIONVALUEID = MPOV.ID
            inner join dbo.MERCHANDISEPRODUCTINSTANCEVENDOR on MERCHANDISEPRODUCTINSTANCEVENDOR.MERCHANDISEPRODUCTINSTANCEID = MPI.ID
            where MP.ID = @CONTEXTID
            and (@INCLUDEINACTIVE = 1 or MPI.ISACTIVE = 1)
            order by MPI.BARCODE