Listing B offers a better comparison with dynamic SQL. This code runs about twice as slow as the first block. That's three times as fast as the second example. However, the dynamic SQL is still at ...

SQL Server 2008 provides a minimal set of tools — cursors and WHILE loops — to accomplish this task. I’ll take a closer look at each option and explain why it’s difficult to pinpoint which ...