UFN_PROGRAMTAX_GETTAX

This function returns a program's tax given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PROGRAMID	uniqueidentifier	IN

Definition

Copy



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