connecting queries

C

carlos

SELECT MSP_EpmProject_UserView.ProjectName,
MSP_EpmProject_UserView.ProjectActualWork,MSP_EpmProject_UserView.ProjectBaseline0Cost,
MSP_EpmProject_UserView.ProjectBaseline0Work,ProjectBaseline0StartDate,ProjectBaseline0FinishDate,ProjectModifiedDate
FROM MSP_EpmAssignment INNER JOIN
MSP_EpmProject_UserView ON MSP_EpmAssignment.ProjectUID = MSP_EpmProject_UserView.ProjectUID



SELECT MSP_EpmProject_UserView.ProjectName,
MSP_EpmProject_UserView.ProjectActualWork,MSP_EpmProject_UserView.ProjectBaseline0Cost,
MSP_EpmProject_UserView.ProjectBaseline0Work,ProjectBaseline0StartDate,ProjectBaseline0FinishDate,ProjectModifiedDate
FROM MSP_EpmAssignment INNER JOIN
MSP_EpmProject_UserView ON MSP_EpmAssignment.ProjectUID = MSP_EpmProject_UserView.ProjectUID


SELECT dbo.AllDocs.TimeLastModified, dbo.AllDocs.DirName, dbo.AllDocs.LeafName
FROM dbo.AllDocs
INNER JOIN dbo.AllDocStreams
ON dbo.AllDocs.ID = dbo.AllDocStreams.ID
AND dbo.AllDocs.Level = dbo.AllDocStreams.Level

I have this 3 queries in this databases ProjectServer_Reporting and WSS_Content_9f391acc28a04f51855a2631a23757ad how do i connect?






Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Customized Find Control for FlowDocuments
http://www.eggheadcafe.com/tutorial...3-721a40cf910c/wpf-customized-find-contr.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top