need some SQLSERVER guru advice.

Hi planner and happy New Year.

I am using SQLSERVER database connection to get live data from PM6 to excel, it works as a charm (Imho it is enough reason to upgrade from p3 to P6), I have to thank here emma for sending me a sample spreadsheet.

Now what I need to do is to make a presentation, showing tasks organized by wbs code, the tricky part is that I can only get wbs attached to activities but not that parent WBS.
Something like that

TANKS ERECTION
Tanks with a fixed roof
Demineralised water tanks
TANK.FIXED.DEMI.01 Erection of 6000 M3 demi water tanks.

For now all I can get is

TANK.FIXED.DEMI.01 Erection of 6000 M3 demi water tanks.


Any idea ?


Mimoune