Thanks, both of you were spot on. It was the problem with the counter not incrementing. After I replaced @Counter +1 with cte.c+1 in the recursive query, it worked correctly