Forum Replies Created

Viewing 15 posts - 44,881 through 44,895 (of 59,101 total)

  • RE: Calculating Work Days

    Lynn Pettis (2/19/2009)

    I don't think our PeopleSoft Admin has gotten around to this, so I thought I'd drop a line. She found your routine quite elegant and saved her...

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

    March 2, 2009 at 8:44 pm

    #952207

  • RE: Preceding with N'

    karthikeyan (2/24/2009)

    Hi

    The below query is invoked by apps.

    SELECT TOP 100 S.*, STA.VALUE STATUS_DESC FROM MSGS MG (NOLOCK) join STATUS STA on STA.STATUS=MG.STATUS where 1=1 AND (oid IN...

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

    March 2, 2009 at 8:41 pm

    #952206

  • RE: Calculate Moving Average Over Last 12 Months

    nick_hodge (2/20/2009)

    Thanks both for your help. I have this actual T-SQL but it times out (Timeout expired). (I have to calculate the inventory value but have tried on a test...

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

    March 2, 2009 at 8:36 pm

    #952204

  • RE: Removing cursor from TSQL - 2

    john.arnott (3/2/2009)

    Lynn, I probably should have used something more than a winking emoticon to show that I am certainly aware of the term but was just trying to show Jeff...

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

    March 2, 2009 at 6:57 pm

    #952193

  • RE: Are the posted questions getting worse?

    Bob Hovious (3/2/2009)

    Gail and Steve, I understand why you always want to discuss the full problem when you see someone about to go seriously wrong. But there 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)

    March 2, 2009 at 6:32 pm

    #952192

  • RE: question, urgent please!!!

    ganci.mark (3/2/2009)

    If there is a good, reason how is this? You can use cursor but I prefer using identity field which I added to table. If 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)

    March 2, 2009 at 6:19 pm

    #952190

  • RE: Are the posted questions getting worse?

    Bob Hovious (3/2/2009)

    Gail and Steve, I understand why you always want to discuss the full problem when you see someone about to go seriously wrong. But there 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)

    March 2, 2009 at 6:14 pm

    #952188

  • RE: Rand() function error

    john.arnott (3/2/2009)

    So what's wrong with RAND(), you may be wondering? As Jeff notes, the RAND (and also the NEWID) functions are deliberately designed to be invoked a single time in...

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

    March 2, 2009 at 5:46 pm

    #952183

  • RE: Can any one tell me?

    saravanantvr1984 (2/27/2009)

    My hearty thanks to Chris Morris

    You got help here... help us, please.... what is the business rule that you've been made to suffer that requires all parts of a...

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

    March 2, 2009 at 9:28 am

    #951927

  • RE: Removing cursor from TSQL - 1

    There's no special technique for this... it's simply the choice to figure it out using regular ol' set based code. It doesn't require a Tally table or any of...

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

    March 2, 2009 at 9:24 am

    #951925

  • RE: Removing cursor from TSQL - 1

    Heh... you mean the pork chops go to Kamran Ali. 😛

    If someone would post the "example data" in a reasonable format according to the link in my signature below, maybe...

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

    March 2, 2009 at 6:03 am

    #951794

  • RE: TSQL->C# SP

    Sounds like a fun binary search problem... I'll have to give it a try using pseudo cursors. Thanks, Alexander... I'll dog-ear this post and let you know what I...

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

    March 2, 2009 at 5:52 am

    #951788

  • RE: Rand() function error

    mverma4you (3/2/2009)

    you are not allowed to use the RAND() function inside UDF function. To call the value of this function create a view with the single statement select RAND()

    And then...

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

    March 2, 2009 at 5:34 am

    #951775

  • RE: Using a variable with IN

    Does the real #PointPartners have only 3 columns you want to join on? If not, how many?

    This should be done with a UNION ALL rather than going...

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

    March 1, 2009 at 9:12 pm

    #951651

  • RE: The February 2009 Energy Update

    I'd like to try it in my basement, but at $1/ft, that's expensive.

    Buy some 3/8" aquarium tubing, instead.

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

    March 1, 2009 at 7:13 pm

    #951640

Viewing 15 posts - 44,881 through 44,895 (of 59,101 total)