OMG!

Fricking case insensitive, I was returning all caps as stored in the db, default countyname in the included maps are proper case.

Oh well, at least I figured it out.

Thanks...

Ha! I especially like the 405

Stefan Krzywicki (12/15/2011)

---

I haven't used these before, but I'm guessing the third image is where there should be color, but isnt? Is the query that populates this map returning data?...

Stefan Krzywicki (12/15/2011)

---

Stefan Krzywicki (12/15/2011)

---

I haven't used these before, but I'm guessing the third...

Little help here, SSRS 2008 R2 analytical color map...but not in color? can't figure it out

Dev (12/15/2011)

---

Brandie Tarvin (12/15/2011)

---

Not quite. If you don't refresh the page,...

Greg/Robert, just found a great example of the cost of order by here at work. I was wondering what you meant exactly, now I totally get it. Thanks!

If you have a linking column, which I'll assume you do, you can use a Lookup to pull the data from the second dataset.

Hugo Kornelis (12/14/2011)

---

jcrawf02 (12/14/2011)

---

I was under the impression that SQL always looked in master first for sp's and tables if you do not specify a schema, is that only true...

Oh, and if you're going to create a dashboard for someone, please, please, please don't use gauges or pie charts like the picture on this post. Especially when the parts...

Matt Miller (#4) (10/26/2011)

---

This is the very premise I don't agree with. Most...

Koen Verbeeck (12/14/2011)

---

I don't remember that. Is it from one of the movies, or from...

Ninja's_RGR'us (12/14/2011)

---

Pork chops is a projectile thrown in the face of someone who uses cursors, rbar and other forms of bad sql.

Kind of a more efficient and longer distance fish...

First, nice article, great coverage of the topic. Couple things worth mentioning:

1 -

One reason why you might use the ordinal position in your ORDER BY clause is when...

Hugo Kornelis (12/14/2011)

---

An interesting find, Ron.

What's even more interesting is that you get data from the table in master even if the current database has a different table with the...