27 reputation
6
bio website menyhert.6f.sk
location Slovakia
age 51
visits member for 1 year, 11 months
seen May 5 '13 at 12:50

Programer perl, php, mysql, pascal.
Bridge player.


Nov
15
accepted How define select, if bridge pair may have 3 players?
Nov
14
comment How define select, if bridge pair may have 3 players?
Thank Kevin for your reply. How to implement in MYSQL?
Nov
14
awarded  Custodian
Nov
14
reviewed Approve suggested edit on How define select, if bridge pair may have 3 players?
Nov
14
asked How define select, if bridge pair may have 3 players?
Oct
29
awarded  Scholar
Oct
29
awarded  Supporter
Oct
29
accepted Rank in more tournaments and boards
Oct
29
accepted How to summarize Bridge results?
Oct
29
comment How to summarize Bridge results?
Thanks for answer, this work good
Oct
29
comment How to summarize Bridge results?
sum is sum(MPNS)+sum(MPEW). Pair 1 in this sample all time play on NS and 5 is 0+4+1 Sample of result bridge tournament bridgekosice.sk/upload/vysledky/n261012.htm
Oct
29
asked How to summarize Bridge results?
Oct
29
awarded  Autobiographer
Oct
29
comment Rank in more tournaments and boards
You are right. Now works all excelent. Very thaks.
Oct
29
comment Rank in more tournaments and boards
Yes, with the same data. The first select work good on both source data, but no work as view. Error message is View's SELECT contains a subquery in the FROM clause
Oct
29
comment Rank in more tournaments and boards
Thanks for answer. With sample data it is works good, with my real source data is litle problem. If source is table, all is OK, if source is view, with the same structure and data, rank is bad.
Oct
29
awarded  Student
Oct
28
comment Rank in more tournaments and boards
if tie places is 1 and 2, rank is average 1.5, board 1 tournament 2, 2-3-4 is average 3
Oct
28
awarded  Editor
Oct
28
revised Rank in more tournaments and boards
data