Script copy max value from a column

[gil_super43]

Hello guys!
I want to do a script to my server. Can i get some help?

Example of the situation:
The TOP resets from my server has 484 resets. I want to do a query that copy the 484 value to all others characters, so all the other players will get 484 resets too.

Thank you!

[MentaL]

[RevolGaming]

automatic... ? if automatic you need crone job.

it other hand,

Update Character set Resets=(Select Top 1 Resets FROM Character ORDER BY DESC)

[gil_super43]

It worked!
Thank you,

RevolGaming !

[RevolGaming]

yes, I know its working, lel.

but why you need this query? whare are you doing with this? I just wanted to know.

[gil_super43]

Actually its for another column, just thought it was easy to explain that way.
Its like a 'model' player who will get some data copied to new players.
Thanks!