SQL Server executes the anchor member once, stores the result as the current set, then executes the recursive member using the current set. The output of each iteration becomes the input for the next.

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 ...

Hey All,<BR><BR>Got a question regarding 2 sprocs I need to make (once I get the first one done the other will be easy cause its just the opposite). Here's the deal: I have a database with table ...