I have an RSVP table with the columns UserID (uniqueidentifier), EventID (int), and Guests (int). How can I add a row to this table, making sure that SUM(Guests) does not exceed some value?
If there was only one thread, I'd simply test the current SUM(Guests) before adding the new row. But with many threads, I don't see a good way to do this.
Jonathan Wood • SoftCircuits
View Complete Post