UFN_STAFFRESOURCE_GETTAXES

Returns all the taxes assigned to a staffing resource.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@VOLUNTEERTYPEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_STAFFRESOURCE_GETTAXES
            (
                @VOLUNTEERTYPEID uniqueidentifier
            )
            returns table
            as return
                select
                    VOLUNTEERTYPETAX.ID,
                    VOLUNTEERTYPETAX.TAXID,
                    TAX.NAME
                from
                    dbo.VOLUNTEERTYPETAX
                inner join
                    dbo.TAX on VOLUNTEERTYPETAX.TAXID = TAX.ID
                where
                    VOLUNTEERTYPETAX.VOLUNTEERTYPEID = @VOLUNTEERTYPEID
                    and TAX.ISACTIVE = 1;