Only if the OP provides the full requirements.

Rod Carter (5/26/2009)

---

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....

Nathan Davis (5/26/2009)

---

GilaMonster (5/26/2009)

---

What you could try is to put the tables that you don't care about into a different database and set it to simple recovery. Doesn't stop logging,...

In theory, yes. By running regularly scheduled transaction log backups, you will keep the size...

The simplest way is to setup a maintenace plan to accomplish this for you. Look it up in Books Online, it will get you started.

Are you attempting to accomplish this from your desktop system or are you logged on directly to your server?

Rod Carter (5/26/2009)

---

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....

Thanks, but there really is a lot more to the quirky update than is included in the post. It would be better if we had the full requirements for...

Nope. Regardless of recovery model, all inserts, updates, and deletes are first written to the transaction log. This is done to ensure the ACID priniciples are adhered to...

Based soley on your posted sample data here is some code to work with. This may need to be modified to meet your actual requirements.

DECLARE @time TABLE(time_ID int identity(1,1),time_entrydate...

Instead of an identity column, you may need a "sequence generator" instead to provide a unique ID value for inserts. In SQL Server this could be a single row/column...

I may have missed it, but what version of SQL Server are you using?

You aren't adding records to previous year data, are you?

Have you run a FULL BACKUP of the database yet? If not, you need to run it now.

Will Summers (5/26/2009)

---

Lynn Pettis (5/26/2009)

---

When creating a partitioned view in SQL Server 2000, you also need to place a constraint on each table that ensures a record belongs to only...