Kludgy as heck, but it seems to give the desired results. :hehe:

CREATE TABLE #a (AFFILIATIONID varchar(20),

...

I can work with "it doesn't matter". Give me a few minutes to slap together some code.

I can't see why that would fail when you insert the output into a table that has decimal(5,2) for that column's data type.

Try doing a SELECT INTO... and seeing if...

j21283 (5/25/2016)

---

I'm hoping some folks might be able to help out with a poor performance situation for our SQL server.

We recently did a major system upgrade from SQL 2008 and...

Here's the test setup if someone else wants to pursue this.

CREATE TABLE #a (AFFILIATIONID varchar(20),

...

DECIMAL(5,2) can store 5 total digits. 140 * 100 is 140000, or 6 digits.

Try using bigger decimals in the equation then casting final output to 5,2.

If you go the HASHBYTES method (which I too have used in the past for large-scale data loading processes), consider using SHA or SHA1 instead of MD5 for a bit...

Can you post the full create table definition of the table, including all the indexes?

Also, do you have any triggers on the table? If so post those up too.

Are you...

select *

from tableA a

where exists (select * from tableB b where a.ID00 = b.ID00 and a.OBJECT00 = b.OBJECT00 and a.FIELD00 = b.FIELD00)

BTW, your sample data isn't really helpful. When you...

Do you have any triggers (especially auditing ones) on the table?

Is the column you are adding NULLABLE?

Has your log backup job been failing? At least 50% of the clients I visit have jobs failing and they don't know about it because they didn't enable Database Mail...

Jeff Moden (5/23/2016)

---

TheSQLGuru (5/23/2016)

---

Jeff Moden (5/23/2016)

---

What kind of problem?

Also, why are you wasting valuable...

I thought that error message was related to OFFLINE database state.

Check sysdatabases and sys.databases to see various state flags for the database of concern.

Jeff Moden (5/23/2016)

---

What kind of problem?

Also, why are you wasting valuable SAN space to...

Shelley Allen (5/23/2016)

---

I have a DB that is 1.81TB. Normally when a FULL backup is done, the .bak file is over 1TB. However, when I do a Full...