UFN_RESOURCE_GETTAXES

Returns all the taxes assigned to a resource.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@RESOURCEID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_RESOURCE_GETTAXES
            (
                @RESOURCEID uniqueidentifier
            )
            returns table
            as return
                select
                    RESOURCETAX.ID,
                    RESOURCETAX.TAXID,
                    TAX.NAME
                from
                    dbo.RESOURCETAX
                inner join
                    dbo.TAX on RESOURCETAX.TAXID = TAX.ID
                where
                    RESOURCETAX.RESOURCEID = @RESOURCEID
                    and TAX.ISACTIVE = 1;