UFN_MERCHANDISE_GETNEWPRODUCTINSTANCEOPTIONS_2

create function dbo.UFN_MERCHANDISE_GETNEWPRODUCTINSTANCEOPTIONS_2(@MERCHANDISEPRODUCTID uniqueidentifier)
returns table as
    return
        select
            MERCHANDISEPRODUCTOPTION.NAME OPTIONNAME,
            MERCHANDISEPRODUCTOPTION.ID OPTIONID,
            MERCHANDISEPRODUCTOPTION.SEQUENCE as OPTIONSEQUENCE
        from
            dbo.MERCHANDISEPRODUCTOPTION
        where
            MERCHANDISEPRODUCTOPTION.MERCHANDISEPRODUCTID = @MERCHANDISEPRODUCTID