USP_DATALIST_MERCHANDISEBYTAX

                CREATE procedure dbo.USP_DATALIST_MERCHANDISEBYTAX
                (
                    @TAXID uniqueidentifier
                )
                as
                set nocount on;
                select 
                    MERCHANDISEPRODUCT.ID as MERCHANDISEPRODUCTID,
                    PRODUCT.NAME,
                    MERCHANDISEPRODUCT.ISACTIVE,
                    PRODUCT.DESCRIPTION
                from dbo.MERCHANDISEPRODUCT
                inner join dbo.PRODUCT on PRODUCT.ID = MERCHANDISEPRODUCT.ID
                where MERCHANDISEPRODUCT.TAXID= @TAXID
                order by NAME;