Also, please be sure that your sample data and expected results match. In the code provided, they aren't even close.

kaladharreddy15, when you post code for people to use/test, particularly DDL and load procedures, please be sure you have tested it and it works. I started looking at your...

Hey Bob, Glad to see you back! Nice name change! 😉

Are you saying that I shouldn't play with what's left of an old mans mind?? Trust me, I'm...

Looking it over, there still appears to be some information missing to help answer the question fully. I'll have to look at in more depth when I get home.

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?