handling Concurrency in SQL SERVER 2005
- by sameer
Hi,
I have one question for you, if you can answer and refer resource it will be great help.
I have a scenario where i need to create a appointment slot and a serial no for each slot memberwise.
ex:
Member Id |App Slot #
1|1
1|2
2|1
2|2
1|3
what im doing is take the Max slot number,increamenting it and insert it memberwise. but the problem is concurrent user can create a slot when i take the max slot after that if any other user insert the slot the value that im working with is no more valid, how to over come this problem
Thanks & Regards,
Sameer