Is this what you are looking for?

CREATE TABLE dbo.table_1(

      id_1  int,

      id_2  int,

      id_3  int)

CREATE TABLE dbo.table_2(

      main_id           int,

      main_desc   varchar(250))

INSERT INTO table_1

VALUES(1, 2, 3)

INSERT INTO table_2 VALUES(1, 'Description 1')

INSERT...

Once we are comfortable with the system performance, I hope to be able to start rolling some out.  We were in a crunch to improve system performance, so had to...

JacekO, thanks for the catch on the missing paren.

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.