• I want an idea on how should i build my sql query so that I can have parent-child kind of hierarchy. And then I can show that in SSRS report in drill-down format