It would help those who will be attempting to help you if you provided the table structure, sample data and the T-SQL statement that you have attempted to utilize. All this per the article whose link is in my signature block.
If everything seems to be going well, you have obviously overlooked something.
Ron Please help us, help you -before posting a question please read[/url] Before posting a performance problem please read[/url]