SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Alex Tocitu / Raffle SQL Server Style / Latest Posts

RE: Raffle SQL Server Style

Alex Tocitu — Thu, 06 Jan 2011 11:05:34 GMT

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

RE: Raffle SQL Server Style

Alvin Ramard — Thu, 06 Jan 2011 10:31:48 GMT

[quote][b]Brandie Tarvin (1/6/2011)[/b][hr]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.[/quote]We almost do the same. We normally use the presenter's laptop instead of the iPhone.

RE: Raffle SQL Server Style

Alex Tocitu — Thu, 06 Jan 2011 10:19:17 GMT

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

RE: Raffle SQL Server Style

Ron Porter — Thu, 06 Jan 2011 09:21:06 GMT

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 :)

RE: Raffle SQL Server Style

Alex Tocitu — Thu, 06 Jan 2011 07:22:25 GMT

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

RE: Raffle SQL Server Style

Jack Corbett — Thu, 06 Jan 2011 07:15:22 GMT

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.

RE: Raffle SQL Server Style

Brandie Tarvin — Thu, 06 Jan 2011 04:20:17 GMT

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.

Raffle SQL Server Style

Alex Tocitu — Wed, 05 Jan 2011 20:58:37 GMT

Comments posted to this topic are about the item [B]Raffle SQL Server Style[/B]