Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Raffle SQL Server Style Expand / Collapse
Author
Message
Posted Wednesday, January 5, 2011 8:58 PM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, January 6, 2011 4:20 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:57 AM
Points: 7,112, Visits: 6,280
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

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
Posted Thursday, January 6, 2011 7:15 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:22 PM
Points: 11,148, Visits: 12,889
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
Posted Thursday, January 6, 2011 7:22 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, January 6, 2011 9:21 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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
Posted Thursday, January 6, 2011 10:19 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, January 6, 2011 10:31 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 1:19 PM
Points: 3,101, Visits: 7,807
Brandie Tarvin (1/6/2011)
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.


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
Posted Thursday, January 6, 2011 11:05 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse