|
Stored Procedure to calculate Tax From Gross
Home :: SQL Server :: Tax From Gross
Here is a SQL server stored procedure that you can use to
calculate Tax figure from tax rate and Gross amounts. It can equally be used to calculate
any figure you want a percentage from. Use it in SQL server views to create a new, calculated column.
It matches up nicely with the three simple javascript functions you can use on active server pages to
calculate tax, gross, and Nett figures. The difference being that this stored procedure runs at SQL server, thus
removing the load from your web server.
Or why not do it client-side in the browser using this
javascript version?
CREATE FUNCTION TaxFromGross(@Gross
money, @TaxRate smallint)
The rest of this page is hidden, you must be a member to view itTo become a member and get immediate access to the course please join here Free!
Next >> Nett From Gross
|
|