Stored proc question 1

[MarkGreen]

Hi,

What would the syntax to update a boolean field in the record that contains the highest value in an integer field.

I bascially need to set a flag in the record that has the highest ID.

I've looked in various resources but they dont seem to quite answer the questions that i need. For instance - Can you use "TOP" with "UPDATE"?
Any help is much appreciated
Mark

 

[grahams]

Can you not simply use MAX() whenever you need to know which is the highest valued?

HTH,

Graham

 

[JamesLean]

You could use something like this:

UPDATE table_name
SET IsHighest = 1
WHERE int_col = (SELECT MAX(int_col) FROM table_name)

Obviously if more than one row has the highest value, this will update them all. --James

 

[MarkGreen]

Thanks James, I suspected it was something similiar but i couldnt quite get the syntax correct.

Mark