TSQL Challenge 58 - Playing Chess in TSQL – Part 1

Sample Data

 
ID  Layout
--- ----------------------------------------------------
1   rnbqk2r/ppppbppp/5n2/4p3/2B1P3/5Q2/PPPP1PPP/RNB1K1NR

Each row in the input table represents the current position of a chess board filled with pieces at various positions. The sample input given above represents a chess board as given below.

Your job is to translate this into a result set that looks like the below illustration.

Read more: Beyond Relational
QR:

Posted via email from Jasper-net