Got it working fine with a variation on the setting database OFFLINE suggestion by jdenicola. I am setting the database into SINGLE USER mode prior to the install and...

Lynn,

I will do both and thank you for your feedback and help to this point. I truly do appreciate it and am not trying to be difficult. I...

Does the index have to be unique? The dataset that I am working with holds time data for a whole week for all employees across the company. As...

Thanks to all!! The @NewDateTime = [time_entrydate] = was the part that I was missing. I could not get the thing to re-assign the new values. As...

Sorry, thought I posted that. The DB is running on SQL 2000 but if this is going to be extermely difficult to accomplish I can probably move it to...

Sure thing.. my apologies for confusion. First time positing something like this. I have simplified to the following and included the update query that I am attempting to...

The previous row contains the original value that I want to add the value to. Here is how the logic should go:

1. orginal = 8:00AM

2. Add .5 hours, so...