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

Let's say the table only has 8 rows. etc... so each and every possible combination. I THINK this will end up with 16,777,216 possible combinations when I'm done. Now I could just write 8 queries that ...

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