Forum Replies Created

Viewing 15 posts - 18,721 through 18,735 (of 59,072 total)

  • RE: Dynamic Query issue

    Heh... I'll bet credits to Navy beans that the [SPLIT] function has either a WHILE Loop or some nasty XML in it with odds-on favorite being the WHILE Loop.

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

    January 4, 2016 at 6:24 pm

    #1849423

  • RE: Header and Detail Data

    bpowers (1/4/2016)

    We have a Header table and a Detail Line table, which join on the Primary Key . However, we are trying to return the results set in the following...

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

    January 4, 2016 at 6:15 pm

    #1849421

  • RE: It's the end of the year

    Lynn Pettis (1/4/2016)

    Good question. Just one minor thing, I'd use the following the end of the calendar year:

    SELECT DATEADD(DAY, -1, DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()) + 1, 0));

    With the understanding...

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

    January 4, 2016 at 3:24 pm

    #1849389

  • RE: Merry Christmas

    annjunk (12/27/2015)

    Thanks. One more quick question, is there a document any where with the colors used and the order when adding polygons, or does everyone just play with 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)

    January 3, 2016 at 8:12 pm

    #1849127

  • RE: Averages over 28 days instead of a month

    Now would be a good time to shift the train of thought to ISO Weeks, which always start the year in the week that Jan 4th occurs. Since 2012...

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

    January 3, 2016 at 3:16 pm

    #1849115

  • RE: Running as SysAdmin

    Cody K (12/21/2015)

    andrew gothard (12/21/2015)In fact, using a highly privileged single account for app access is nothing more than deliberate incompetence.

    The last time I heard something like this said 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)

    January 2, 2016 at 12:29 pm

    #1849078

  • RE: Calculating the status duration

    This could actually be a pretty simple thing to solve using either a self-joined re-enumerated table or the difference between two ROW_NUMBER()s. My recommendation is that you study 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)

    January 2, 2016 at 11:51 am

    #1849076

  • RE: How to manage study/practice time for sql server exams.

    mjagadeeswari (1/1/2016)

    Hi all,

    For the past few months I have been planning to

    prepare for the exam 70-462.(have done 70-461 earlier, that took for me ~5 months to complete). Tight...

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

    January 2, 2016 at 11:46 am

    #1849075

  • RE: Decorations

    Ed Wagner (1/2/2016)

    I'm pretty particular on the formatting of my code, for the very reasons of readability and maintainability. I can write format that'll confuse anyone, including myself, but...

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

    January 2, 2016 at 11:38 am

    #1849074

  • RE: Can i use option(recompile) for Functions?

    Kevin is correct. If you look in "Books Online", you'll find that there are 3 types of functions. Scalar Function, Multi-statement Table Valued Function (mTVF), and Inline Table...

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

    January 2, 2016 at 8:00 am

    #1849064

  • RE: Packaged-Application Database Nightmares - A Horror Story.

    John Langston (1/2/2016)

    Never thought about their being released when the application is released. I just viewed this approach as pointless since those generated query plans will never be re-used....

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

    January 2, 2016 at 7:42 am

    #1849062

  • RE: Packaged-Application Database Nightmares - A Horror Story.

    John Langston (1/1/2016)

    How about this one: the stored procedures in this vendor application where I am at are all TEMPORARY. They are created, executed, and dropped. There...

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

    January 1, 2016 at 9:31 pm

    #1849050

  • RE: Is BCP queryout limited?

    dwilliscp (12/31/2015)

    Jeff Moden (12/30/2015)

    So, just to be clear.... you no longer have the original "identifier" problem?

    I tried to put the call to their code in () but got a syntax...

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

    January 1, 2016 at 9:26 pm

    #1849049

  • RE: Are the posted questions getting worse?

    TomThomson (12/30/2015)

    Jeff Moden (12/29/2015)

    Lynn Pettis (12/29/2015)

    Jeff Moden (12/29/2015)

    I rather like the mostly unedited type of articles that are posted on SQLServerCentral. As a regular working Joe-bag-o-dunuts, I don't 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)

    January 1, 2016 at 9:06 pm

    #1849048

  • RE: It's the end of the year

    Happy New Year, Steve! Thank you for all that you do for this wonderful community!

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

    January 1, 2016 at 7:05 pm

    #1849045

Viewing 15 posts - 18,721 through 18,735 (of 59,072 total)