Home Forums SQL Server 2008 SQL Server Newbies looping thru views RE: looping thru views

  • March 15, 2013 at 12:00 pm

    #1597612

    Jeff Moden (3/15/2013)

    I suppose you could take what was said two ways. I may have taken it the wrong way.

    I was not 100% clear in what I said. I was implying that sp_msforeach(table | Db) falls under the category of dsql and is, therefore not the best option. The newer code I posted still uses dsql but is free of any loops, cursors, RBAR (Hoo-uh).

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001