Being at work right now, can't take the time.  If I can, I will see what I can do from home if some else hasn't already jumped in to help.

I signed up for the CTP.  Guess I'll start "playing" with it shortly.

Try this:

update dbo.mytable set

    mycolumn = replicate('0', 6 - len(ltrim(rtrim(mycolumn)))) + mycolumn

where

    len(ltrim(rtrim(mycolumn)) < 6

First thing I would do, rewrite the query for SQL Server 2005.  I'd use CTE's to replace the derived tables in your query and I would use ANSI standard join...

I would say no.  I was asking Microsoft that question myself as we have been having performance issues on one of our SQL Server 2005 systems and that question was...

Actually, the DTA's recommendations did help general performance of the system.  It recommended 36 new indexes that when implemented were beneficial to overall performance.  We still had issues at times...

Regarding our issues, we finally broke down and called Microsoft for help.  While we had a tech on the line we found one thing we had not looked at or...

I have nothing to admit to being wrong about, nor do I have reason to apologize.

As you have stated in several posts in this thread, you haven't answered my question. ...

Unfortunately, no.  From BOL: Backups created with Microsoft SQL Server 2005 cannot be restored to an earlier version of SQL Server.

Dave J.

Okay, I agree.

Lynn

Huh?  This started as a topic on a Bankers Rounding function, and then you ask what day do you consider a transaction occuring when it occurs at midnight?  What does...

You changed the subject when you brought up midnight.  We are no longer talking about the bankers round function.

Okay, I can't stay out of it any longer.  David, you have put up a good argument, but it is time to end it.  No matter how much we try...

mengus,

Took a bit, but I see where you are coming from.  It looks like a case of semantics between your modification to my solution.  In mine, I choose to round...

I'll have to see if I can find a copy of Ken's book.  Your explaination helps, but to get a better understanding, perhaps additional books are worth the investment.

Thanks.