PLease provide the proper DDL statements and data so that we can help you in your problem....
Refer this link whever you post any problem:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/