Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Export in txt from sql (in a pivot way) RE: Export in txt from sql (in a pivot way)

  • May 26, 2014 at 10:41 am

    #1716511

    antonela (5/26/2014)

    Do you know how can I do the same in sql server 2005?

    This functions properly only in sql server 2008 and 2012.

    Heh... this is why you should always pick the correct forum to post your questions on. Because you posted on 2012 forum, people just naturally assume that your question is based on 2012 instead of 2005. Posting on the correct forum means that you'll get a compatible answer instead of having to wait for someone to rehash your code for an earilier version.

    --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)