what result you are getting with this query and what output you want?
please provide some more detailed information
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/