Rate this post by selecting a number. 1 is the worst and 5 is the best.

Author Message   Proofdada Bewarse Legend Username: Proofdada Post Number: 145626 Registered: 03-2004 Posted From: 71.170.93.71 Rating: N/A Votes: 0 Posted on Tuesday, March 08, 2016 - 12:15 pm:    Stewie: Gochi: ipudu select count(c.*) from [JobCenter3R2Prod].[dbo].[ProjectProfessionals] as c left join [JobCenter3R2Prod].[dbo].[Projects] as a on c.ProjectID = a.ProjectID left join (select ProjectID,max(MileStoneDate) as MaxDate from [JobCenter3R2Prod].[dbo].[ProjectMilestones] group by projectID) as b on c.[ProjectID] = b.[ProjectID] and year(b.MaxDate) = 2015 left join [JobCenter3R2Prod].[dbo].[ProjectStatusTypes] as a1 on a1.[ProjectStatusTypeID] = a.[ProjectStatusTypeID] left join [JobCenter3R2Prod].[dbo].[ProjectProperties] as pp on pp.ProjectActivityID = c.ProjectActivityID and pp.City in( 'Atlanta', ',Atlanta','atlanta') ikkdi dhaka ayyakaa i need to left join ( select pp.ProjectActivityID , max( MaxDate) from ? group by pp.ProjectActivoityID) as xyz dhaanni elaa rayochu