Project Server - TSQL query /view

Need to SQL developer to develop a TSQL view that will count the number of projects per person in an existing view on a functional Project Server 2010 development server.

Example: Count the number of projects per person per month and set into new field (number-of-projects). Divide the capacity by the number of projects.

The resource has 2 projects for January 2013 and the actual capacity calculated is 35.2 / number of projects (2) = 17.4

Evner: Microsoft, SQL

Se mere: the month of january, january is the month of, january is month, TSQL, sql server developer projects, person per month, set project server 2013, sql microsoft project, 2013 query, set server 2013, microsoft project sql query, project server 2013, microsoft sql server developer, field development project, sql query field, sql query month, project sql query, sql query project, microsoft project 2010, microsoft project server 2010

Om arbejdsgiveren:
( 12 bedømmelser ) Marietta, United States

Projekt ID: #4658485

Tildelt til:


let me do it for you

$43 USD på 1 dag
(16 bedømmelser)

2 freelancere byder i gennemsnit $77 på dette job


Hello, We are ready to start. Kindly share us the complete details. Thanks and Regards Netcore Info Solutions

$110 USD på 1 dag
(0 bedømmelser)