'Zactly... 🙂

Oblio Leitch (12/8/2008)

---

Jeff,

That looks pretty good, but I was just working with a reduced dataset as an example. I need to expand it to use groups of IDs. ...

rbarryyoung (12/8/2008)

---

Dang, every time I see that "NOT EXISTS using a JOIN" trick, I think that it's a No-Op and I take it out... 🙁

Anyway, this corrected version gives...

rbarryyoung (12/8/2008)

---

Kris (12/8/2008)

---

The reason it must dragged into a spread sheet is because researcher want to be able to extract the data from the DB and perform statistical analysis on...

No... it's not... not if it has a cursor in it. 😉 But, if you would rather do that than posting the...

Heh... yeah... use the CrossTab code instead. 😉

The reason it must dragged into a spread sheet is because...

You need to check the output on that... 😉

Kris (12/5/2008)

---

Revised post:

Is it save to assume that both Pivot and Cross Tabs preform better than tabulating the data from a view that inner joins the table on itself for...

You bet... thanks for the feedback.

Bob Hovious (12/7/2008)

---

Jeff, I would never have thought to use parsename on an IP address, but it makes perfect sense because it has four elements separated by periods. ...

leonp (12/7/2008)

---

Thanks a lot you all!

To Jeff's question -

T_r data is never truncated - it has a few DMLs issued very infrequently

To Gail/Krishna's question -

As I understand, since...

Patricia Monreal (12/7/2008)

---

Thank you for your detailed reply. I think I understand what you are saying when you say that I am thinking procedurally and not terms of sets. I...

You bet... thanks for the feedback.

S'ok... Heh... not much coffee at night. 😛

Replace the derived table in the from clause with your real table...

SELECT PARSENAME(d.IpAddr,4) As ColA,

PARSENAME(d.IpAddr,3) As ColB,

...