28.06.2012, 12:45 | #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). |
|
|