DrillDown on Recursive Data

How can I do drilldown on recursive data?
I have a table with products that have parent products
Eg:
ProductID ParentProductID
1
2 1
3 1
4 2
I want to drill down on all the levels.
Thanks
--
Matias from Argentina!Look here:
http://groups-beta.google.com/groups?q=sql+server+recursive+select
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"matiasls" <matiasls@.hotmail.com> wrote in message
news:2BF2A852-9F50-47A6-9369-AE00F89C50FF@.microsoft.com...
> How can I do drilldown on recursive data?
> I have a table with products that have parent products
> Eg:
> ProductID ParentProductID
> 1
> 2 1
> 3 1
> 4 2
>
> I want to drill down on all the levels.
> Thanks
> --
> Matias from Argentina!