[djspang]

Hi - currently training on SQL - doing alright so far until this sub-question...

Migrate all data from the JOB_COST table into the TOTAL_COST table. For those records that match the COST_ID, update the UPPER_LEVEL and increase the cost by 15%, otherwise insert the records.

...I've looked everywhere online but have no luck. How do I increase a cost by a percentage? Please?

[Atli]

Hi.

Basic math... you multiply by 1.15 ;)

Expand|Select|Wrap|Line Numbers

1. SELECT numericField * 1.15
2.  

Should return the values of that field + 15%;

If you are getting any rounding issues (which you shouldn't), you can CAST it to Decimal

Expand|Select|Wrap|Line Numbers

1. SELECT CAST(numericField AS Decimal) * 1.15
2.  

[djspang]

Originally Posted by Atli

Hi.

Basic math... you multiply by 1.15 ;)

Expand|Select|Wrap|Line Numbers

1. SELECT numericField * 1.15
2.  

Should return the values of that field + 15%;

If you are getting any rounding issues (which you shouldn't), you can CAST it to Decimal

Expand|Select|Wrap|Line Numbers

1. SELECT CAST(numericField AS Decimal) * 1.15
2.  

Duh! :-) There was me expecting something long and complicated!

Thanks Atli - much appreciated!