November 11, 2010 at 4:38 pm
I am trying to write a query to increase a field of money type by 10%, any suggestions will be apreciated.
Increase all employees salaries with the selected EEO- Classification by 10%
Is Salary + (Salary * .10) correct ?
It give me the correct results except with 4 decimal places instead of 2.
November 11, 2010 at 4:49 pm
It is correct, but Money is a field of four decimal places. It's working as expected.
Wrap the result with a CONVERT( DECIMAL (19,2), <function here>) to go to two decimals.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 11, 2010 at 5:10 pm
Thank you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply