Please read the article in my signature on posting questions like this on the forum. Please provide the DDL statements along with the sample data inserts.
Microsoft Certified Master - SQL Server 2008 Follow me on twitter: @keith_tate
Forum Etiquette: How to post data/code on a forum to get the best help[/url]