Forum Replies Created

Viewing 15 posts - 47,026 through 47,040 (of 59,101 total)

  • RE: Calculate values from previous records in a series

    Thanks, ehlinger ... I appreciate the detail. Just wanted to make sure you were "covered". Good "seeing" you again.

    --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 24, 2008 at 9:15 pm

    #902868

  • RE: Function that finds Sundays

    Michael Valentine Jones (11/24/2008)

    Michael Valentine Jones (11/21/2008)

    marty.seed (11/21/2008)

    Sorry, good question. The next Sunday

    So if I was to pass in todays date I would get 11/23/08

    What do you want it 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)

    November 24, 2008 at 9:11 pm

    #902866

  • RE: The Numbers Table

    GOC (11/24/2008)

    I must be missing something here. The thing I don't get about the whole tally of numbers discussion is why so much time and effort seems to always be...

    --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 24, 2008 at 8:40 pm

    #902859

  • RE: The Numbers Table

    jacroberts (11/24/2008)

    timothyawiseman (11/24/2008)

    jacroberts (11/24/2008)

    Performance isn't always an issue as in my previous example.

    I agree with Jeff that performance should always be a concern. After all, you may eventually need...

    --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 24, 2008 at 8:23 pm

    #902856

  • RE: The Numbers Table

    thisisfutile (11/24/2008)

    Jeff Moden (11/24/2008)

    jacroberts (11/24/2008)

    ... queried the table with 4000 rows in in less than 1 second.

    That's pretty slow and performance should be always an issue...

    With all due respect 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)

    November 24, 2008 at 7:41 pm

    #902850

  • RE: The Numbers Table

    Adam Machanic (11/24/2008)

    I'll add that recursion isn't much better than a While loop and is sometimes worse.

    I beg to differ. Recursion (in T-SQL) is always worse than 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)

    November 24, 2008 at 6:59 pm

    #902845

  • RE: The Numbers Table

    Adam Machanic (11/24/2008)

    Ed W. (11/24/2008)

    Ok, so you populated a table with numbers. Everyone can argue about how to do that, but the real question is what do you DO with...

    --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 24, 2008 at 6:53 pm

    #902843

  • RE: The Numbers Table

    CheeseMan316 (11/24/2008)

    Thanks for all the responses and thanks yuvalpe for identifying the original source of that query.

    Actually, you need to look at the post just above yuvalpe'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)

    November 24, 2008 at 6:44 pm

    #902840

  • RE: The Numbers Table

    jeffery.baynard (11/24/2008)

    Itzik uses RECURSION, even faster.

    With nums as

    (

    Select 1 as n

    Union all

    Select n+1 from nums where n < 10

    )

    Select n

    From nums

    As...

    --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 24, 2008 at 6:40 pm

    #902839

  • RE: The Numbers Table

    jacroberts (11/24/2008)

    It depends how much performance is an issue, for a lot of queries it is not. For example, if there is a daily report that runs in batch 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)

    November 24, 2008 at 6:49 am

    #902430

  • RE: Are the posted questions getting worse?

    Or the worst, depending on how you look at it.

    Is it me, or is it just the "language barrier"? Have these people no clue as to what a little...

    --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 24, 2008 at 6:45 am

    #902428

  • RE: Resume of MCDBA

    sqlizer (11/24/2008)

    Why do you guys even reply, just delete his/her post.

    Heh... part of his training to be a DBA. 😉

    --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 24, 2008 at 6:41 am

    #902425

  • RE: Advice for array oflarge arrays

    Heh... never mind... not enough coffee... this is a matrix they want and they want to be able to address the data by the individual elements using j,k coorinates. ...

    --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 24, 2008 at 6:32 am

    #902421

  • RE: Help with Money and Decimal datatype

    Then you don't need to do the formatting in the file you send because the spreadsheet is gonna format it the way it want's. In fact, you adding commas...

    --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 24, 2008 at 6:25 am

    #902413

  • RE: Increase Timeout to Get Query Results

    If it's on the GUI side that you want to do this, then I'm not sure.

    If it's on the SQL Server side of the house, a trip to Books Online...

    --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 24, 2008 at 6:22 am

    #902411

Viewing 15 posts - 47,026 through 47,040 (of 59,101 total)