USP_DATALIST_STAFFRESOURCETAX

Lists taxes assigned to a staffing resource.

Parameters

Parameter	Parameter Type	Mode	Description
@VOLUNTEERTYPEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@INCLUDEINACTIVE	bit	IN	Include inactive

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_STAFFRESOURCETAX
                (
                    @VOLUNTEERTYPEID uniqueidentifier,
                    @INCLUDEINACTIVE bit = 0
                )
                as
                    set nocount on;

                    select
                        VOLUNTEERTYPETAX.ID,
                        TAX.NAME,
                        TAX.TOTALTAX,
                        TAX.ISACTIVE,
                        TAX.[DESCRIPTION],
                        VOLUNTEERTYPETAX.TAXID
                    from
                        dbo.VOLUNTEERTYPETAX
                    inner join
                        dbo.TAX on VOLUNTEERTYPETAX.TAXID = TAX.ID
                    where
                        VOLUNTEERTYPETAX.VOLUNTEERTYPEID = @VOLUNTEERTYPEID
                        and (@INCLUDEINACTIVE = 1 or TAX.ISACTIVE = 1)
                    order by
                        TAX.NAME;

                    return 0;