Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 How do I calculate this? Rate Topic Display Mode Topic Options
Author
 Message
 Posted Monday, May 27, 2013 6:15 PM
 SSC-Enthusiastic Group: General Forum Members Last Login: Tuesday, October 08, 2013 6:26 AM Points: 173, Visits: 671
 I have a table called locations with fieldnames:locationId --determines the location of traineelocationName --name of the location trainingmaxSeat --total number of seats allowed at that location.available_seats -- (MaxSeat - registered trainees)My question is:We would like to a button that says "Register" to substract a number from MaxSeat and "Cancel" to put back a number to MaxSeat.In other words, when a potential trainee registers for a class, we would like to substract a number from maxSeat.For instance, maxSeat is 45. If a trainee registers for that class, we would substract 1 from maxSeat.Example: if maxSeat is 45 and a new trainee registers, we would like to see available seat as 44.If another trainee registers, available seat should read 43, etc.If a trainee decides to cancel a seat, this puts back a seat to availlable_seat so that it now goes up by one.How can I code this?Thanks a lot
Post #1457161
 Posted Monday, May 27, 2013 11:22 PM
 SSC-Dedicated Group: General Forum Members Last Login: Today @ 7:09 AM Points: 34,553, Visits: 28,729
 Create another value somewhere that is a copy of the MAX. Increment and decrement that with the idea that "returns" will never drive the number over the MAX and "draws" will ever decremet the number below 0. --Jeff Moden"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column." "Change is inevitable. Change for the better is not." -- 04 August 2013(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013Helpful Links:How to post code problemsHow to post performance problems
Post #1457186
 Posted Tuesday, May 28, 2013 6:50 AM
 SSC-Enthusiastic Group: General Forum Members Last Login: Tuesday, October 08, 2013 6:26 AM Points: 173, Visits: 671
 Thanks Jeff.
Post #1457294

 Permissions