AM,

Ian is absolutely correct... for very small groups of rows by account, the example he gave will work just fine albeit a little slower than you may expect (just as...

Is that file path on the server... or on your desktop box?

"New" view, available in 2k5, is called sys.Objects and will likely be available in 2k8, as well.

I don't think I wrote an article on "DateDiff Usage"... so it would be interesting to find out how my name got on this...

Anyway, nice trick you've found. I...

And, maybe learn how to post sample data to get better answers...

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Heh... right there with ya, Gus... seems like the long way to spell "Death by SQL", though 😀

That should do it... nicely done, John.

You said that you wanted to pass parameters to the stored procedure in the trigger. That smacks of RBAR and single row processing which is a form of "Death...

Then, you need to post the exact code you're getting the error with and the exact error... because the code I posted gives no such error on my machine. ...

Radovan Jablonovsky (2/8/2008)

---

Hi,

If it is possible in your production environment to dynamically change number of processors, then it is OK. In our environment it is more conservative, therefore I am...

I absolutely agree, Matt... same thing goes with the SUM() OVER... they (MS) don't allow the necessary ORDER BY to calculate a running total using SUM() OVER like they do...

Which error? The one about conversion from char to date producing an out of range value? And, even if you fix that, you'll still end up with a...

VARCHAR(MAX)

Philippe Cand (2/6/2008)

---

Hello,

This article is getting unprecedented proportions.

How could we have MS SQL engine development database guys participating in the discussion If they are not yet already doing so...

Amazing... I've...