PDA

View Full Version : Query for session results



fclerc
10-29-2008, 06:25 AM
Hi
I'm trying to build a c# program to track my session results and import them directly from the HM database.
I was familiar with PT2 database but not at all with HM database. Can you please show me the SQL query to get the session results by site, date, level of play... and i think i will be able to start from there.
thanks a lot

Rvg72
10-30-2008, 01:05 AM
Hi, we don't actually have a sessions table - instead session details are produced on the fly by looking at the playerhandscashkeycolumns table and looping through the hands looking for breaks of 15 or more minutes (or whatever the session time for the user is set as)

Roy