good question. thanks for sharing

Nice question thanks for sharing.

Well, Following is the solution after the understanding i get from your answers.

Please note that i have shared you SQL SERVER 2000 solution as this question is in ...

Well well well, a person start on 6 Am an end of next date 7 am. Gosh he worked to much. be very careful of Labor law my friend :-P.

Joke...

Nice question Steve. Thanks for sharing

Here is another solution, i borrowed 1st part of the solution from J Livingston SQL

i hope he don't mind it. For the sake of keeping it simple and all following...

This will give you some understanding. Check...

Well there are plenty of thing available here.

you can start with Stairways they are the best start from very basic and step by step they get to complex thing very...

Ayee !!!! 😀

You can achieve it using MIN() AND MAX() function for each person. Something like this

SELECT Name, MIN(LogDateTime) AS Min_LogDateTime, MAX(LogDateTime) AS Max_LogDateTime

FROM [YourTable]

GROUP BY Name

But question didnt state that you...

Glad to help and thanks for your feedback.

Well well well, you are using OPENQUERY so the temporary tables are thrown out of the window. I will not ask you to create a SP on each database, as...

Charmer (1/3/2016)

---

Thanks for the suggestion. I informed to my colleague and he said he is executing this script in an OPENROWSET. And it is going to execute in different servers....

Lets not make another issue here guys. C'mon ... Its the End of the year 😛 Celebrate it.

Keep up the good works and Thanks for 7 points Steve...

For the 1st part of the query, we suggestion have already been given, So i would be moving...