select g.Agency,g.Goal, o.Objective,p.PI,p.PIID,P.Method,a.[ActivityName],A.ActivityID,'' as Count, '' as Hours,'' as ProgressSetback, '' as Month from tblOrgGoals G Join tblOrgObjectives O on G.GoalID = O.GoalID and g.agencyid=o.agencyid Join tblOrgActivities A on O.ObjectiveID = A.ObjectiveID and g.agencyid=a.agencyid Join tblOrgPI P on P.ActivityID = A.ActivityID and g.agencyid=p.agencyid LEFT Join tblOrgMonthlyProgressSetbacks S on P.PIID = S.PIID and g.agencyid=s.agencyid Where G.AgencyID = '74' And A.Fiscal = 2015 order by G.Agency,G.Goal
|MSSQL: Replace text (typo)||7||33|
|How to get time difference in minutes and seconds only between 2 dates||2||23|
|What query can i write to find where a function is||4||22|
|Using SQL Server 2008, how would you convert [datediff(day, dtcreated,getdate()) AS Age] into its equivalent if "dtcreated" is defined as varchar(10)?||14||20|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!