Jackpot Progressive (SQL Stored Procedure), 2008:

Jackpot Progressive Stored Procedure
  • Golden Casino Group properties ©Golden Gaming Inc. Affiliate and partner materials are property of the respective enterprise. These portfolio materials displayed for employment purposes and not for profit, with permission, for the sole purpose of demonstrating the ability of the artist.
  • Developer: Dana Laratta

This automated SQL SP progressed a drawing prize amount for every jackpot over a certain amount detected on a specific range of gaming machines (those in the high limit room). It was hand-coded using SQL 2000 Query Analyzer, and fed variables to a Flash animation displaying the progressive. This ran every 5 minutes, within scheduled jobs on a SQL 200 server, and used BCP as well as an XP_CMDSHELL call to initiate copying of text files containing generated variables to a remote computer to feed the associated Flash application.