Can you please provide us the table structure so that we can try to solve your problem?
Its good practice to provide detailed information so that everyone can understand problem that your are facing.....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/