GilaMonster (9/22/2012)

---

In case I tested, it's an index scan, well, I'm asking for the entire table bar one value, so makes sense to do it that way. If you look...

Nils Gustav Stråbø (9/22/2012)

---

Instead of just saying that scalar functions usually should be avoided, show them why. A screenshot from Profiler with thousands of call to the scalar function for...

Nils Gustav Stråbø (9/22/2012)

---

Why? What would you use instead when you need this form negative logic? When an...

Jeff Moden (9/21/2012)

---

The following isn't a bad suggestion but, unless you ccome up with a reassonable standard snippet of code for use in the CATCH block, you're going to have...

Thanks for the comments

This should probably be restated. What we're after...

I figured it out. Sorry everyone, but this one has had nothing to do with SQL server, and everything to do with the person behind the keyboard. I accidentally reversed...

No, and no

I'm running them...

OK, but remember that if I copy the query into SSMS and run it directly, it retuns all the expected results.

Yea, I know. I'm trying to come up with something generic that I can post that will reproduce the issue, but in the meantime, I wanted to see if I...

It's in one of the ON clauses that I replaced with "...". I don't think the exact statement in the ON clause is very important though, because it's a LEFT...

Yes, they are both using the same values. I have the parameters declared and I call both of them from within the same SSMS window, so i know all the...

I have no idea why your query doesn't work, but if you re-write it as follows, it seems to work fine.

WITH SALES

AS (

SELECT

...

You could also do somthing simliar with a tally table and a GROUP BY. I'm not sure which one will perform better, or if you even need it to.

I'm not saying that this will perform great, but something like this should work. You will have to expand the query to include the greatest number of columns that you...