Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kavi123
Starting Member
6 Posts |
 Posted - 2007-11-06 : 00:14:36
|
| if you take an online application when two members are logged in at the same time when only one product left in this case how to decide which user will get that product? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-06 : 00:18:05
|
basically it is "first come first serve". What does your business rules or guide lines say about this ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
kavi123
Starting Member
6 Posts |
Posted - 2007-11-06 : 11:33:22
|
| actually am attending for the interviews so some one asked me this question ..my project is ecommerce platform like its an online store so what shud i tell pls reply .Thanx |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-06 : 11:45:39
|
| well what does happen?it depends on how you coded your app.there's no definite answer._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-06 : 11:52:48
|
I think this is more of a business decision.On normal case it will be on first come first serve basis. But depending on the business requirement, customer with higher priority might get the product. There are tons of possibility for this. Like customer with larger order amount ? long term customer ? repeat order ? delivery deadline ? any penalty ? As spirit said, there isn't a definite answer to this. It all cames down to one question that i asked earlier in my post. "What is the business rule ? "
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2007-11-07 : 09:28:26
|
| Since its for an interview question, you should answer honestly."I have no idea. Tell me your business rules and I will implement them."[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
|
|
|
.net