Posts by Dante • 11 points

• 0

  votes

  1

  answer

  172

  views

  Q: Recursive query does not return records when the parent product and the child product have the same code

  I have a table that maps a production line. The fields are: Product: Machine Output Product. Parentproduct: Input Product. Machine: Code of the machine. I’m using CTE s to get the data recursively.…

  sql-server recursion relationship path

  asked 6 years, 2 months ago Dante 11