I need to create a views which shows a list of Project that are checked out to the users. Can some one help? Thanks in Advance ss028955
G'Day, Try this SQL against the Published DB SELECT PROJ_UID, PROJ_NAME, PROJ_CHECKOUTBY, r.RES_NAME FROM MSP_PROJECTS INNER JOIN MSP_RESOURCES r ON r.RES_UID = PROJ_CHECKOUTBY WHERE PROJ_CHECKOUTBY is not null Note that these tables might change during service packs and access data from any Database bar the Reporting DB is not reccommended. Have Fun "ss028955" wrote: > I need to create a views which shows a list of Project that are checked out > to the users. Can some one help? > > Thanks in Advance > ss028955
Nope Andrew. All the project whether it is checked out or not, the PROJ_ChECKOUTBY value in MSP_PROJECTS table under Published Dabase appears to be Null. "Andrew Jacks" wrote: > G'Day, > > Try this SQL against the Published DB > > SELECT PROJ_UID, PROJ_NAME, PROJ_CHECKOUTBY, r.RES_NAME FROM MSP_PROJECTS > INNER JOIN MSP_RESOURCES r ON r.RES_UID = PROJ_CHECKOUTBY > WHERE PROJ_CHECKOUTBY is not null > > Note that these tables might change during service packs and access data > from any Database bar the Reporting DB is not reccommended. > > Have Fun > > > "ss028955" wrote: > > > I need to create a views which shows a list of Project that are checked out > > to the users. Can some one help? > > > > Thanks in Advance > > ss028955
G'Day again, Are the Projects you want to report on Published or not? If they are not published then ron the sproc against the Draft Database. "ss028955" wrote: > Nope Andrew. All the project whether it is checked out or not, the > PROJ_ChECKOUTBY value in MSP_PROJECTS table under Published Dabase appears to > be Null. > > "Andrew Jacks" wrote: > > > G'Day, > > > > Try this SQL against the Published DB > > > > SELECT PROJ_UID, PROJ_NAME, PROJ_CHECKOUTBY, r.RES_NAME FROM MSP_PROJECTS > > INNER JOIN MSP_RESOURCES r ON r.RES_UID = PROJ_CHECKOUTBY > > WHERE PROJ_CHECKOUTBY is not null > > > > Note that these tables might change during service packs and access data > > from any Database bar the Reporting DB is not reccommended. > > > > Have Fun > > > > > > "ss028955" wrote: > > > > > I need to create a views which shows a list of Project that are checked out > > > to the users. Can some one help? > > > > > > Thanks in Advance > > > ss028955
