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

Allister Reid (5/26/2009)

---

Hi,

I've tried solving this with quirky update method, but having some difficulties!

Can't figure out how to add index to table variable? create index throws an error,...

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 one table, for example...

Not quite.

BACKUP LOG [CHEMPAXDW] WITH TRUNCATE_ONLY

BACKUP DATABASE [CHEMPAXDW]

DBCC SHRINKFILE('CHEMPAXDW_Log',...

george sibbald (5/26/2009)

---

then...

Noticed you are using SQL Server 2000. Any chance of upgrading in the near future? Partitioned tables in SQL Server 2005/2008 would greatly simplify your problem, IMHO.