Exec a Stored proc. for each rowhttp://lunarmedia.com/blogs/lunarmedia_blog/archive/2006/10/17/120363.aspxHave you ever needed to execute a stored procedure for each row in a table? In my latest Community Server mashup project we wanted to delete all posts in a particular weblog. In my perfect world it would look like something like this: Exec sp_cleanupenCommunityServer 2007 (Build: 20416.853)re: Exec a Stored proc. for each rowhttp://lunarmedia.com/blogs/lunarmedia_blog/archive/2006/10/17/120363.aspx#120377Wed, 18 Oct 2006 11:42:58 GMT8e740287-7179-42ca-83bf-5c4af18dab29:120377Anders VindbergHi Dave, nice to see you here again. I always forget how these things are done, particularly in these days when work with T-Sql.is sparse because of build-in business logic in CS :)<img src="http://lunarmedia.com/aggbug.aspx?PostID=120377" width="1" height="1">re: Exec a Stored proc. for each rowhttp://lunarmedia.com/blogs/lunarmedia_blog/archive/2006/10/17/120363.aspx#120365Tue, 17 Oct 2006 18:32:46 GMT8e740287-7179-42ca-83bf-5c4af18dab29:120365Dave BurkeThis is a great tip to blog on, Anders. &nbsp;I blogged on it a while back myself, but forgot how to do it since then. &nbsp;Thanks for posting it! <br></br><img src="http://lunarmedia.com/aggbug.aspx?PostID=120365" width="1" height="1">