Mangal,

Justify for me why I should use your recursive CTE in place of Bob's solution. I have tested the two side by side, and I find Bob's solution to...

I have to admit that I am not really a Saint. I just have made a decision that if I am going to try and help someone, I am...

Looks like CrazyMan chose this thread to work in, so please direct comments and suggestions there.

Mangal9i (3/6/2009)

---

Yes my query little slow.

Talking about execution plan, run both my query and your query and see cost of the query.

Its 1% VS 99%.

I was not aware that someone...

I'd be curious to know if Mangal has bothered to check his original thread. What had turned into a "heated discussion" on a reply he had made to Steve...

Eyes, hurt.

I need to thank everyone who provided suggestions and guidance on this problem. There were some missing files that i needed to find and replace in the Windows/Installer...

GSquared (3/6/2009)

---

Roy Ernest (3/6/2009)

---

I was not able to check this thread much yesterday since I had a late night shift the day before. I check today morning and this thread...

I have been following this thread since it started. It is now 54 posts long and I am getting a little confused and I really don't feel like starting...

t.walker (3/6/2009)

---

OK, there are some great points here and perhaps I was being rather uncharitable when I wrote it. It came off the back of trying to research an issue...

Chris Morris (3/6/2009)

---

karthikeyan (3/6/2009)

---

Thanks a lot to all.

I just wanted to know what about my solution? won't it be a god solution? I think 'YES'. Becuase i have used UPPER...

Nah, this thread is too short for that. Now...

Oh, geez, great. Now Queen and the theme from Flash Gordon are going through my head....

I'm not knocking using a partitioned view. Your right, it takes a lot more planning and testing but can be accomplished.

It really comes down to what the OP can...

Have you noticed, but we actually have a discussion going on here now.

Would be a good way to go, but the how will depend on what edition of SQL Server 2005 is being used. If Enterprise Edition...