Any way you do it it has to be logged, there is no way to turn it off. The best thing you can do is to perform the insert...

No idea. It is your data, you have decide if the data can be modified or not. If not, then you will have to go with a larger...

Here is the problem, you are going from this:

123456789.01

to this:

12345.678901

Unless you are absolutely sure that no values in this column is greater than 99999.99, then what you may need to...

Try changing it to DECIMAL(15,6) instead of DECIMAL(11,6).

Double post, please reply here.

Jeff uses it when creating his million row test tables.

Please show your code. A little hard to help when we can't see what you've done.

Alvin Ramard (11/12/2009)

---

CirquedeSQLeil (11/12/2009)

---

Alvin Ramard (11/12/2009)

---

At first I thought...

I wouldn't. Seems like a general observation that I would actually agree with. 😉

Two things.

First, based on the data provided, what is the expected output from the update?

Second, could you please show us what you have done so far to solve your problem?

Funny, but when I compare the execution plan of...

And Lowell is correct, proper formatting of your code will help you find syntax problems, like missing END's for CASE's or parens, etc.

White space is your friend, not your enemy.

Geez, Lowell, you take all the fun out making the OP tell us what the problem is... 😉

dba.nivali (11/12/2009)

---

select (case when substring(svc_ord_nbr,1,1) = 'V' and svc_ord_nbr like '%COG%' then 'VIDEO' else

case when substring(svc_ord_nbr,1,1) = 'Z' and svc_ord_nbr like '%COG%'...

ROTFLMAO !! :w00t: