Really enjoyed this article, it explained the use of the CTE very well. Great work as usual Jeff.

Definitely needs more testing, thanks. It will give me something to think about today 🙂

Great article. It got me thinking, which first thing on a Monday morning is usually impossible! 😀

I rewrote the CASE statement, though I haven't extensively tested this - found a...

Trevor R Udden (9/13/2010)

---

Odanwada -

Did I miss a major citiation at the end of your article? You might want to try not blantly plagirizing others work. The...

I like it, but what's the cost of running this on a production server?

I'm testing Microsoft Reporting Services and using the database provided, this works:

SELECT DISTINCT a.AddressId, a.AddressLine1, a.City

FROM   Address a

INNER JOIN Address b ON a.City LIKE '%Ken%' AND b.City LIKE '%ken%'

Not sure...

So would you just use  CREATE INDEX  after creating the table ?

David - table variables are stored in memory, if you search in books online under table variables, you will find some help on them. It looks like microsoft would prefer...