First we'd need to know what you define as being "distinct"...

The sample data and your expected output is not clear enough on that.

My guess would be that this is a...

Josh,

based on your other thread you already have a DynamicCrossTab on almost the same data.

Just change how the temp tables are populated and adjust the column names in your dynamic...

What would also help if you simply could post the full error message. It usually tells the table and primary key that's violated.

And I don't think it's an issue with...

Oh, I finally got it...

In that case you'd...

*Ouch* Can't even count such a small string manually anymore. Is that...

Use a subquery to count the occurrence of Address fields and link that back to your original table for Address values with count > 1.

Assuming you can ensure the data structure you could use omething like LEFT(StringValue,LEN(StringValue)-11)

Both, 'large.jpg' and 'small.jpg' are 10 char long +1 char for the minus sign.

Jonathan Kehayias (1/4/2011)

---

I wouldn't use SQLCLR for this, I would use Service Broker and External Activation to solve this problem. You can find out more about the External Activator...

If there are values within a column containing commas, how do you know what values belong to one column and what values belong to the next/previous one?

Is there any chance...

GSquared (1/4/2011)

---

...

He basically asserted that there appears to be a geographic concentration on the subject of eggregious copyright infringement in the world of coding. He merely said that a...

Jeff Moden (1/4/2011)

---

...

As a bit of a side bar, I'm constantly amazed at how some folks apparently just don't give a rat's patooti as to how their code looks and...

Steve Jones - SSC Editor (1/4/2011)

---

For those of you setting weight goals, I'd discourage that. I think you ought to work on your health, and trying to get to the...

joshtheflame (1/4/2011)

---

Lutz,

Thank you for appreciating the way I've posted my data. Actually I've observed that ppl do not bother to provide scripts which is ethically wrong. Its the place where...

Here's mine:

Goals for 2010:

Professional

* Certification: has not been on my list, since recruiting over here does not pay that much attention to it. And if one does, I usually answer...

Anil Maharjan (1/4/2011)

---

hello all,

Well i am just wondering do this similar type of script works for the complex type node too for xml file.

which we can find the XML...