Hey,
Thanks for your response and yes I know that my code could use a lot o
cleaning up. I am mainly a network engineer (CCIE #12284) and onl
program as a hobby.
The structure of the database is:
CREATE TABLE [dbo].[tblTournaments] (
[TID] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
[TNum] [numeric](18, 0) NOT NULL ,
[TDate] [datetime] NOT NULL ,
[Member] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NUL
,
[Buyin] [money] NOT NULL ,
[TType] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NUL
,
[won] [money] NOT NULL ,
[Place] [int] NOT NULL ,
[TotalPlayers] [int] NULL
) ON [PRIMARY]
The situation is that 3-4 of us will team a Multi-Table Poke
tournament online and share or profits of that tournament to hel
balance the swings that can occur when playing poker. When we finish
tournament all users enter the information for that tournament an
every tournament is stored in the same table. If the tournament number
match that means that multiple members played in the same tournament
Example data would be:
10 2071171 2004-07-14 00:00:00.000 Kewlb 11.0000 2T-SnG .0000 6 18
11 35224 2004-07-12 00:00:00.000 Ammbo 33.0000 3T-SnG .0000 14 30
12 2048673 2004-07-12 00:00:00.000 Ammbo 33.0000 1T-SnG .0000 6 9
13 2048934 2004-07-12 00:00:00.000 Ammbo 22.0000 2T-SnG .0000 9 18
The point of my function was to create a report of a certain player
stats. My goal was to first pull all the tournaments that a certai
user has participated in. After I know all of these tournaments I nee
to grab all members that played in each of these tournaments the
calculate the stats on these tournaments.
I also have an even bigger issue that I just gave up on as I could no
figure it out. My goal was to calculate "owsies" on a per week basis
Pretty much the function would have to pull all tournaments for th
last week and figure out who owes what member what as well as cance
out owes (ie: member 1 owes member 2 $20 and member 2 owes member 1 $1
then it should only report that member 1 owes $10 to member 2 for tha
week.)
Thanks for your help let me know if you need any more information.
can do everything I want in Visual Basic, yet I love a challenge an
want to get this working in a pure ASP script so I do not have to ru
another back-end application just to handle my calculations
-
Kewl
-----------------------------------------------------------------------
Posted via http://www.codecomments.co
-----------------------------------------------------------------------