I was also going to write the script with using UNION ALL as yogi already described...
i think you get your answer now 😛
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/