From the OP's other thread:

kaladharreddy15 (7/20/2009)

---

Hi Friends,

I need your help to display week number n that weeks startdate and enddate

This is my requirement...

This is a duplicate post. You still haven't answered the request for information here.

Please do not post further answers here, instead go to the thread linked above.

First, please read Gail's article on asking for help with performance tuning, it is the second article i reference below in my signature block.

A guess, you probably need an index...

On a totally different subject, I have actually seen several movies recently. Harry Potter and The Half-Blood Prince, Terminator Salvation, Star Trek, Transformers: Revenge of the Fallen, Angles and...

Still don't have enough information to make such statements. Could also be possible that they are trying to force users to communicate with the DBA's when extraordinary data modifications...

donato1026 (7/20/2009)

---

SELECT

CASE

WHEN ITM.MNR_CD = '100' THEN '15' AND

WHEN ITM.MNR_CD = '105' THEN '10' AND

WHEN ITM.MNR_CD = '110' THEN '5' AND

WHEN ITM.MNR_CD =...

tclaxton (7/20/2009)

---

I'm not confused. And I'm not saying this is the case, but I simply wanted to point out that the TONE made it seem like an article written by...

I think you should look at Lowell's first code block. That looks more like what you want.

Elliott W (7/20/2009)

---

{soapbox engaged} Is that really company policy or policy put in place by the DBAs themselves. Because most companies don't have a policy that sets the largest...

What are you trying to accomplish with the CASE statement?

Here is the code I came up with. Too bad I don't know what you have tried so far to solve your problem. It would have helped to...

adam spencer (7/20/2009)

---

What seems obvious after u have done it once (with your alls help that is)

relieves me, and keeps my feeling of stupidity a secret to u 'all and...

Again, another generalization. Bad things do happen, and have happened....

Matt, I have to agree, would you be willing to share your template?

Gift Peddie (7/20/2009)

---

I don't...