I'm having an issue with an ASP page occasionally timing out. The specific error is the following:<BR><BR>"*.DBCommand.Execute(): Microsoft OLE DB Provider for SQL ...

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

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