Forum Replies Created

Viewing 15 posts - 44,401 through 44,415 (of 59,101 total)

  • RE: Are the posted questions getting worse?

    Bob Hovious (4/2/2009)

    So three guys check into a fancy hotel together wanting to share a single room. The night clerk tells them the room is $300 for 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)

    April 2, 2009 at 10:18 pm

    #971295

  • RE: Are the posted questions getting worse?

    I'm sticking to my rule... if, especially after repeated attempts, the poster to continues to post forever changing data examples and still refuses to even try to post the data...

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

    April 2, 2009 at 4:55 pm

    #971194

  • RE: Do DBAs Still Read Techincal Books?

    maurine (4/2/2009)

    Based solely upon this post - I'm ready to preorder the book. When can we sign up?

    Heh... you just made a bad day great. Thanks for 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)

    April 2, 2009 at 3:46 pm

    #971154

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/30/2009)

    Jeff, changing the subject again, how is the rewrite of your Running Balance article coming? Had an OP today that could have benefitted from being able 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)

    March 31, 2009 at 11:22 pm

    #969620

  • RE: Concatenating Field Values

    Randy DeMasters (3/30/2009)

    I worked it out, if you choose add query on the binding source after setting up your dataset for your SP and then change the query to existing...

    --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 30, 2009 at 7:05 pm

    #968827

  • RE: Do DBAs Still Read Techincal Books?

    JacekO (3/30/2009)

    I hope when Jeff writes his book he will provide multiple methods for solving the problems with explanations why some solutions are better then other.

    You've just gotta know that...

    --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 30, 2009 at 4:34 pm

    #968776

  • RE: Do DBAs Still Read Techincal Books?

    Grant Fritchey (3/30/2009)

    Jeff Moden (3/29/2009)

    Heh... it's all your fault, ya know? Our conversations about 3 months ago are what started it all.

    Thanks for the feedback, Grant.

    Excellent. I'll take full...

    --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 30, 2009 at 4:28 pm

    #968770

  • RE: Do DBAs Still Read Techincal Books?

    Tony Davis (3/30/2009)

    ...the bleeding from one of Tony's editing sessions only lasts for three or four days, so don't worry.

    Don't worry, Jeff. I'll offer you as much help 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)

    March 30, 2009 at 4:26 pm

    #968769

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/30/2009)

    Jan Van der Eecken (3/30/2009)

    Geez, you are quick to pull out the rule book. Admitted, the pic is about the red card in the finals of a prof...

    --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 30, 2009 at 3:54 pm

    #968758

  • RE: Do DBAs Still Read Techincal Books?

    Steve Jones - Editor (3/29/2009)

    We're looking forward to seeing it on the front page here! I'm sure you'll have not shortage of good tech editors to spur you along.

    I understand...

    --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 29, 2009 at 8:42 pm

    #968131

  • RE: Do DBAs Still Read Techincal Books?

    Grant Fritchey (3/29/2009)

    Excellent. Congratulations and good luck.

    Heh... it's all your fault, ya know? Our conversations about 3 months ago are what started it all.

    Thanks for the feedback, Grant.

    --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 29, 2009 at 2:47 pm

    #968083

  • RE: Do DBAs Still Read Techincal Books?

    Absolutely unbelievable... I'm truly humbled by all your good urgings. Thank you all for your confidence.

    Apparently, you good folks aren't the only ones that think that I should write...

    --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 29, 2009 at 1:58 pm

    #968079

  • RE: Top 1000 of each group in a table

    Just add +1 to the following and you'll get your 60 months...

    where n.n <= DATEDIFF(m,@first_month,@last_month)[font="Arial Black"]+1[/font]

    --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 28, 2009 at 10:45 pm

    #967985

  • RE: Top 1000 of each group in a table

    Gabriel P (3/27/2009)

    I figured it out in case anyone is interested.

    declare @first_month datetime, @last_month datetime

    select @first_month = DATEADD(m,DateDiff(m,0,Min(sale_datetime)),0),

    @last_month = DATEADD(m,DateDiff(m,0,Max(sale_datetime)),0)

    from #temp

    select n.n, t1.*

    from #nums n

    cross apply (select top 10 *

    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)

    March 28, 2009 at 9:44 pm

    #967983

  • RE: Basic SQL Exercises

    Jacob Pressures (3/27/2009)

    Thanks guys. So what, I'd have to subscribe to a forum to get all the different posts? Much of what i see often goes over my head....

    --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 28, 2009 at 6:21 pm

    #967972

Viewing 15 posts - 44,401 through 44,415 (of 59,101 total)