select top 1 cmp_id from CSR_COMPLEMENT

where DOS_ID = (select DOS_ID from CSR_DOSSIER where DOS_NODE = @DOS_NODE) order by cmp_numordre desc

Might be missing something but if you only want 1 cmp_id...

Festo SmartBird

dwain.c (8/7/2012)

---

Lynn Pettis (8/7/2012)

---

I don't know, but I'm really getting tired of questions wanting answers but not getting enough information to for me to even start to give a decent...

You can find the RSClientPrint........cab file in the SSRS installation location.

Something like C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin

Where you should find RSClientPrint-ia64.cab, RSClientPrint-x64.cab and RSClientPrint-x86.cab

Then you should be able to install...

Well something or someone has deleted the dll or a referencing dll or the dll's are not registered.

What version of SQL and Service Pack level are you on?

I would recommend...

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...