sqlnoobie (2/28/2011)

---

sqlnoobie,

I wouldn't use this technique if I had to handle abbreviations, trademarks, etc. This technique works...

Natarshia,

You have to have some way to uniquely identity each row in each table in order to properly join to other tables or you will get multiple joins from one...

Michael,

You actually don't have to use the constants from your select statement in the GROUP BY clause. I know it's easy to just copy/paste them into the GROUP BY,...

Don't feel bad Rich. I once created a utility to concatenate script files into 1 big script and forgot to make sure there was at 1 GO statement between...

I would also very much like to see the code that didn't work. I've been using Wayne's technique and Jeff's Delimited8KSplit for a while now and those techniques have...

Thanks everyone for your comments. I should have mentioned in the article about Full Text searches in SQL Server.

As one poster mentioned, it's kind of a pain in the...

Gail Shaw did some interesting bench marks on this. I found them quite informative.

http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/

Todd Fifield

Jeff Moden (2/21/2011)

---

I use it all the time for such "threshold" situations (mostly total file size limitations, in this case) and there's nothing messy about it. It's all in...

Jeff Moden (2/17/2011)

---

Considering that a Quirky update and a cursor written to do the necessary previous row calculations are nearly...

eh936,

I'm curious as to exactly what the error message is then. I looked over my query and I can't see an error in it and I don't have Northwind...

James A Skipwith (2/17/2011)

---

Todd,

Nice article. I also have large calendar tables to deal with - as one of my clients uses a rolling four week cycle starting the first saturday...

ziangij (2/16/2011)

---

thanks for this post 🙂

One question - will it be good to add a column instead - say IsWeekEnd, IsWeekStart. Will it fare better or worse than the current...

Nicole Bowman (2/16/2011)

---

Thanks for the clear explanation. It is good to see a clean, simple way to implement a change in business rules without having to change reams of front...

Jason,

That means a lot to me coming from you.

Todd Fifield

Any time the order of processing records has to be considered while accumulating multiple values along the way, a cursor can be the easiest code to program and maintain. ...