Hi and welcome to the forums. It would greatly help your posts if you provide readily consumable ddl and sample data.

Something like this:

create table #Log

(

Order_Number int,

LogDate datetime,

LogMessage varchar(200)

)

insert #Log

select 67009, '2013-10-02 08:43', 'Order not set for auto-invoice in SVKECH' union all

select 67023, '2013-10-02 08:43', 'Order in-use' union all

select 67023, '2013-10-02 08:43', 'Order not set for auto-invoice in SVKECH' union all

select 109592, '2013-09-06 10:27', 'Order in-use' union all

select 117578, '2013-09-06 10:27', 'Failed Logistics Check' union all

select 117578, '2013-12-12 13:18', 'Called SNM505C.PC00117578' union all

select 119171, '2013-07-05 12:59', 'Order not set for auto-invoice in SVKECH'

I changed a couple of your column names because using reserved words as column names is painful to work with.

The issue you are facing is you want to have a single row for each order but you also have LogMessage in the output. Which message do you want?

This is the proper syntax but it will not return what you are looking for.

SELECT order_number, MAX(LogDate) AS Recent, LogMessage

FROM #Log

group by order_number, LogMessage

What is the expected output based on the sample data?