The basic concept of recursion is straightforward: a given chunk of code calls itself until some boundary condition is reached. Arthur Fuller demonstrates how to use recursion in T-SQL. TechRepublic’s ...
Background:<BR>I have a self-referencing SQL Server 2005 table that looks something like...<BR><BR>ID PARENT KEY VALUE<BR>1 0 Hardware 0<BR>2 0 Software 0<BR>3 1 CPU Intel<BR>4 3 Speed 3 ghz ...