Education & Training
Services & Support
to create and rate content, and to follow, bookmark, and share content with other members.
Question asked by
on Jun 25, 2010
on Jul 21, 2010 by raise.clarity
Show 0 Likes
I am looking for a query that breaks down number of timesheets by their status (columns) and grouped by resource OBS (rows)
No one else has this question
Mark as assumed answered
This content has been marked as final.
Show 1 comment
(Required, will not be published)
Jul 21, 2010 8:02 AM
You can try the below -
SELECT R.USER_ID, R.UNIQUE_NAME,
R.LAST_NAME, R.FIRST_NAME, PRT.PRUID, prt.PRID, prt.PRTIMEPERIODID, prt.PRSTATUS,
(select nbi.path from nbi_dim_obs nbi, prj_obs_associations pra
where pra.record_id=r.id and pra.table_name='SRM_RESOURCES'
and nbi.obs_unit_id=pra.unit_id and nbi.obs_type_name = '<OBS NAME COMES HERE>') path FROM CMN_SEC_USERS C,
NBI_RESOURCE_CURRENT_FACTS N, SRM_RESOURCES R, prtimesheet prt WHERE R.ID = N.RESOURCE_ID AND C.ID = R.ID
and R.IS_ACTIVE = 1
Show 0 Likes
Retrieving data ...
Datacom/DB exploitation of z13 Simultaneous Multi-Threading?
Which Most Accurately Describes Your Feelings With Regards to Getting an Answer on Communities?
Tech Tip: Where do I find PAM upgrades, and other patches
MetaCOBOL to allow LOCATE SEQUENTIAL WITHIN RANGE
Enhance SQL Monitor to show/purge plan locks