cant help you on that, thought it would have to be manually 1 by 1 as you will need to open the files and save them as jpg then re-upload

is that in the SQL server event log or the windows log?

what errors do you get in the windows application log for the agent service?

Yeah its fairly speedy that.

Another option to do it based on my sample data is

SELECT

t1.ID,

t1.Status,

t1.Time

FROM

@sometable t1

INNER JOIN

(

SELECT

ID,

MAX(Time) as maxtime

FROM

@sometable t2

GROUP BY

ID

) as dev1

ON

t1.ID = dev1.ID

AND

t1.time = dev1.maxtime

ORDER BY

1

Running both CTE...

Well more than likely was inserted as BMP, so you would need to extract them and convert them in a picture editor and re-upload them to the DB.

declare @sometable table (ID int, Status nvarchar(50), [time] datetime)

insert into @sometable values (1,'Started','2012-02-02 07:00'),

(1,'Running','2012-02-02 08:30'),

(1,'Completed','2012-02-02 09:30'),

(2,'Started','2012-02-02 04:15'),

(2,'Running','2012-02-02 05:00')

;with cte as

(

SELECT

ROW_NUMBER() OVER(PARTITION BY ID ORDER BY DT DESC) AS RowNum,

*

FROM

@SomeTable

)

SELECT

ID,

Status,

Time

FROM

CTE

WHERE

RowNum =...

So time is actually a datetime column?

Can you provide a true representation of the data?

what happens should the process run over multiple days

eg.

Process 1 starts at 08/08/2012 23:50

Process 1 finishes at 09/08/2012 00:10

how do you differentiate what is yesterday and what is tomorrow?

Thanks Lynn, always forget about diff backups to reinitialise, force of habbit thing I think.

All our user front ends are done in ASP.NET 4, but as long as you can code a connection string to SQL in the application, then you can pretty much...

Unless you have custom monitoring in place which captures blocking you will not find the information you require.

Could you not use something like group policy to install the client at logon time to the machine if its not already installed?

Do you not have any remote software depolyment...

Dont confuse MySQL with MSSQL, they are two very different products and somethings that work in MySQL dont...

Was the binary data uploaded as a jpg or a bmp?

No, you cannot as it violates logical query processing order.

You would need to build in the DATENAME function or build in the CASE call within your WHERE clause.

Best thing to...