Post reply

Extract data to another table?

  • December 21, 2007 at 7:18 am

    #762103

    You bet...

    ... and, there are two "f's" in "Jeff"... I know a name isn't much, but it's all I've got 😉

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

  • December 21, 2007 at 9:12 pm

    #762372

    thanks Jeff!

    sorry for late reply,your code is advance that i cannot understand all of it.:D,especially the modolu(%3) you said.

    Well,i already done with my problem(offcourse it's because of you),i just change some of the temporary table in your code,bwaahla!its working!

    i put your code in the DTS,i have to because i have to create a dat file.

    thanks also for the follow-up question karthikeyan,regarding how the code works.i've learned a lot in here.i will test your second code that

    you post,the first one is very ok.

    i hope i can be a a good SQL Programmer(at least i can program):D.

    it's there a secret?id like to take a seminar or exam in ms sql,any suggestion?

    thanks again guys...

  • December 21, 2007 at 9:20 pm

    #762374

    Yes, there is a "secret"... simply think about what you want to do to columns instead of what you want to do to rows. That and having a little bit of math under your belt and which SQL functions do what and you know all of the "secrets" that I know. 😉

    So far as seminars and "official" schooling go... they cost a heck of a lot of money. The best way to learn is by trying to answer questions on forums like this one and testing other people's answers. Of course, that means you have to be willing to spend a little time to get really good because you need to analyze other people's code to figure out what they did. You won't always run into folks like me that are willing to explain the finer details of how their code works. I don't mind explaining because it's a form of "teaching" and, by nature, I'm a teacher at heart.

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

Viewing 3 posts - 16 through 17 (of 17 total)

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