Forum Replies Created

Viewing 15 posts - 27,991 through 28,005 (of 59,101 total)

  • RE: Calculate weekend

    ScottPletcher (12/3/2012)

    CELKO (12/1/2012)

    Please learn to use the ISO-8601 date formats; it is the only one allowed in Standard SQL and the other ISO Standards. Use the DATEADD() function for this....

    --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 4, 2012 at 4:49 pm

    #1565530

  • RE: Exercises in t-SQL

    Eugene Elutin (12/4/2012)

    Continuous discussion on this thread, kind of shows that people has nothing much to do...

    :hehe:

    So, not much to do, Eugene? 😛

    BTW, I don't think J.Moden would be asked...

    --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 4, 2012 at 8:03 am

    #1565346

  • RE: Exercises in t-SQL

    ScottPletcher (12/3/2012)

    Jeff Moden (12/3/2012)

    If I were in an interview and someone asked me such a question, my answer would be that future requirements could easily change, especially in the area...

    --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 4, 2012 at 7:49 am

    #1565335

  • RE: Calculate weekend

    kapil_kk (12/3/2012)

    I will try with Tally table and tally calender which Jeff has suggested....

    Thnks for the suggestion 🙂

    To be clear and to give credit where credit is due, I wasn'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)

    December 4, 2012 at 7:37 am

    #1565325

  • RE: How to use values keyword as parameter of a function

    _simon_ (12/4/2012)

    But what if I need to test inequality, then I would need to write something like this:

    where T1 <> T2 and T1 <> T3 and T2 <> T3

    I'm on...

    --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 4, 2012 at 7:33 am

    #1565319

  • RE: Data mining on a single table

    To add to what I previously stated. If you're using an analysis tool, such as SSAS, you may have to "normalize" to a star or snowflake to take advantage...

    --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 4, 2012 at 7:27 am

    #1565317

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (12/3/2012)

    The Dixie Flatline (12/3/2012)

    My motor is still idling from the tryptophan-coma of Thanksgiving.

    In my experience, the period from just before Thanksgiving through New Year's Day isn't very productive.

    That's...

    --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 3, 2012 at 6:15 pm

    #1565097

  • RE: Identity Seeding

    To answer the original question, yes... we start most tables off at 1000 with the understanding that 0 through 10 are typically reserved for "very special use" and 11 through...

    --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 3, 2012 at 6:11 pm

    #1565094

  • RE: Identity Seeding

    jasona.work (11/30/2012)

    If our devs had used the patient ID value as the identity, it would have been a (10,10) seed. The way the current billing application handles patient IDs...

    --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 3, 2012 at 5:55 pm

    #1565092

  • RE: Are the posted questions getting worse?

    jasona.work (12/3/2012)

    Or am I being paranoid?

    BWAA-HAAA!!! You should know the answer to that by now... "It Depends". 😉

    --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 3, 2012 at 5:31 pm

    #1565089

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (12/3/2012)

    Has anyone else heard the rumors of a 3-D Roger Rabbit being in the making?

    I'm trying to track down the official news item.

    Rumor has it that it's actually...

    --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 3, 2012 at 5:28 pm

    #1565087

  • RE: Alternative to xp_cmdshell

    Yes, and for the very same reason you stated. If the archive bit hasn't been set to 0, then the file hasn't been backed up to tape and must...

    --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 3, 2012 at 5:18 pm

    #1565085

  • RE: TSQL Problem: Week between 2 different months

    You're welcome. Are you all set on this problem or do you have additional questions on 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)

    December 3, 2012 at 5:13 pm

    #1565083

  • RE: Exercises in t-SQL

    If I were in an interview and someone asked me such a question, my answer would be that future requirements could easily change, especially in the area of the number...

    --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 3, 2012 at 5:06 pm

    #1565079

  • RE: Feedback is Encouraged

    chrisn-585491 (12/3/2012)

    After seeing the mess that is the Windows 8 interface, plus all the changes to management tools, the multiple changes in the Office interfaces, I'm not sure that Microsoft...

    --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 3, 2012 at 4:37 pm

    #1565073

Viewing 15 posts - 27,991 through 28,005 (of 59,101 total)