Sometime in the somewhat recent past somebody shared a story about a company that went belly up due to their triggers not supporting multiple rows. I brought this up in...

dwain.c (5/10/2012)

---

Sean Lange (5/10/2012)

There was a story in another thread a few months ago by one of the regulars about a company that went belly up because their triggers couldn't...

dwain.c (5/11/2012)

---

vinu512 (5/11/2012)

You've nailed it Dwain. All this time I was thinking that I have done this before but wasn't able to remember how I did it. I tried everything...

sabercats (5/10/2012)

---

This one i made up per your team request. I did not test with sandbox ?

CREATE TABLE #Testing

(

Location varchar(255),

OS varchar(255),

Starttime DATETIME,

Endtime DATETIME

)

INSERT INTO #Testing

(Location, Starttime, Endtime)

SELECT 'tampa','win7','2012-05-01 12:56:27.000','2012-05-01...

Here is the sample ddl all cleaned up and ready to roll.

CREATE TABLE #Testing

(

Location varchar(255),

OS varchar(255),

Starttime DATETIME,

Endtime DATETIME

)

INSERT INTO #Testing (Location, OS, Starttime, Endtime)

SELECT 'tampa','win7','2012-05-01 12:56:27.000','2012-05-01 13:39:22.170' UNION ALL

SELECT 'tampa','win7','2012-05-01...

Actually Lynn that part is fairly easy to correct. The real problem is the OP wants help with the original query and did not provide any details about the original...

themangoagent (5/10/2012)

---

I didn't think you were trying to irritate me, Sean. To be faire, I did initially include most of the details you requested. I know that it's not easy...

themangoagent (5/10/2012)

---

Like I said, it's de-normalized. It has fields like ID, Value1, Value2, Value3...Value12, where Value should be in its...

Well it is tough to help with performance problems without some details. Things like what does the table look like? What is the desired output? What does the query you...

Hi and welcome to SSC. In order to help you need to provide some information. Please see the first link in my signature for best practices when asking questions.

Eugene Elutin (5/10/2012)

---

Sure, and there is no way to...

WayneS (5/10/2012)

---

Hey Threadizens,

Regarding today's (10 May 2012) QOTD: several folks have stated that it could have been worded better. My question to you is how would you have worded it...

Your best bet is probably to hire a local consultant to come help you. There are so many things that COULD be the problem. This is likely way beyond the...

Your question is not very clear. I can however suggest a much fast string splitting function than the xml based version you posted. Take a look at the string splitter...

Hands down your best approach is to get rid of the cursors all together. Then you don't have to worry as much about performance issues like you are having. Are...