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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Help with Risk analysis

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-16 : 08:19:19
jamie writes "

As part of a project I have built a database that will be used to take bets on a number. Players will log into an asp site and place a bet between 1 and 1000 pounds on the number between 1 and 9999. There will be three numbers drawn representing first, second and third prize.

1st Prize = 3,500 x the amount bet
2nd Prize = 2,500 x the amount bet
3rd Prize = 1,000 x the amount bet

I have built the database but I am having problems with the risk assessment part of the project.
I need to display a list of only the numbers that have been bet on and the liability on each number that takes into account the three prizes. Any help would be appreciated."
   

- Advertisement -