Please read the first article I reference below in my signature block regarding asking for help. It will walk you through the things you need to post and how to post them.

It is really hard to help you with your query when we can't see what you see. You are going to get nothing more than shots in the dark that may or may not help. Giving us the DDL, sample data, and expected results based on the sample will go a long way in helping us help you.