Have you read the article http://www.sqlservercentral.com/articles/Best+Practices/61537/?
Post DDL of your tables, sample data insert script and expected results based on these data. Nothing more.
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]