Hallo Peter,

much Thanks for your Statement. It works PERFECT !!

Thanks & Greetings

Thomas

Hi thanks for answere,

1) it not only for reporting. It show me some Data i need for an realtime report.

2) no more then 65 lines?? But how i show it...

Hallo PW,

i do this Statement from you and my server is hanging up.

For one update i cancel the job after 1 1/2 hours.

Thanks

Thomas

Hallo all and thanks for resumes. In first sorry for my English 🙁 but its not so good.

@bart

There are indexes on the columns:

SCH_SET_SK is normal Index Unique no...

Hallo ,

sorry for ask. But how did you managed the linked server to mysql. I have only problems and still white screens when i do this in the EM.

Thanks for...

Hallo Peter,

thanks for Help its Great. I hope you have an nice Weekend. In next Weeks i have some Projekts where i think in kow it need your help please...

Sorry i dont understand your Problem .

Is true an Row ??

So i think you do this:

Dim strSQL As String

strSQL = "SELECT this, that, theother FROM mytable WHERE "

strSQL = strSQL...

hi ,

what is true ??

Select * from mytable where willi = true

This true must be an char in the row.

What stand in the table please

Thomas

Hallo sorry for answere so late but there are Problems with the Inernet from the IT Service. I take all from you and it RUNS very well.

Thank you for spent...

Hallo,

i have found the misterium .

its the Timestamp '22:00:00.000', '23:59:59.999'.

I write this '22:00:00.000', '23:59:59' and then they count and sum.Do you think its ok??Or change this writing anything ??

Thanks

Thomas

Hallo,

i have done it and now there are no counts or Time in the Column 22-24 ? I dont Knowh why there are different standards. It every night update from...

Hallo, so i have test it in all ways. Its look great. The only Problem is the time 01.01.05 til 21.09.05 its the Format i have written.loginzeit and logoutzeit looks...

Thanks for all. It Looks like Great !!!

I test it as soon i can. In next two hours i have an Confcall. But it stoped i go for looking.

Thanks and...

Thanks for you answere. Sorry but i don't understand what this Statement do.

case

when logindate = logoutdate then datediff(ss, loginzeit,...

Hey it looks like Great, but not so much work.

I need only the sum of the Time. Not the 25% or else i write this only fot understand. Here is...