UFN_DISCOUNTTAX_GETTAXES

This function returns a discount's taxes given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@DISCOUNTID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_DISCOUNTTAX_GETTAXES
        (
            @DISCOUNTID uniqueidentifier
        )
            returns table
            as return
                select
                    DISCOUNTTAX.ID,
                    DISCOUNTTAX.TAXID,
                    TAX.NAME
                from
                    dbo.DISCOUNTTAX
                left join
                    dbo.TAX on DISCOUNTTAX.TAXID = TAX.ID
                where
                    DISCOUNTTAX.DISCOUNTID = @DISCOUNTID;