Forum Replies Created

Viewing 15 posts - 41,491 through 41,505 (of 59,067 total)

  • RE: Afraid of Help

    talltop-969015 (10/17/2009)

    Still, no excuse to not do some research before posting....

    Agreed... but sometimes folks don't even know what to look for especially when they're new to SQL. Some haven'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)

    October 17, 2009 at 11:24 am

    #1067341

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

    Thanks Allister. The reformatting is taking longer than any of us anticipated and I also have a late breaking bit of information that I'm adding.

    For the code windows, you'll...

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

    October 17, 2009 at 9:56 am

    #1067338

  • RE: Are the posted questions getting worse?

    jcrawf02 (10/16/2009)

    Steve Jones - Editor (10/16/2009)

    whoop upside?

    what's next, shocking keyboards? loud raspberries when someone responds?

    Seconded, all in favor?:-D

    Belt fed pork chop launcher sounds like more fun. 😛

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

    October 17, 2009 at 12:59 am

    #1067307

  • RE: Are the posted questions getting worse?

    Grant Fritchey (10/15/2009)

    Jack Corbett (10/15/2009)

    Okay threadiatics, if you have choice between putting data for multiple applications in 1 database because there is some common data or application specific databases?

    Unless...

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

    October 17, 2009 at 12:53 am

    #1067306

  • RE: SQL CLR code needed to replace fn_regex_split

    Ummm... ok... take any split function that works on an VARCHAR(8000) and test it for performance using something less than 8k to split (sorry for being obvious). Then, just...

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

    October 17, 2009 at 12:35 am

    #1067304

  • RE: query optimizing

    zukko (10/8/2009)

    sorry forgot to add the full script 😛

    Thanks zukko.

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

    October 17, 2009 at 12:30 am

    #1067303

  • RE: Slow Query

    I was in a hurry so I didn't read Mark's post. He basically said the same thing that I did before I did.

    Here's the code you posted...

    select distinct a.empid

    from...

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

    October 17, 2009 at 12:21 am

    #1067301

  • RE: Concatenating Rows

    Paul White (10/16/2009)

    edit: aw carp - done it again! There are four pages of comments, not just the last one that the link took me to!

    Oh well, never...

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

    October 17, 2009 at 12:09 am

    #1067299

  • RE: Concatenating Rows

    sonphan11 (10/16/2009)

    1) What I meant was no particular view. This post was to reply back to a comment saying this method works only on one entity. I assumed the entity...

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

    October 17, 2009 at 12:00 am

    #1067298

  • RE: query to modify

    s ss (10/16/2009)

    Thank you so much Jeff. You put it way better than what I wanted to say in "The Thread".

    God bless you!

    Regards,

    Supriya

    Thanks Supriya... this one bugged me. ...

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

    October 16, 2009 at 8:31 pm

    #1067281

  • RE: query to modify

    Bob Hovious 24601 (10/16/2009)

    Jeff,

    I have a couple of questions:

    (1) Who are you, and (2) what have you done with Jeff Moden?

    Alternatively:

    (1) What kind of tranquilizers are you...

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

    October 16, 2009 at 7:48 pm

    #1067278

  • RE: query for random data but grouped

    First, because it's such an unusual requirement, I guess I'd like to know the business reason behind this, if you don't mind. Thanks.

    Second, I have a question. What...

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

    October 16, 2009 at 7:23 pm

    #1067276

  • RE: improving performance of stored procedure

    Heh... OK... cuffs don't match collar here...

    In your original post, you say you have a view and you posted...

    ALTER view [dbo].[[font="Arial Black"]vwLawsonGLAmounts_Memo[/font]] WITH SCHEMABINDING as....

    ... Then you go on 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)

    October 16, 2009 at 7:09 pm

    #1067274

  • RE: improving performance of stored procedure

    GardenLady,

    In the GLUnits table, what is the purpose of the DB_Units_13 column? What does it contain and why is it different for the following rows in the sample data?

    Company...

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

    October 16, 2009 at 5:45 pm

    #1067269

  • RE: improving performance of stored procedure

    By the way, GardenLady... Nice job on the data load for #GLUnits... it loaded without error. Not sure I can help the view, but I'm looking at 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)

    October 16, 2009 at 5:24 pm

    #1067264

Viewing 15 posts - 41,491 through 41,505 (of 59,067 total)