Jeff Moden (8/25/2014)
patrickmcginnis59 10839 (8/21/2014)
CELKO (8/21/2014)
This is one of those places where a loop (please see the solution I posted above) actually does work quite well and it's self correcting based on the number of rows in the two tables. And, remember... I'm one of those that hates loops! 😉
We are getting into an example of why "set-oriented programming can stink" that us RDBMS (functional, declarative, whatever) do not want to admit. By its nature, set-oriented programming must produce all valid answers.
Well there goes my set oriented chess program idea.
Heh... it IS called a "Chess Set". 😛
LOL select from positions where checkmate = 1. Unfortunately I'd probably use a scalar function and run out the game clock.
Interestingly enough that reflects my actual game, either lose badly or run out of game clock.