Raffle SQL Server Style

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Alex Tocitu » Raffle SQL Server Style

Raffle SQL Server Style

Rate Topic

Display Mode

Topic Options

Author

Message

Alex Tocitu

Posted Wednesday, January 05, 2011 8:58 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, August 18, 2012 8:39 PM
Points: 7, Visits: 207

Comments posted to this topic are about the item Raffle SQL Server Style

Post #1043460

Brandie Tarvin

Posted Thursday, January 06, 2011 4:20 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 6,668, Visits: 5,695

Our user group usually just signs a numbered sign-in sheet and someone pulls out a iPhone to go to Random.org to find the number. But you're correct. We should be using SQL Server.

This is one of the more entertaining scripts I've seen posted to these forums. Good job and thanks.

Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Post #1043626

Jack Corbett

Posted Thursday, January 06, 2011 7:15 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

I agree with Brandie, a entertaining and useful script.

We do the raffle tickets but this is better. Maybe add electronic sign-in to the meeting to generate the number for each participant.

Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2

Post #1043733

Alex Tocitu

Posted Thursday, January 06, 2011 7:22 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, August 18, 2012 8:39 PM
Points: 7, Visits: 207

Thanks for y'all comments so far.
I plan to put an interface on the sprocs - maybe WP7 to beat the iPhone?

Post #1043739

Ron Porter

Posted Thursday, January 06, 2011 9:21 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, July 28, 2011 8:03 AM
Points: 70, Visits: 316

I did something similar several years ago (dBXL, so maybe more than several!). It was for our trade show booth, so we had it up on the biggest screen we could find (eventually a projector).

My structure was a bit different, to say the least. I had Registrant, Event, Registration, Prize, EventPrize and Award tables (just guessing at the names at this late date). Registrant was name, phone, etc. Event was event name, start-end date, etc. Registration was to track who was registered for which event and had unique indexes to prevent multiple registrations for a single event. Prize was the list of prizes and EventPrize was to track which prizes were available to which events. EventPrize included a quantity field so that multiples of a given prize could be available to any event and had unique indexes to prevent any prize from being listed more than once for each event. The Award table joined Registration and Prize. There was a unique index to prevent any Registration from winning more than one prize.

The heart of the matter was some code to fill the Award table by randomly selecting Registrations and EventPrizes until the number of Award records per EventPrize equaled the quantity set in EventPrize. If I recall correctly, I managed the selection pool for prizes and used some kind of error handling to deal with 're-picks' of winners. (I wanted to learn how to do both things and any delays in picking a winner just added to the suspense during the draw.)

The fun part was figuring out how to make the 'drawing' flashy. I filled the screen by cycling up through the ASCII table for each letter in a winner's name until I hit the right letter for that position in the name. Actually, the whole thing was fun: this was my very first production quality relational database and was as much a learning exercise as anything else, although they did use that program for about 20 trade shows over the course of 4 or 5 years.

People could type in their own info, but we also had a couple of people working as data entry clerks to handle business cards and verbal registrations. That data entry program was pretty neat, too, but that's for a different day :)

Post #1043843

Alex Tocitu

Posted Thursday, January 06, 2011 10:19 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, August 18, 2012 8:39 PM
Points: 7, Visits: 207

Ron,
It's amazing what people did with dBaseIII+; I was one of them back in the day :>)

Post #1043874

Alvin Ramard

Posted Thursday, January 06, 2011 10:31 AM

Hall of Fame

Group: General Forum Members
Last Login: Saturday, November 10, 2012 8:24 AM
Points: 3,031, Visits: 7,383

Brandie Tarvin (1/6/2011)

We almost do the same. We normally use the presenter's laptop instead of the iPhone.

Alvin Ramard
Memphis PASS Chapter

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

Post #1043877

Alex Tocitu

Posted Thursday, January 06, 2011 11:05 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, August 18, 2012 8:39 PM
Points: 7, Visits: 207

Try running these scripts in Denali; can't beat SSMS editor ;)

Post #1043901

« Prev Topic | Next Topic »

Permissions