Käynnissä

SQL for Microsoft Project Query

I want the SQL SELECT statement to extract information from the MS SQL database behind MS Project Server. This will require SQL knowledge along with knowledge of the MS Project database. I want to extract the forecasted amounts of work by project for resources in MS Project for the next four weeks. The weeks end on Friday. The attached Excel spreadsheet gives an idea of the format that I expect the data to be returned. Having the sub-total lines is optional as I can pull the data to Excel and sub-total there.

Note: I am only looking for a SQL statement. I don't need a program or anything complex. Successful completion may bring on additional SQL query requests.

Taidot: projektinhallinta

Näytä lisää: microsoft project sql query, project query, query project, sql query project, microsoft project sql, query project database, sql project query, extraire work msproject vba, sql microsoft project, query project data, microsoft project query, query microsoft project, sql database program, n query, microsoft excel spreadsheet, microsoft excel management, project sql query, project sql, mpp aspnet sql, sql crm sql request, project numbering, query excel total peoplesoft query manager, microsoft project microsoft query, project getting data sql server, excel project query

Tietoa työnantajasta:
( 1 arvostelu ) Boston, United States

Projektin tunnus: #413435

Myönnetty käyttäjälle:

ngrey

It would be my pleasure to do this query for you.

90 $ USD 2 päivässä
(1 arvostelu)
2.5

6 freelanceria on tarjonnut keskimäärin 152 $ tähän työhön

a3pprovider

Kindly consider detail in PMB.

200 $ USD 2 päivässä
(5 arvostelua)
4.2
cliquerz

Hi, we use ms project in our company and I can take a look at it ang give you the SQL you need.

150 $ USD 2 päivässä
(0 arvostelua)
0.0
Ntronixs

do contact for speedup and quality delivery, Well, I’m Expert on PHP, JAVA & Microsoft Technologies. I may take less then quoted. The estimation of this assignment completely varies and depends on the Requirement / F Lisää

250 $ USD 2 päivässä
(0 arvostelua)
0.0
yashiscool

We are a group of experts having an average experience of 7-8+ years in this industry with some reputation within the local clients. Need to expand ourselves with high quality deliveries in time and making our customer Lisää

120 $ USD 3 päivässä
(0 arvostelua)
0.0
lija

Please check PM for details Thank you Lija

100 $ USD 2 päivässä
(0 arvostelua)
0.0