Timeline for How define select, if bridge pair may have 3 players?
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 14, 2012 at 14:40 | comment | added | Kevin Feasel | I'm not very familiar with MySQL, but you can try the bottom of this post: postgresonline.com/journal/archives/…. It shows how to do something similar to this for Postgres, SQL Server, and MySQL. It looks like it's actually really easy to do in MySQL. | |
| Nov 14, 2012 at 14:31 | comment | added | otm | Thank Kevin for your reply. How to implement in MYSQL? | |
| Nov 14, 2012 at 13:38 | comment | added | Matt M | +1 for mentioning that the preferable way to perform this is outside of T-SQL. For kicks, I compared the execution plans of our two solutions, by running them in the same batch and forcing a plan recompile. I show that your query costs 73% relative to the batch, and mine costs 27%. For this small sample, this means next to nothing. However, I would be interested to see how both of our queries scale to a large data set. Good stuff! | |
| Nov 14, 2012 at 13:30 | comment | added | Lamak | +1, This works great. Here is an sqlfiddle with this example: sqlfiddle.com/#!3/f68b9/6 | |
| Nov 14, 2012 at 13:24 | history | answered | Kevin Feasel | CC BY-SA 3.0 |