Home Forums SQL Server 2008 SQL Server 2008 - General While Loop into a Set Based Insert RE: While Loop into a Set Based Insert

  • August 15, 2012 at 8:40 am

    #1526027

    Check out the 2 "There must be 15 ways to lose your cursor" articles by RBarryYoung at http://www.sqlservercentral.com/Authors/Articles/RBarry_Young/659055/[/url]. They walk you through pretty much exactly what you need to do.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2