<div>
Msg 156, Level 15, State 1, Line 1<br />
Incorrect syntax near the keyword 'VALUES'.
</div>


Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'VALUES'.

<div>
If you're on MS SQL 2008 or higher, that works. Check your syntax. You must have parentheses like my example.<br />
<br />
I just tested it with a temp table.
</div>


If you're on MS SQL 2008 or higher, that works. Check your syntax. You must have parentheses like my example.

I just tested it with a temp table.

<div>
Sorry the server is sql2000...
</div>


<div>
<div class="content wysiwyg-content">
Hi..<br />
I need to update a table &nbsp; I have a field called &nbsp;HIGHEST_OF_3<br />
and 3 sales fields, &nbsp;SALE_1, SALE_2, SALE_3<br />
I need to update the value of the HIGHEST_OF_3 with the largest value of SALES_1, or SALES_2 or SALES_3.<br />
<br />
table looks something like this <br />
<br />
customer id &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sale 1 &nbsp; &nbsp; &nbsp; &nbsp; sale 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sale 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;highest<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 40 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;90<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30<br />
<br />
<br />
thx
</div>
</div>


Hi..
I need to update a table   I have a field called  HIGHEST_OF_3
and 3 sales fields,  SALE_1, SALE_2, SALE_3
I need to update the value of the HIGHEST_OF_3 with the largest value of SALES_1, or SALES_2 or SALES_3.

table looks something like this 

customer id             sale 1         sale 2          sale 3              highest
1                               40               10                  90
2                              100                0                  30


thx

sql server - HELP with update statement

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.