Please provide the DDL scripts for the table creation, ddl script to insert some dummy data and desired output...
Please follow the link in my signature and you will find answers to your question quickly 😛
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/