How to update a table with a list of values at a time?
- by VJ
I have
update NewLeaderBoards set MonthlyRank=(Select RowNumber() from LeaderBoards)
I tried it this way -
(Select RowNumber() from LeaderBoards) as NewRanks
update NewLeaderBoards set MonthlyRank = NewRanks
But it doesnt work for me..Can anyone suggest me how can i perform an update in such a way..