I am going to use a simplified set of tables to help explain what you are seeing.

create table dbo.TableA(

ID int,

CustomValue int);

create table...

Okay, I really need to step away from this person:

Welsh Corgi (6/8/2014)

---

Lynn Pettis (6/7/2014)

---

Welsh Corgi (6/7/2014)

---

That is sweet. I have the sizes stored in KB's. What statement could I used...

Just add the DDL and clarifications to this thread.

No need to start a new one.

Divide twice by 1024.0.

thomashohner (6/7/2014)

---

Jeff, I'm so sorry this may be a very dumb question but in your examples when the column is NULLABLE why is that expression wrong? I just tested it...

Not really sure what you are looking for here since we can't see what you see.

It would help if you could post the DDL for the tables involved (including index...

ScottPletcher (6/6/2014)

---

Lynn Pettis (6/6/2014)

---

sqldriver (6/6/2014)

---

sql-lover (6/6/2014)

---

It is my understanding that an aggregate function has to check all values in the column. So an Index on that attribute may not help...

SwePeso (6/6/2014)

---

See page...

sqldriver (6/6/2014)

---

sql-lover (6/6/2014)

---

It is my understanding that an aggregate function has to check all values in the column. So an Index on that attribute may not help too much.

Now, not...

autoexcrement (6/6/2014)

---

What are Col1, Col2, Col3, Col4, Col5, Col6, Col7, Col8? I don't mean the data types, but what are they? Are any of these columns a unique or primary...

valeryk2000 (6/6/2014)

---

Sean Lange (6/6/2014)

---

Not big on providing details today I see. What does this query return?

select @@VERSION

The bottom line is that there are hotfixes out there to deal with...

autoexcrement (6/6/2014)

---

Sorry Lynn, I wasn't sure DDL was necessary in this case.

Yes, we are importing data from an external source into Scratch, scrubbing it for dupes again Live, and...

Edit: Duplicate post, sorry.

It would help if you posted the DDL for the tables, some sample data for the tables and the expected results based on the sample data.

Do you insert data from...

SQLRNNR (6/5/2014)

---

Lynn Pettis (6/5/2014)

---

Grant Fritchey (6/5/2014)

---

Please, please, please, bestester behavior, no piling on of any kind (or I'll delete the posts and I can do that, BWA-HA-HA-HA, THE POWER!, ahem,...