I've translated the Transact-SQL code in this article:

http://www.sqlteam.com/article/sqlchess-a-tutorial-on-thinking-in-sets

to EDB SQL (attached).

If you want to check it out:

1. Create a new database named e.g. Chess.

2. Create the sp_Chess_db procedure using the sp_chess_db.sql code.

3. Execute the sp_Chess_db procedure to create the database objects.

4. Check out the queries in Chess_queries.txt.

Regards,
Ole Willy Tuv

Ole,

<< I've translated the Transact-SQL code in this article:

http://www.sqlteam.com/article/sqlchess-a-tutorial-on-thinking-in-sets

to EDB SQL (attached). >>

Cool, thanks.

--
Tim Young
Elevate Software
www.elevatesoft.com