USP_SIMPLEDATALIST_MERCHANDISEPRODUCTINSTANCEOPTIONVALUE

Lists the option values for a merchandise item option.

Parameters

Parameter	Parameter Type	Mode	Description
@MERCHANDISEPRODUCTOPTIONID	uniqueidentifier	IN	Merchandise item option

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_MERCHANDISEPRODUCTINSTANCEOPTIONVALUE (@MERCHANDISEPRODUCTOPTIONID as uniqueidentifier) as
    select 
        ID as VALUE, 
        NAME as LABEL
    from dbo.MERCHANDISEPRODUCTOPTIONVALUE
  where
    MERCHANDISEPRODUCTOPTIONVALUE.MERCHANDISEPRODUCTOPTIONID = @MERCHANDISEPRODUCTOPTIONID
    order by NAME