export table

  • I didn't know there was ever a "good" case for XML. 😉

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

  • Jeff Moden (9/3/2014)


    I didn't know there was ever a "good" case for XML. 😉

    Well now you know as you've just made one:-D

    😎

  • Heh... I don't believe so. I know a lot of people really like XML for what it does but I hate it for what it does. For example, how many bytes does it take to pass a single 10 digit negative integer using XML... 18.

    <i>-1234567890</i>

    How many bytes does it take to pass the same thing in an encoded ASCII file? 4... and that includes the sign.

    How many bytes does it take to pass a single digit using XML? 8.

    <i>-1234567890</i>

    How many bytes does it take to pass a single digit in plain text ASCII? 1.

    Heh... and to think people were worried about the extra 2 bytes to store 4 digit years just a couple of decades ago. 😀

    Speaking of that, the good thing about XML (and HTML, for that matter) is network hardware had to get a whole lot faster, memory had to get a whole lot larger, disks had to get a whole lot bigger, and CPUs had to get a whole lot faster to handle tag bloat, de-entitization, and shredding. :w00t:

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

  • Nita Reddy (8/18/2014)


    I want to export one table but text contains ',' so can I use double " ? I don't see option when I select delimiter how should I do it.?

    Which tool are you using to implement the export?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply