USP_SIMPLEDATALIST_MERCHANDISEPRODUCTINSTANCE

CREATE procedure dbo.USP_SIMPLEDATALIST_MERCHANDISEPRODUCTINSTANCE
(
    @MERCHANDISEPRODUCTID uniqueidentifier
) as
    select 
        ID as VALUE, 
        dbo.UFN_MERCHANDISEPRODUCTINSTANCE_BUILDDESCRIPTION_2(MERCHANDISEPRODUCTINSTANCE.ID, 0) as LABEL
    from dbo.MERCHANDISEPRODUCTINSTANCE
    where MERCHANDISEPRODUCTID = @MERCHANDISEPRODUCTID
    order by LABEL