So what happens next when someone comes along and runs:

INSERT INTO @PhoneTable_New

(phone, phonecount, contactname, contactnamecount, tablesource)

SELECT '003', '0', 'Mr Jones', '0', 'contactperson'

Do...

Stefan Krzywicki (8/21/2012)

---

dwain.c (8/21/2012)

---

It has been a rare experience for me to post a question to this forum, but I will now. How about a poll?

Yesterday I was called...

Steve Jones - SSC Editor (8/21/2012)

---

Brandie Tarvin (8/21/2012)

---

At my workplace, we forbid the Devs to use cursors. It's part of our db standards. Any time they want to go against...

WayneS (8/21/2012)

---

dwain.c (8/21/2012)

---

It has been a rare experience for me to post a question to this forum, but I will now. How about a poll?

Yesterday I was called upon...

SQL Kiwi (8/21/2012)

---

dwain.c (8/21/2012)

---

Rest assured that if I ever encounter a case where a CURSOR out-performs a set based solution, I'll happily use it. In this case, I believe...

SQL Kiwi (8/21/2012)

---

dwain.c (8/21/2012)

---

Rest assured that if I ever encounter a case where a CURSOR out-performs a set based solution, I'll happily use it. In this case, I believe...

Jeff Moden (8/9/2012)

---

Wow! That dude that won XDBA last year? He looks OLD! 😀

I have to tell you that if you haven't gone to one of these...

GilaMonster (8/21/2012)

---

<soapbox>

Cursors are tools. Use them where they work, don't use them where they don't. Statements like 'you should never use a <whatever>' are just shortsighted

If we count while loops...

ChrisM@Work (8/21/2012)

---

dwain.c (8/21/2012)

---

It has been a rare experience for me to post a question to this forum, but I will now. How about a poll?

Yesterday I was called upon...

You don't actually need to split the strings as long as they're all unique and don't contain substrings of each other:

;WITH SampleData (UserID, WhatTechnology) AS (

SELECT 1,'home,car'

UNION ALL SELECT 2,'home,car,dj'

UNION...

The first thing that I would do is improve the readability of your query (slightly) by rewriting it as:

;WITH main AS (

SELECT pat1.PatID, pat1.DocID, pat1.Site, doc.RefDate, doc.Report

FROM PatMapTable AS pat1...

Will this work for you?

SELECT acc_no, [count]=COUNT(number), c_name=MAX(c_name)

, R_Value=SUM(R_Value), time_spent=SUM(time_spent)

FROM #TESTING

GROUP BY acc_no

Not sure but you may be able to do something like this assuming there is no overlap in dates in your @Vehicle_Depreciations table:

;WITH Tally (n) AS (

SELECT TOP 1000 ROW_NUMBER()...

It has been a rare experience for me to post a question to this forum, but I will now. How about a poll?

Yesterday I was called upon to go...

Great article Gus!

I haven't had a chance to play around with HiearchyIDs myself yet but I must put it on my agenda to try it out. And your examples...