Some nice code and a useful tool 🙂

Will need to replace the "THROW" command with RAISERROR to make it work on older versions of SQL Server

nice simple question... the answer selection is a bit of a give away though 😉

but, good thing to know when trying to optimize queries.

bad question! 10 is correct 12 could be correct... 10 and 12??!

1

😀

nice question, I was also caught with #2 😀

Thank you for all your posts (positive and negative). Great response and content

Apologies for the grammatical error in the plurals (i never was an english A grader 😉 )

I will...

Is the goal of the question to catch people out or test SQL skill and knowledge?

badly formed answers

you are selecting 4 columns in your question (ID, Y, Test1, Test2) yet your answers and the supposed "correct" one only has 3

I also have a solution in the form of a view that you can join to that will display upline and down line structure depending on how it is joined...

you are going to have to supply more information, perhaps your table structure and the code.

You may also want to re-think using cursors and rather try approach it in...

yes, I have done this often with rCTE's which is much faster 🙂