Great, you like CTE's. Guess what, Bob's solution is also a CTE. What we are trying to get you to understand is that just because your solution works,...

t.walker (3/6/2009)

---

I really support that idea. I think a more private invited members forum would enable me to speak more freely/

Although I am a rookie here, I am also a...

I can't see an exclusive thread or forum really working here. If that's what it would take for someone to feel comfortable here at SSC, maybe this isn't the...

Jeff Moden (3/6/2009)

---

Lynn Pettis (3/6/2009)

---

Not the request I made. I know which I'd use. I want Mangal to justify to me why I should use his solution even...

CTE (3/6/2009)

---

You should use Bob's solution, best way create Time dimension and use it.

One question came, I given 1 solution, which is not that bad, another person gives another solution,...

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...