If you could post some sample data showing some of the issues and your expected results we can get a clearer idea of what you require.

Here's a link that details best practice

http://www.sqlservercentral.com/articles/Best+Practices/61537/