Post reply

SQL brian teaser...

  • July 5, 2009 at 6:24 pm

    #1020158

    Now, one last little ribbing. You spelled BRAIN incorrectly in you post header. 😛

  • July 5, 2009 at 7:14 pm

    #1020164

    Lynn Pettis (7/5/2009)

    Now, one last little ribbing. You spelled BRAIN incorrectly in you post header. 😛

    And here I've been waiting for Brian to show up the whole time! 😀

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • July 5, 2009 at 7:42 pm

    #1020168

    Lynn Pettis (7/5/2009)

    Now, one last little ribbing. You spelled BRAIN incorrectly in you post header. 😛

    Heh... Picky, picky, picky...

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

  • July 5, 2009 at 7:44 pm

    #1020170

    Digs (7/5/2009)

    Thanks all sorted now !

    This code is for an ASP.net project, data input comes from 3 textboxes that will out put a string each.

    Ok... first, it's a two way street here. Please post your final code so that others may enjoy your solution.

    Second, since this is coming from a GUI, the GUI should pass it in the correct order instead of doing it in SQL. 😉

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

  • July 5, 2009 at 8:54 pm

    #1020177

    Jeff Moden (7/5/2009)

    Digs (7/5/2009)

    Thanks all sorted now !

    This code is for an ASP.net project, data input comes from 3 textboxes that will out put a string each.

    Ok... first, it's a two way street here. Please post your final code so that others may enjoy your solution.

    Second, since this is coming from a GUI, the GUI should pass it in the correct order instead of doing it in SQL. 😉

    I suspect that we may be looking at SSRS here.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • July 5, 2009 at 9:11 pm

    #1020179

    Jeff Moden (7/5/2009)

    Lynn Pettis (7/5/2009)

    Now, one last little ribbing. You spelled BRAIN incorrectly in you post header. 😛

    Heh... Picky, picky, picky...

    Hey, I could have said something at the beginning but didn't. 😉

  • July 5, 2009 at 9:40 pm

    #1020189

    Every one is a comedian.

    Life of Brain ! ( I am kidding )..

  • July 5, 2009 at 9:53 pm

    #1020191

    Digs (7/5/2009)

    Every one is a comedian.

    Life of Brain ! ( I am kidding )..

    A little humor helps a bit...

    With that, though, Jeff really wasn't kidding when he asked you to post your final code. It is good forum etiquette to post your solution. As he said, others may have a similar problem or issue and seeing your code can be a benefit.

  • July 6, 2009 at 8:26 pm

    #1020821

    Where'd Digs go? He owes us a post with his solution...

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

  • July 6, 2009 at 8:30 pm

    #1020823

    Digs (7/5/2009)

    I havent built it yet. Because what comes first the chicken or the egg,...

    By the way... the answer to that question is the "egg" because a chicken can only be a chicken... depending on conditions, an egg can be anything.

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

  • July 8, 2009 at 9:13 pm

    #1022111

    Jeff Moden (7/6/2009)

    Where'd Digs go? He owes us a post with his solution...

    Ok... it's been a couple of days. First things first... do you like pork chops? Next, have you ever been through being black-balled before 'cuz I'm thinking you're pretty close to making that list.

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

Viewing 11 posts - 61 through 71 (of 71 total)

You must be logged in to reply to this topic. Login to reply