There are a number of possible solutions found in this article if you subscribe to SQL Server Magazine...

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=94487&DisplayTab=Article

It shows the performance results associated with 3 different ways to do this.