Also Kiran, to John Mitchell's point, you ask a whole lot of questions on many forums that have simple and quick answers if you spend just a little time and effort on your part. Using the title to your post, it took only 4 minutes to find the article I provided the link to. It's not like you're a beginner at SQL... you first became a member of SSC more than 7 years ago.
This isn't meant as a slam... it's a suggestion that has helped me learn a whole lot and helps me avoid panic situations. Spend some time learning the product and how to use Google to help (but don't let it become a crutch like what you currently use forums for). When problems like this one occur, it'll take you a whole lot less time to come up with a solution and, if you study the code causing the problem (usually code with an accidental cross join in the form of a many-to-many inner join because someone doesn't know the data), you'll be able to prevent such things in the future.
Thank you Jeff. Using Google actually does not help because anybody can write anything there. It is not authentic. But forums like SQLServerCentral have experts like you who are authentic and thats why i ask questions here( thats what the purpose of this forum stands). I became a member 7 years ago, but I did not actually use it properly until sometime back. Sorry if I hurt you unknowingly.
Nope... thank you for your concern and kind words but there was no hurt involved here. And understood on the quality thing. I agree that the internet is frequently a well paved on-ramp to a dirt road.
Shifting gears to the subject at hand, did you read the article at the link I provided? I'm thinking that's what you need to do to find the code that's causing your problem.