Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Monty Hall Paradox

By Sean Smith,

"The Monty Hall Paradox is a veridical paradox in that the result appears absurd but is demonstrably true."

 

I wrote this piece of code to demonstrate that the laws of probability change drastically by simply setting the "@vSwitch_Door_Picked" variable from 1 to 0 or 0 to 1.

 

More detailed information on this paradox can be found on Wikipedia: http://en.wikipedia.org/wiki/Monty_Hall_problem

 

The code is just for fun and makes for an interesting conversation piece at best. Give it a try and enjoy!

Total article views: 1184 | Views in the last 30 days: 1
 
Related Articles
FORUM

Connecting Paradox 4.0 (DOS) to MSSQL 2008.. $contract$ available

Connecting Paradox 4.0 (DOS) to MSSQL 2008

BLOG

Review: The Abilene Paradox

The Abilene Paradox by Jerry Harvey is not a new book, written in 1988. It’s part of some reading I’...

FORUM

Need help importing Paradox data

Trying to import Paradox tables with memo fields to SQL Server 2008

FORUM

Paradox

Hi Folks Is it possible to access a Paradox table through Query Analyzer, can OpenRowSource be used...

FORUM

Paradox Help !!!

Hi Guys, I've got a collection of paradox tables that I need to connect to SQL server 2000.  I've b...

Tags
fun    
hall    
monty    
paradox    
probability    
puzzle    
 
Contribute