Dear freiends,<br>
I'am new to SQL Server and want to know that does SQL server supports recursive queries like ORACLE does("connect by", "prior" clauses within PL/SQL).<br>
Let's suppose i've a database which can store categories for an auction site like eBay. The table structure would be like:<br>
Category_tbl<br>
------------<br>
CategoryID<br>
CategoryName<br>
ParentID<br>
CategoryDescription<br>
..<br>
..<br>
<br>
The data will be stored in hierarchical order.<br>
Please suggest.<br>
<br>
Thank You!<br>
-Faisal
I'am new to SQL Server and want to know that does SQL server supports recursive queries like ORACLE does("connect by", "prior" clauses within PL/SQL).<br>
Let's suppose i've a database which can store categories for an auction site like eBay. The table structure would be like:<br>
Category_tbl<br>
------------<br>
CategoryID<br>
CategoryName<br>
ParentID<br>
CategoryDescription<br>
..<br>
..<br>
<br>
The data will be stored in hierarchical order.<br>
Please suggest.<br>
<br>
Thank You!<br>
-Faisal