Forum Replies Created

Viewing 15 posts - 21,916 through 21,930 (of 26,490 total)

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (3/18/2009)


    There is no offsides rule. Put a rugger up in front and he'll drag and last defender along with him.

    So Steve, are you a Soccer Referee's...

  • RE: Are the posted questions getting worse?

    Bob Hovious (3/18/2009)


    Lynn, I didn't mean for my explanation to come over the top of your code. I just took a while to think about it and...

  • RE: Are the posted questions getting worse?

    I would have to agree, self-taught or mentored by someone with a strong Oracle background. I can only go on that based on others who have commented regarding Oracle.

    What...

  • RE: Are the posted questions getting worse?

    Just wanted to pass this on to those who may be interested, looks like foxjazz may be more a Vader type than an Emperor type. We may finally be...

  • RE: T-Sql rant

    foxjazz (3/18/2009)


    OK DAMN

    I don't have it all wrong, but here is the issue.

    The user defines the sequence, it isn't alphabetical. So when inserting a record the user would give 2...

  • RE: T-Sql rant

    foxjazz (3/18/2009)


    let me give some data

    partnumber, producttype, sequence

    7401,belt,1

    7432,belt,2

    8401,hose,1

    8422,hose,2

    This is the table.

    inert a record (8403,hose,?)

    after a resequence you would have

    8401,hose,1

    8402,hose,2

    8422,hose,3

    Before I write any code, plus I have work to do here...

  • RE: T-Sql rant

    Chris Morris (3/18/2009)


    foxjazz (3/18/2009)


    {} is much better than BEGIN BEGIN BEGIN BEGIN END END END END

    Heh quite possibly - but the count of BEGIN - END pairs goes right down...

  • RE: T-Sql rant

    foxjazz (3/18/2009)


    let's say we have the table with

    partnumber, producttype, sequence

    After inserting part in the table we need to resequence the sequence number which depends on the partnumber.

    so select partnumber...

  • RE: T-Sql rant

    foxjazz (3/18/2009)


    {} is much better than BEGIN BEGIN BEGIN BEGIN END END END END

    For you, perhaps. I find BEGIN END just fine. Remember I did come from a...

  • RE: T-Sql rant

    Selfless plug -- One of the articles now referenced in my signature block is actually mine, though it is based off Jeff's work.

  • RE: T-Sql rant

    foxjazz (3/18/2009)


    Lynn, since you brought it up. I want to apologize for calling you dense.

    It's been an adventure this week, I still don't have a computer from the recent crash...

  • RE: Code Formatting

    Copying and pasting code from the forum, the code becomes double spaced and it loses it formatting (indention for one).

  • RE: T-Sql rant

    Bob, I'll join you in cutting foxjazz some slack, but there needs to be a bit more from him than just dropping the insults.

    First, a simple apology for calling me...

  • RE: T-Sql rant

    kevin.reynolds (3/18/2009)

    --------------------------------------------------------------------------------

    I feel Im running the risk of being lynched, but I agree in general with foxjaaz.

    Im a database developer but I too am frustrated with the snail pace at...

  • RE: Are the posted questions getting worse?

    I don't know yet. It's hard to tell if he is a Vader or an Emperor. If you tried to run his code he provided it is missing...

Viewing 15 posts - 21,916 through 21,930 (of 26,490 total)