Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

need some SQLSERVER guru advice.

No replies
Sat, 2009-01-03 12:06
mimoune djouallah
User offline. Last seen 4 years 40 weeks ago. Offline
Joined: 14 Oct 2006
Posts: 388
Groups: Petro-Chem / Oil & Gas, Spider Project Team
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
Top