Forum Replies Created

Viewing 15 posts - 19,906 through 19,920 (of 59,098 total)

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (8/14/2015)

    Jeff Moden (8/14/2015)

    Heh... since it's for XML...

    Trying to put my finger on this, just cannot find which kind of XML phobia is plaguing you Jeff:Whistling:, so far I've...

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

    August 14, 2015 at 5:47 pm

    #1820257

  • RE: Which is Best to use, #Temp Table or @Table Variable?

    GilaMonster (8/14/2015)

    Gary Harding (8/14/2015)

    Can you define a nonclustered index on a non-unique set of columns in a table variable?

    No, at least not before SQL 2014, but you can always...

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

    August 14, 2015 at 5:22 pm

    #1820256

  • RE: The Tally Table

    Alan.B (8/14/2015)

    BobAtDBS (8/14/2015)

    I have read Jeff's article, both in the past and an hour ago. His examples aren't things we do at the TSQL level very often. I'm...

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

    August 14, 2015 at 5:18 pm

    #1820254

  • RE: Unable to link data from data pulled from XML

    Easy now, folks. These types of things are how we all learn. 😉 Well, except for me. I reject all XML whenever I can. 😛

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

    August 14, 2015 at 1:58 pm

    #1820216

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (8/14/2015)

    Ed Wagner (8/14/2015)

    Eirikur Eiriksson (8/14/2015)

    Alvin Ramard (8/14/2015)

    Eirikur Eiriksson (8/14/2015)

    SQLRNNR (8/14/2015)

    Eirikur Eiriksson (8/14/2015)

    Sometimes one wonders what drives the responds when one points out that the posted solutions are not...

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

    August 14, 2015 at 1:54 pm

    #1820214

  • RE: Help Needed in Processing Data

    KGJ-Dev (8/14/2015)

    Hi Jeff,

    thanks for the reply. I have another idea. How about writing c# code to read the text file and dump it in intermediate table with the way it...

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

    August 14, 2015 at 1:31 pm

    #1820209

  • RE: The Tally Table

    Lynn Pettis (8/14/2015)

    g.britton (8/14/2015)

    What's the purpose of doing a cross join between the master.dbo.syscolumns table, and then not using it? Sorry, inquiring minds want to know.

    to get enough numbers to...

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

    August 14, 2015 at 1:00 pm

    #1820203

  • RE: The Tally Table

    Rod at work (8/14/2015)

    Oh OK Luis, I get it now. I got hung up on trying to read what's in syscolumn. That's not the point at all, is it. The...

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

    August 14, 2015 at 12:54 pm

    #1820200

  • RE: The Tally Table

    BobAtDBS (8/14/2015)

    I have read Jeff's article, both in the past and an hour ago. His examples aren't things we do at the TSQL level very often. I'm wondering...

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

    August 14, 2015 at 12:49 pm

    #1820196

  • RE: The Tally Table

    g.britton (8/14/2015)

    Alan.B (8/14/2015)

    g.britton (8/14/2015)

    I just wish it wasn't called a "Tally" table. I don't tally things, I count them. fwiw I usually call my "tally" table "N" to reflect...

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

    August 14, 2015 at 12:42 pm

    #1820193

  • RE: Which is Best to use, #Temp Table or @Table Variable?

    Eric M Russell (8/13/2015)

    I wish that temp tables and table variables were simply non-transacted.

    I'll strongly second that wish. I also wish that there were a way to mark certain...

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

    August 14, 2015 at 8:49 am

    #1820084

  • RE: Which is Best to use, #Temp Table or @Table Variable?

    pdanes (8/14/2015)

    If you are manually running some code in SSMS, table variables have the additional advantage of being generated fresh on every run. Temp tables stay around, and you have...

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

    August 14, 2015 at 8:44 am

    #1820079

  • RE: Help Needed in Processing Data

    Just checking. You DID intent to NOT import the Name field from the file, correct?

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

    August 14, 2015 at 7:29 am

    #1820043

  • RE: Help Needed in Processing Data

    {EDIT} I previously suggested using BULK INSERT and now I see there's an identity column and a couple of unwanted columns. Still a job for BULK INSERT but we...

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

    August 14, 2015 at 7:07 am

    #1820033

  • RE: The Tally Table

    Eric M Russell (8/13/2015)

    Long overdue praise for the lowly tally table. I declare August 33rd as the official Tally Table Appreciation Day.

    Ugh! That would mean that I'd have to...

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

    August 13, 2015 at 8:27 pm

    #1819936

Viewing 15 posts - 19,906 through 19,920 (of 59,098 total)