UFN_MERCHANDISE_GETPRODUCTLABELSTOPRINT

CREATE function dbo.UFN_MERCHANDISE_GETPRODUCTLABELSTOPRINT
(
    @MERCHANDISEPRODUCTID uniqueidentifier
)
returns table as
  return
    select
        MERCHANDISEPRODUCTINSTANCE.ID,
        MERCHANDISEPRODUCTINSTANCE.ITEMDETAILS,
        MERCHANDISEPRODUCTINSTANCE.BARCODE,
        MERCHANDISEPRODUCTINSTANCE.ONHANDQUANTITY,
        MERCHANDISEPRODUCTINSTANCE.SALEPRICE,
        0 QUANTITYTOPRINT
    from
        dbo.MERCHANDISEPRODUCTINSTANCE
    where
        MERCHANDISEPRODUCTINSTANCE.MERCHANDISEPRODUCTID = @MERCHANDISEPRODUCTID 
        --and MERCHANDISEPRODUCTINSTANCE.ISACTIVE = 1