USP_DATALIST_TAXPROGRAM

Lists the programs associated with a tax.

Parameters

Parameter	Parameter Type	Mode	Description
@TAXID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                create procedure dbo.USP_DATALIST_TAXPROGRAM
                (
                    @TAXID uniqueidentifier
                )
                as
                set nocount on;
                select 
                    PROGRAM.ID,
                    PROGRAMTAX.ID AS PROGRAMTAXID,
                    PROGRAM.NAME,
                    PROGRAM.ISACTIVE,
                    PROGRAM.DESCRIPTION
                from dbo.PROGRAM
                inner join dbo.PROGRAMTAX on PROGRAM.ID=PROGRAMTAX.PROGRAMID 
                    where PROGRAMTAX.TAXID= @TAXID
                order by NAME;