|
|
#20 |
|
MCITP
|
А если так написать?
SELECT max(ch.modifiedon) AS 'Дата', ch.new_commentary AS 'Комментарий', opp.name AS 'ВС' FROM Filterednew_changeopportunity AS ch INNER JOIN FilteredOpportunity AS opp ON ch.regardingobjectid = opp.opportunityid WHERE (ch.actualend BETWEEN dbo.fn_BeginOfMonth(GETDATE()) AND GETDATE()) group by ch.new_commentary , opp.name |
|
|
|
| За это сообщение автора поблагодарили: NoTimeToCry (1). | |
|
|
|