Home Forums SQL Server 2008 SQL Server 2008 - General How to find column is having value or not RE: How to find column is having value or not

  • December 28, 2012 at 11:24 am

    #1572180

    Bhuvnesh (12/28/2012)

    Glad you got the solution yourself but i would suggest you to use set based or while loop instead of cursor

    see Comparing cursor vs. WHILE loop performance in SQL Server 2008

    I've found that comparisons between Cursor and While loops is like comparing the "pouring" speed between Molasses and High Fructose Corn Syrup. Depenind on your preferences, one looks better than the other but neither is designed for "pouring". 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)