Percent Complete in SQL Server

J

Jeff Washburn

Does anyone know where I can get the % Complete value found on
Projects Tab in PWA in SQL Server? Is it a calculation or is it
stored somewhere?

I have looked through the tables with no luck.

Thanks,
Jeff
 
J

Jack D.

Jeff said:
Does anyone know where I can get the % Complete value found on
Projects Tab in PWA in SQL Server? Is it a calculation or is it
stored somewhere?

I have looked through the tables with no luck.

Thanks,
Jeff
Click to expand...

I believe it is a project property.
Have you read through the svrdb.htm document?

--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP
email: J -at- eM Vee Pee S dot COM


+++++++++++++++++++
 
K

Kevin Flanagan

MSP_TASKS table - the field is TASK_PCT_COMP

where TASK_UID = 0 will give you the summary task or
project level information

Hope this helps.

Kevin
 
J

Jeff Washburn

Thanks Kevin, That worked great!!

Kevin Flanagan said:
MSP_TASKS table - the field is TASK_PCT_COMP

where TASK_UID = 0 will give you the summary task or
project level information

Hope this helps.

Kevin
Click to expand...
 
Top