Forum Replies Created

Viewing 15 posts - 16,306 through 16,320 (of 59,067 total)

  • RE: Go Code

    David.Poole (11/13/2016)

    I look back in my career having known individuals who were 100% right about what they were saying and were years ahead of their time but because they couldn't...

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

    November 13, 2016 at 8:31 am

    #1912110

  • RE: Are the posted questions getting worse?

    GilaMonster (11/13/2016)

    Ed Wagner (11/12/2016)

    I just hid a bunch

    How???

    I'm sick of just reporting them and having the spam hang around for hours afterwards

    Ask Steve to give you the privs to do...

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

    November 13, 2016 at 7:52 am

    #1912109

  • RE: Embedded Text Qualifier Bug

    Aubrey-314204 (11/11/2016)

    Recently we migrated from SQL 2008 to 2014. I have come across an error that only is happening on the 2014 environment, but working successfully in 2008. ...

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

    November 12, 2016 at 6:18 pm

    #1912095

  • RE: Copy/Insert Data to another table with different number of columns

    tocy1980 (11/12/2016)

    Hello guys,

    This would be me example. I have some query and my final table looks like:

    |Country|Region|Mark|RW|December 26, 2015|January 2, 2016|January 9, 2016|... etc.

    Also I have and second table where...

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

    November 12, 2016 at 6:13 pm

    #1912093

  • RE: Today's Random Word!

    TomThomson (11/12/2016)

    Luis Cazares (11/11/2016)

    djj (11/11/2016)

    Ed Wagner (11/11/2016)

    Revenant (11/11/2016)

    Hope

    Faith

    Charity

    goodwill

    Benevolence

    Philanthropic

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

    November 12, 2016 at 6:07 pm

    #1912092

  • RE: Benefits of SQL 2014/2016 over 2005 ??

    Luis Cazares (11/10/2016)

    Eirikur Eiriksson (11/10/2016)

    homebrew01 (11/10/2016)

    Eirikur Eiriksson (11/10/2016)

    Think this is the wrong question, should be "what are the justifications for running an unsupported version of SQL Server"

    😎

    Doesn't cost any money...

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

    November 12, 2016 at 3:33 pm

    #1912083

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (11/12/2016)

    What a spamtastic Saturday morning:pinch:

    😎

    Indeed it has been. I've personally hidden about 100 spam posts in the last 4 to 5 hours. The bots are having...

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

    November 12, 2016 at 11:37 am

    #1912071

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/11/2016)

    Jeff Moden (11/10/2016)

    Lynn Pettis (11/10/2016)

    Jeff Moden (11/9/2016)

    Lynn Pettis (11/9/2016)

    Jeff, I actually excepted you to have some interesting comments about the code I emailed you, or didn't you get...

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

    November 12, 2016 at 11:33 am

    #1912070

  • RE: Good to have Multiple Data Warehouses?

    To wit, I frequently go with the "no data warehouse" option in favor of just writing some streamlined code to solve actual problems instead of a system to handle all...

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

    November 12, 2016 at 11:26 am

    #1912068

  • RE: Trace value in stored proc

    weiran1982 (11/12/2016)

    Hi guys,

    I'm new to SQL and need a bit help here. I'm troubleshooting an application (no source code). I set up SQL profiler and captured RPC call something like...

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

    November 12, 2016 at 11:22 am

    #1912067

  • RE: Understanding from .. from

    Edvard Korsbæk (11/12/2016)

    Now i just need to understand, why you use so much time om me....:-)

    You've already answered that question. 😀

    Edvard Korsbæk (11/12/2016)

    This makes sense, and makes my 'Deletes' much...

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

    November 12, 2016 at 11:15 am

    #1912066

  • RE: What's the best practice to auto import files from SFTP

    Heh... some clients are worth losing. 😉

    The title of your post did ask "What's the best practice to auto import files" and what I wrote in my previous post is...

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

    November 12, 2016 at 8:47 am

    #1912062

  • RE: TSQL Formatting tool?

    Eirikur Eiriksson (11/12/2016)

    I've also found that I can, indeed, frequently tell the difference between someone that used a formatting tool and someone that did not even when both are formatted...

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

    November 12, 2016 at 8:33 am

    #1912061

  • RE: Understanding from .. from

    Edvard Korsbæk (11/12/2016)

    Hi All!

    I got some code from another, where i have som understanding problems.

    Its pretty long, but the start is:

    DELETE FROM dbo.DutyRosterShift FROM dbo.DutyRosterShift B

    WHERE

    B.DutyRosterId...

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

    November 12, 2016 at 7:57 am

    #1912059

  • RE: What's the best practice to auto import files from SFTP

    halifaxdal (11/11/2016)

    This is really a challenging to me: I am assigned folders (yes, plural, more than one folder) on SFTP server, each folder correspondent to one client. Each folder will...

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

    November 12, 2016 at 6:46 am

    #1912056

Viewing 15 posts - 16,306 through 16,320 (of 59,067 total)