posted on Wednesday, May 11, 2005 7:20 PM
by
amachanic
The Texas Hold 'em SQL Challenge
I receive about 25 comment SPAMs a week advertising Texas Hold 'em.
So I figured, why not join the fun?
Here's the challenge: Come up with a schema that represents players, hands, and bets in a series of Texas Hold 'em games. Come up with a method of randomly populating the tables (i.e. dealing the cards). Bonus points for figuring out how to make the players bet intelligently -- i.e. when they have good hands! Finally, come up with a way to figure out how much cash each player has -- a score at any given point in the games.
This should be done entirely using SQL Server 2000 or SQL Server 2005. XML and/or CLR are fair game, of course.
Send the solutions to me via the Contact link. I'll evaluate the responses and post any complete solutions I get. And I'll find some good award(s) for the best solution(s).