There is no simple way to create recursive queries that have several levels of data (hierarchical data) in SQL Server 2000. A recursive query is used when you have a parent and child data stored in ...
Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Ramya Krishnamoorthy shares a detailed case ...
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 ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback