Rate Post

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

Author

Message

Gochi
Censor Bewarse
Username: Gochi

Post Number: 86939
Registered: 07-2004
Posted From: 8.7.228.252

Rating: N/A
Votes: 0

Posted on Tuesday, March 08, 2016 - 12:23 pm:

Proofdada:
ikkdi dhaka ayyakaa
i need to left join ( select pp.ProjectActivityID , max( MaxDate) from ? group by pp.ProjectActivoityID) as xyz

dhaanni elaa rayochu

artham kaalaa....just inkoka left join esesthey aipyindhi kadhaa...indulo question enti?

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')

left join ( select pp.ProjectActivityID , max( MaxDate) from ? group by pp.ProjectActivoityID) as xyz on xyz.activityid = .....activityid

Administration