OZmium Sports Betting and Horse Racing Forums - track conditions

23rd April 2011, 03:09 PM

stugots

Banned

Join Date: Jan 1970

Posts: 868

track conditions - records

hoping someone may be able to save me a bit of time - I have a bit of a problem regarding the recording of venue track conditions over the last year or so - I record by Unitab venue codes (BR, CR etc) & also by track name.

If anyone with the relevant records would be able to provide a list of 'venue - track conditions' for the last 12 months it would be most appreciated.

26th April 2011, 09:42 PM

jazzy

Member

Join Date: Nov 2010

Posts: 49

Sure, do you want every day or just Saturdays, Metro only or the lot?

Like this? (example for last monday)

(format can be anyway you want, it's a simple SQL query)

Code:


 rcdate     raceno track            state going
 ========== ====== ================ ===== =====
 2011-04-18      1 GRAFTON          NSW   H
 2011-04-18      2 GRAFTON          NSW   H
 2011-04-18      3 GRAFTON          NSW   H
 2011-04-18      4 GRAFTON          NSW   H
 2011-04-18      5 GRAFTON          NSW   H
 2011-04-18      6 GRAFTON          NSW   H
 2011-04-18      7 GRAFTON          NSW   H
 2011-04-18      8 GRAFTON          NSW   H
 2011-04-18      1 KILMORE          Vic   D
 2011-04-18      2 KILMORE          Vic   D
 2011-04-18      3 KILMORE          Vic   D
 2011-04-18      4 KILMORE          Vic   D
 2011-04-18      5 KILMORE          Vic   D
 2011-04-18      6 KILMORE          Vic   D
 2011-04-18      7 KILMORE          Vic   D
 2011-04-18      8 KILMORE          Vic   D
 2011-04-18      9 KILMORE          Vic   D
 2011-04-18      1 NARROMINE        NSW   D
 2011-04-18      2 NARROMINE        NSW   D
 2011-04-18      3 NARROMINE        NSW   D
 2011-04-18      4 NARROMINE        NSW   D
 2011-04-18      5 NARROMINE        NSW   D
 2011-04-18      6 NARROMINE        NSW   D
 2011-04-18      7 NARROMINE        NSW   (NULL)

27th April 2011, 05:41 AM

stugots

Banned

Join Date: Jan 1970

Posts: 868

bewdy

Hi Jazzy, I am after every day every meet for the last 12 months & that format would be great

many thanks

27th April 2011, 07:13 AM

jazzy

Member

Join Date: Nov 2010

Posts: 49

Here 'tis

Attached Files

going2010-2011.zip (59.3 KB, 503 views)

27th April 2011, 08:27 AM

stugots

Banned

Join Date: Jan 1970

Posts: 868

cheers jazzy

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is On

All times are GMT +10. The time now is 02:13 PM.

	To advertise on these forums, e-mail us.