VegasL (1/22/2016)

---

Hello,

I am trying to combine multiple sets of tables and then compare with not exists, this query doesn't return an error, but also doesn't return any results, which it...

Lynn Pettis (1/22/2016)

---

WayneS (1/22/2016)

---

Brandie Tarvin (1/22/2016)

---

Okay. This is driving me batty.

New code (with datatypes fixed) works fine ....

(code snipped)

...until I remove that damn driveletter column.

(code snipped again)

Where it fails on...

A couple quick cautionary points:

1) Lowell's idea works nicely for this, just be careful with implementation since the scope of the *100 is incorrect. As written it multiplies the denominator...

Brandie Tarvin (1/22/2016)

---

Okay. This is driving me batty.

New code (with datatypes fixed) works fine ....

Where it fails on that DBFileName error again. (and yes, I deliberately left the DEFAULT columns...

drew.allen (1/21/2016)

---

J Livingston SQL (1/21/2016)

---

here is a start

https://msdn.microsoft.com/en-us/library/ms189461.aspx

am trying to find the source that demonstrates the efficiency of using "unbounded preceding"...I have it somewhere <grin>

will post back if...

Just for clarification, it looks like the primary key is just on database_id and object_id; schema_id is not included. I don't think that's the issue, though.

One way I know this...

That's because ROUND doesn't actually remove digits. It will just round the value to that place, leaving the current scale in place (i.e., ROUND(1.12345,2) is 1.12000, not 1.12).

Because of the...

I don't default to a non-zero value, but I don't really default to any particular value, unless the server has >8 cores, in which case I'll default to 8 (partially...

If all we care about is the max date for each ID, it should be close between those and the CASE, if the CASE version is also modified to only...

Eirikur Eiriksson (1/20/2016)

---

Jacob Wilkins (1/20/2016)

---

I agree that using ISNULL would make it read a bit better. My main concern with that was general applicability, particularly, what do you replace NULLs...

Eirikur Eiriksson (1/20/2016)

---

Jacob Wilkins (1/20/2016)

---

Eirikur Eiriksson (1/19/2016)

---

Jacob Wilkins (1/19/2016)

---

Throwing in the CASE using Eirikur's wonderful setup yielded this on one million rows on my machine (tangentially, I'm embarrassed that Eirikur's...

Eirikur Eiriksson (1/19/2016)

---

Jacob Wilkins (1/19/2016)

---

Throwing in the CASE using Eirikur's wonderful setup yielded this on one million rows on my machine (tangentially, I'm embarrassed that Eirikur's laptop is faster than...

rarara (1/20/2016)

---

Hi guys, thanks for your input. i didn't include every detail for fear of getting bogged-down in process. In terms of what is currently running through the night we...

I seem to remember someone...

Jeff Moden (1/19/2016)

---

Jacob Wilkins (1/19/2016)

---

Eirikur Eiriksson (1/19/2016)

---

aaron.reese (1/19/2016)

---

@jacob and @jeff

SSRS is not my natural home 😀 so I was not aware that IIF(x AND y) is a bitwise operation. ...