Knut Boehnert (4/18/2013)

---

Sure enough, in this simple example dynamic SQL is better because of the evaluation of @Param1, @Param2 and @Param3 - I fully agree with this.

However the SQL in...

Thanks, it's an interesting approach.

Just one question: Have you tested index use with this approach?

The reason I ask is that some years back I would construct WHERE clauses as follows:

WHERE

...

Neil Thomas (11/16/2012)

---

I'm obviously having a dense Friday.

How does the explanation (all about @@error) relate to the question: "What is returned from #tblTrans when you run the below code:"...?

I'm not...

PaulB-TheOneAndOnly (3/11/2011)

---

LightningFingers (3/11/2011)

---

One possibility seems to be to create a .bak file for the database. But we've run into issues with collation when moving .bak files between servers that aren't...

L' Eomot Inversé (11/7/2012)

---

use some error reduction technique which is likely to involve something like sorting the numbers (on magnitude, ignoring sign) and eliminating cancelling pairs before doing any arithmetic...

L' Eomot Inversé (11/5/2012)

---

Up to now, nothing nasty. I'll have to address the rest of your post in a separate message, because I don't want to mix the civilised...

Steve Jones - SSC Editor (11/1/2012)

---

Interesting discussion. Freedman does mention inserts and deletes, but he never wrote on the subject. Perhaps he was mistaken, perhaps he hasn't had time. The...

L' Eomot Inversé (10/31/2012)

---

This probably a pointless argumnent, because it isn't about anything technical, just about historical and terminological accuracy, and it does appear that quite a few people have...

L' Eomot Inversé (10/31/2012)

---

craig 81366 (10/31/2012)

---

GilaMonster (10/31/2012)

---

No, the Halloween problem is exclusively for...

vk-kirov (10/31/2012)

---

"Delete a row multiple...

GilaMonster (10/31/2012)

---

No, the Halloween problem is exclusively for updates. You can't insert or...

bitbucket-25253 (10/30/2012)

---

Meow Now (10/30/2012)

---

One good thing about this question, I learned about a new feature in 2012. I missed the question, like most, because I made an assumption that the...

ben.norris (10/30/2012)

---

Hugo Kornelis (10/30/2012)

---

First: It does. The CREATE TABLE script does not include a NOT NULL constraint, so the columns are all...

L' Eomot Inversé (10/30/2012)

---

Nice to see a question about a new feature in sql 2012.

I took a guess as to what the code was intended to be, and got it...

Lokesh Vij (10/30/2012)

---

USERID USERNAME SALES

------------------------------

5 XRay ...