Do you want to update the base tables through the view?

See if this helps you:

http://www.sqlservercentral.com/Forums/Topic667087-145-1.aspx#bm667120

You can find more details in Itzik Ben Gan's "Inside Microsoft SQL Server 2005— T-SQL Programming" - part of the Chapter 1 deals with the datetime "nuts and bolts"...

Try

...WHERE trade_date = '20090306'

Can you try to uninstall MSXML 6 and install SQL Express again?

See if this helps:

http://www.satheeshmohan.com/Blogs/Default.aspx

You can also try to adjust this example:

http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express

It's based on service broker...

Lesson learned...:)

Paul, Gail: I'm sorry. I should have been more specific (links...) and less cautious ("never"...). I feel really sorry about this.

As far as I know,...

Please post your code.

You may also consider upgrading to SQL 2008...

As GilaMonster said, you should NEVER use DBCC REBUILD_LOG. Do you have any backups? How old are they?

See also http://sqlskills.com/BLOGS/PAUL/category/CHECKDB-From-Every-Angle.aspx

You can find some valuable advice here:

http://sqlskills.com/BLOGS/PAUL/category/CHECKDB-From-Every-Angle.aspx

GilaMonster (11/27/2008)

---

I started posting on this forum because I wanted to improve my own SQL skills, and trying to figure out other people's problems seemed like a good way to...

You're welcome. You can start learning the "nitty - gritty" with Adam Machanic's tutorial on http://www.simple-talk.com/sql/learn-sql-server/.