• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

SQL: Trying to mulitply the rows of an attribute...

C

cw42

Diamond Member
I'm trying to increase all rows of the attribute 'Quota' by 10%. This is what I tried to do, but it dosn't work.

UPDATE SALES
SET Quota = Quota * 1.1;

 
Seems to me that should work. Are you getting some sort of error message? What data type are values of "Quota"?
 
what is the datatype of quota ? only thing I can think of is it needs to be a decimal datatype or something along that lines.

Also you have permissions to do so right ?

you can try a simple select statement to make sure you can multiply that field

Select
Quota as original_quota,
(Quota * 1.1) as new_quota

From table

and see if that gives you an updated field
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top