I recently had to do some work against tax schedules at a client, I needed to quickly see the tax schedules. Here is code to display the tax rate for one tax schedule, and for all of them.
The result will look something like this:
To get one tax schedule, I wrote a function:
-- =============================================
-- Written by 4Penny.net
-- 941-747-3669
-- =============================================
IF EXISTS (SELECT *
FROM sysobjects
WHERE name = N'f_4P_taxAmount')
DROP FUNCTION f_4P_taxAmount
GO
CREATE FUNCTION f_4P_taxAmount ( @taxschid varchar(15))
-- select ngb01.dbo.f_4P_taxAmount('dekalb')
Returns money
AS
begin
declare @out money
set @out = 0
select @out = sum(tx00201.txdtlpct)
from tx00102 with (nolock)
left join tx00201 with (nolock) on tx00201.taxdtlid = tx00102.taxdtlid
where taxschid = @taxschid
return (@out)
end
go
grant all on f_4P_taxAmount to public
Then we can call the function from a query to get all the tax schedules:
select t.taxschid, t.txschdsc, dbo.f_4P_taxAmount(t.taxschid)
from tx00101 t (nolock)
order by t.taxschid