Drew Allen & Eirikur Eiriksson,

Thanks a lot for your replies.  I really appreciate your efforts. 

I have been able to test the solution provided by Drew Allen...

Jack Corbett (8/18/2014)

---

As far as index sizes, there certainly are cases where an index can be nearly as large as the base table itself, and I'd argue that...

Table partitioning - one of the solutions suggested above really had me excited for a minute. Then I realized that we were on SQL 2005 Std edition for 64...

Thank you for all your suggestions. I shall start considering all the options presented. I will be working closely with our Product vendor on this and so hopefully we...

I have found a solution of sorts for this issue. It is quite messy with a couple of temp tables etc but it appears to work. I am...

Hi Jeff,

I do understand the fundamentals of your script. I understand your concern regarding employees who login in the afternoon and log out early the next day morning. ...

Hi Jeff,

Your script worked like a charm. Thanks a lot.

Sudarshan.

Hi Jeff,

Thanks a lot for your post. This should work just fine. I shall try this out on our server tomorrow and update you about the results.

Cheers

Sudarshan.

Hi,

I posted this file yesterday. Can't understand why it does not appear today.

Anyway, the attached file has the scripts to create and populate a table that is a replica...

True. But the problem is that the IN time and the OUT time are not on the same row. My difficulty is in getting the IN time for...

Hi Jeff,

Lobbying for a change in the clock design is not an option at present. I am stuck with this clock and I now have to work out a...

Hi Jeff & Pietlinden

Thanks to both of you for your tips. Using these, I have written this code that provides me with the time in and out for a...

One additional piece of information. This server was renamed after SQL 2005 was installed. I then dropped the sql server and recreated it using the following commands

sp_dropserver <old_name>

GO

sp_addserver...