You're right I should have said "sleeping connections". If I understand well what you're saying there isn't much I can do about it and it doesn't sound too bad.

Almost there. What they are also showing is the SQL or stored procedure involved:

Exampox

SPIDLoginStatusCPU Time Last Run Event Info

106xxxxxx sleeping 2.8859/26/2006 10:11:11 AMSELECT...

Looking fine, thanks

Shame on me ! It was so easy

Thanks

Thanks, you just missed the Declare @Seed int but otherwise it's fine

Thanks,

Just one more thing: the SQL Server I am working with is US based, where the week starts on Sunday whereas I need to have the week starts on Monday....

Thanks for your tips. I actually reengineered the triggers and the stored procedure because some triggers where written a long time ago when part the insert was done manually with...

I guess I'll have to do this. What should I do to change for that particular database to consider the decimal symbol as the comma ?

I guess he can.

By the way the application is written in ASP (NOT in .NET)

Working fine, thanks Ray

It should be : 1 84 000  (the sum of 34000 + 50000)

The query you have is giving me:

1 34000

1 50000

I need an extra step. I want to link this query to another table where when passing the date its retrieving the total value and the average

So for Subscriber 1...

Thanks, it's working as expected, just added S.Average=1 AND

Thanks guys for the answer.

It seems I missed something in my specs and I need an extra thing. The parameters I was thinking to pass down to count the...

No, it's windows based. It's not a matter of showing or not the data audit doesn't even want to see some data on the server.