Re: Leveling by ID vs. "Standard"

I tell you what.
I'd be great if Project had a SQL interface !

Suppose there was a table called [Tasks]
and another called [Resources]
and another called [Assignments]

....then to get a list of appointment for both the judges
and the musicians would be a simple 3 minute
GUI exercise in MS Query.

Of course, MS Query is another cool MS product.

"Real" database guys would rather just type in the
SQL query for the view they want. In this case it
would look like this...

"SELECT
Resource_Usage.Resource_Name,
Resource_Usage.Task_Name,
Resource_Usage.Start,
Resource_Usage.Finish,
Resources.Resource_Name AS Room
FROM
(Resource_Usage
LEFT JOIN Tasks
ON Resource_Usage.Task_Name
= Tasks.Task_Name)
LEFT JOIN (Resources
RIGHT JOIN Assignments
ON Resources.Resource_Name
= Assignments.Resource_Name)
ON Tasks.Task_Name
= Assignments.Task_Name
WHERE
(((Resource_Usage.Resource_Name) Not Like "* Room")
AND
((Resources.Resource_Name) Like "* Room"))
ORDER BY
Resource_Usage.Resource_Name,
Resource_Usage.Task_Name,
Resource_Usage.Start,
Resource_Usage.Finish
;"

....where [Resource_Usage] is another view
defined by this...

SELECT
Resources.Resource_Name,
Tasks.Task_Name,
Assignments.Start,
Assignments.Finish
FROM
Tasks
RIGHT JOIN (Resources
LEFT JOIN Assignments
ON Resources.Resource_Name
= Assignments.Resource_Name)
ON Tasks.Task_Name
= Assignments.Task_Name
ORDER BY
Resources.Resource_Name,
Tasks.Task_Name,
Assignments.Start,
Assignments.Finish
;"

Just THINK of what you could do!

:-)

Hey,

1. Does Project Server run on SQL Server?
2. Does Project Server give you SQL access?

If you scrolled down far enough to answer this
question, then I really am proud of you. Still, is
there any way to see Project tables?

Thanks, Jim


.

Relevant Pages

  • Re: A database theory resource - ideas
    ... Looks more like a blog and some occasional pieces than an actual collection ... Most old timers are aware of Dick Pick's disparaging remarks about SQL ... When it comes to resources, the ACM portal has as many reputable ... If we look at the front lines of modern software development and also ...
    (comp.databases.theory)
  • Re: Another SQL Memory Issue
    ... IMO these still do not explain the large allocation of SQL resources. ... It seems to me that some people with SBS throttle the maximum memory ... My SBS has 4 GB of RAM, and it was bugging me to have WSUS using a ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server 2000 Hardware Recommendations?
    ... Hardware Performance CheckList ... Andrew J. Kelly SQL MVP ... >> trace and see what is taking up all the resources especially cpu. ... Currently the database server houses all data pertinent to ...
    (microsoft.public.sqlserver.server)
  • Re: SP3a on cluster...help please
    ... The article specifically talks about resources in the same SQL resource ... As for replication, you can stop the log reader and distribution tasks ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: New to SSIS and importing csv & .xls - need assistance
    ... As a small-company 'SQL DB administrator' (still climbing up the SQL2005 ... I am trying to find resources that would allow me to: ... the package at the end instead of simply executing and discarding it. ... Finally, there is a .integrationsvs group, but it seems the .dts group ...
    (microsoft.public.sqlserver.dts)
Loading