How Can I deduct Percentage from amount

Question

Hi I have a situation where given a Column "TotalDue" and a Percentage(17,5%)Could be anything.I need to deduct the percentage and put results in a table

CREATE TABLE #ResultTable (NettAmount money, GrossAmount money)

For example sake lets take AdventureWorks database they have a totalDue Column on

SELECT TotalDue from Sales.SalesOrderHeader

How Can I populate my TemporaryTable?

Answer 1

UPDATE: Further to comment below

You may want to use the INSERT INTO ... SELECT syntax:

INSERT INTO #ResultTable 
            (NettAmount, GrossAmount)
SELECT      (TotalDue * (100 / 117.5)), TotalDue
FROM        Sales.SalesOrderHeader

---

I'm not sure if I correctly understood your table structure, but you may want to try something like the following:

UPDATE  #ResultTable
SET     NettAmount = GrossAmount * (100 / 117.5)

... where if GrossAmount is $117.50, the NettAmount will be set to $100.00.