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

If you are a SQL programmer, learning recursive SQL techniques can be a boon to your productivity. A recursive query is one that refers to itself. I think the best way to quickly grasp the concept of ...