Stored Procedure to calculate Gross From Nett

Home :: SQL Server :: Gross From Nett

Here is a SQL server stored procedure that you can use to calculate gross figures from tax rate and Nett 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?