Hi,
Thanks for reply.....
I told in my original post that it works locally very fine. Also when the SP is run through the Query Analyser of client server, there also it run and gives the prefect result without any NULL values.
Also when I tried to figured out problem from Profiler I found that in loop after the Month 4 NO statement is executed. (Remember again SP runs fine in Query Analyser, of all 12 months it returns the result)
Please help......