update a view

[aspnet98]

I have a view that displays a random selection of ids for each user in my db.

id name selection
9 jay 4
5 jay 4
3 jan 4
1 jan 4
4 joe 4
8 joe 4

for each user, i need to update the top 5 ids in the selection column to a random 1 or 0 value. (rand() for each id seed)

is this possible?

 

[aspnet98]

opps when i said update the top 5 ids i meant the top 5 records because the query above uses order by new id() because i need to update random ids for everyone not just the first 5 in order....

 

[aspnet98]

i only show 2 for each user but picture 5 for each.

each five would have ids 1 - 5 in rand order new id ()

 

[aspnet98]

is this possible? i do not think it is