Forgot to comment on the article :hehe:.

I thought the article was very informative, easy to read/understand, and offered great alternative methods to solving the "running total" enigma.

Nicely...

Lynn Pettis (1/27/2009)

---

I am sure this is in response to the following:

I received a private message with a...

TheSQLGuru (1/8/2009)

---

Peter, I couldn't really follow the code you had. Was it supposed to be just separate batch files or was some/all of it supposed to be wrapped up...

Peter,

I love how you only return the totals in the first row of the output. this will definitely reduce the amount of data being returned to the application. ...

TheSQLGuru (1/7/2009)

---

phystech (1/7/2009)

---

No, zero length string plays the role of NULL. That is if...

phystech (1/7/2009)

---

TheSQLGuru (1/7/2009)

---

phystech (1/6/2009)

---

Adam Haines (1/6/2009)

The optimizer knows that

"CASE WHEN @FirstName IS NOT NULL THEN"

can be evaluated before the query is launched, since no column name is involved...

phystech (1/6/2009)

---

Adam Haines (1/6/2009)

---

phystech (1/6/2009)

---

What can we do to make this query index seek? Well, we really only have two options. One is to use dynamic sql to...

noeld (1/6/2009)

---

Although the article is well written but I have a word of advice. For very large tables row_number() over().. has been inefficient for me when it comes to...

Bryan Smith (1/6/2009)

---

Adam I agree with your statement on using Control Logic (and great article btw). I'm curious though, using this method have you run into problems with queries plans....

phystech (1/6/2009)

---

What can we do to make this query index seek? Well, we really only have two options. One is to use dynamic sql to build the predicate...

TheSQLGuru (1/6/2009)

---

2 points to add:

1) If you are going with dynamic sql, the go completely with it. Constructs such as this:

...

alessad (1/6/2009)

---

Adam, why you dont'use the order by in the final select? (.... order by Row_ID).

Otherwise there is no guarantee that the records are always sorted correctly, what do you...

Thanks Steve.

rakhi.bhatia (1/6/2009)

---

I have a question about the dynamic SQL block of code you have included in your article.

So the way you have constructed your dynamic SQL, you took @FirstName and...

peter (1/6/2009)

---

First impression....a lot of code (and a lot of work).

I do not have the time to read it the lengthy article in full but as the OP rightly articulated,...