Is this a homework assignment? The people here are usually not going to do your homework for you, but if you make an attempt at doing the work yourself and get stuck then please post the specific question at that time
Microsoft Certified Master - SQL Server 2008 Follow me on twitter: @keith_tate
Forum Etiquette: How to post data/code on a forum to get the best help[/url]