Forum Replies Created

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

  • 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

  • RE: Please show the certification chart of MCDBA

    Again... Lookup SQL Server Certification on the Microsoft Website...

    --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:20 am

    #902408

  • RE: Advice for array oflarge arrays

    I'm getting ready to go to work, so I can't solve it all right this instant.

    I do have a question, though... are all of these values for a single column...

    --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:18 am

    #902407

  • RE: Function that finds Sundays

    Peso (11/24/2008)

    Jeff's simplified.

    SELECT DATEADD(wk,DATEDIFF(wk, 0, getdate()), 6)

    However when run on a sunday, the code returns following sunday.

    My suggestion returns same sunday if run on a sunday.

    Heh.. yeah... I did...

    --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:11 am

    #902403

  • RE: The Numbers Table

    yuvalpe (11/24/2008)

    This topic was cover complitly by Itzik Ben-Gan years ago

    So? There's lot's of folks that don't even know who he is, never mind what a Numbers or Tally...

    --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:06 am

    #902402

  • RE: The Numbers Table

    jacroberts (11/24/2008)

    I'd consider using a table valued function instead that only returns the rows I'm interested in:

    e.g.:

    CREATE FUNCTION [dbo].[Nums]

    (

    @StartNum int,

    @EndNum int

    )

    RETURNS...

    --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:04 am

    #902399

  • RE: Are the posted questions getting worse?

    It was very difficult to maintain any semblance of professionalism on that one. Some of these folks need to clean the pipe they're smoking. 😛

    --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:00 am

    #902396

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