Jeffrey Williams (7/10/2009)

---

I could see a different execution plan being generated - but not different results. Both queries should return the same results and the fact that they are...

egads! apparently I just found another bug with the code="SQL" windows....

here they are in plain text...

Q1

SELECT *

FROM Tab1 t1

INNER JOIN Tab2 t2

ON t1.[Identifier] = t2.[Identifier]

INNER JOIN...

No, haven't flushed the cache, I have only been able to id the problem on my Prod instance at the moment, I'm waiting on a maintenance window this weekend to...

Lynn Pettis (7/10/2009)

---

Lynn Pettis (7/10/2009)

---

That's because we don't have the data to see what is going on behind the scenes. I'll wait and see what Luke comes back with...

Right, that's my issue with it also. At first I thought it was the where vs join issue... but all fo the filtering is being done in the where...

Positive, if I run both queries in the same batch, I get 2 resultsets, one that's blank and one with 2 records... It's not that I'm dealing with 100's...

Kit G (7/9/2009)

---

GilaMonster (7/9/2009)

---

I suspect the lack of emails...

Same experience here. Yesterday right after the outage, posting a reply gave me the full error details. I didn't save them as I figured the site wasn't all...

I've not actually seen the scripts anywhere, also only the .MSIs. What kinds of issues are you seeing with the MSIs? Perhaps we can help?

-Luke.

OK, who tripped over the power cord!

Perhaps it's not a cookies thing, but I suspect that it is... Currently I'm using FF3.0.11 WinXPsp3, but the same thing happens at home with Vista and at other locations...

The really sad thing is I had to really expend a fair amount of mental energy to try to understand what half of those words were...

Sheesh..

Sorry I just re-read my original post, that should have been the past few weeks... It seems to happen when a) I'm on a PC I've never used before, or...

The body of your report looks OK. Can you upload the entire Rdl? That may be more helpful.

Thanks,

-Luke.

Have a look at the attached XML. It's from the Body of the RDL I wrote that does exactly what you are requesting. check for differences between what...