Tom.Thomson (7/22/2010)

---

peter-757102 (7/22/2010)

---

I find this sort of thing many more times disturbing/dangerous then using a quirky update deliberatly and with full knowledge and documentation. Why? Because I suspect hardly anyone...

peter-757102 (7/22/2010)

---

Mike C,

I understand you point, I hope you can see mine too. In fact I never used the querky update anywhere as I never needed it. But more demanding...

Jeff Moden (7/22/2010)

---

Mike C (7/21/2010)

---

Well... I've seen multirow string concatenations return completely incorrect results before based on simple things (like table indexes) at the whim of the optimizer. No...

peter-757102 (7/22/2010)

---

Mike C (7/21/2010)

---

Jeff Moden (7/21/2010)

---

Gosh, Mike,...

Jeff Moden (7/21/2010)

---

Gosh, Mike, I'm not sure...

Jeff Moden (7/21/2010)

---

Gosh, Mike, I'm not sure...

I'll have to look a little closer at that one tomorrow. Is multirow variable aggregation as unsafe as multirow string concatenation?

kjc-1057161 (7/20/2010)

---

Btw, the bits I've trimmed out from first time around are to do with when the interest calculated is < 1 - in this case, the precision is kept...

kjc-1057161 (7/19/2010)

---

I've got a horrendous cursor problem, to do with calculating interest owed on accounts. The summary is that rather than use a simple calculation to work out the interest,...

slavut (7/5/2010)

---

Skipped overquotes.

Mike C (7/5/2010)

---

Here are a few reasons why XPs are deprecated:

1) Extended stored procedures run as unmanaged code in the SQL Server process space. They can...

slavut (7/5/2010)

---

Although I'd like to hear reaction of author of article, nontheless thanks for reply.

Mike C (7/3/2010)

---

Well to start off, I would suggest that many authors often start off by...

mschroeppel (7/4/2010)

---

I also found this article rather insulting. I almost never use cursors. In fact, I think I should use them more. I sometimes find myself dong mental jujitsu, trying...

There are times when I recommend a T-SQL cursor over the alternatives, but they are few and far between. The issue though seems to be that there's a feeling...

You bring up...

slavut (7/2/2010)

---

4. To be more constructive, let me introduce real life example. Let's say you are stockbroker's progammer. Let's say that your clients make 100000 deal per day by 10000...