|
Stored Procedure to calculate Nett From Gross
Home :: SQL Server :: Nett From Gross
Here is a SQL server stored procedure that you can use to
calculate Nett figures 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 NettFromGross(@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 >> Gross From Nett
|
|