Honda is not on your list either. I am the soccer dad driving an Odyssey. It works great for family outings, sports events and cub scout trips.

My apologies. I did not want to burst your bubble or indicate that the work you put together is not good. It just isn't...

I am happy you are figuring this out. I am however sad that you were shown so many non-cursor based ways to do this and yet you chose to use...

Not sure they will see this. This was posted nearly 5 years ago and the poster has not logged in since then. 😀

Ed Wagner (2/1/2013)

---

It seems like maybe what you really need is an appointments table. You can figure out the open time slots using the gaps and islands logic. In other...

ScottPletcher (2/1/2013)

---

I like the technique overall, but the concatenation will likely hurt performance: maybe only slightly, maybe a lot, depending on indexing. Thus, I suggest GROUPing and JOINing w/o...

That is quite similar to what I posted. I would recommend removing the nolock hints. They serve no purpose and run the possibility of making things bad...very bad.

No problem. Glad that worked you and thanks for letting me know. Have a good one.

Is this maybe what you are looking for?

select d.*, DupeCount

from @DuplicateMembers d

join

(

select FirstName + LastName as FullName, count(*) as DupeCount

from @DuplicateMembers

group by firstname + lastname

having count(*) > 1

)...

I can help with the duplicates thing, that is fairly simple. What I don't understand is your desired output.

1000256242 Don Baker 1

1000145408 Don Baker 2

4277648 Mike Gibson 1

80656 Mike Gibson...

What I mean by one row is your sample data is only 1 row. It is a long string with a bunch of html tags in it.

I added another twist...

paul.j.kemna (2/1/2013)

---

I don't get what "operator" is in these examples. I would also prefer to not use the splitter function.

I am to the point where i may have to rely...

It seems...

With no more details than that I will suggest you to look at the article in my signature about cross tabs. It will explain how to accomplish this.

If you...

Kasinathan (2/1/2013)

---

Hi i need to calculate the TAT in my application. i am having date like this :

InTime ...