Forum Replies Created

Viewing 15 posts - 31 through 45 (of 311 total)

  • RE: T-Sql rant

    And I thought I was the only one who had to see the bottom of the potato chip package...

    "Hey man I can kick it anytime I want."

    I just kept reading...

  • RE: T-Sql rant

    [/quoteBy foxjazz - 2 days ago @ 2:48 AM

    Do any of you know a language other than English? Spanish, as a second or German?

    Because using English is dominant,...

  • RE: T-Sql rant

    By foxjazz - 3/14/2009 11:18 PM

    Ok, yes I did it that way before. Except you have to do it in 4 distinct query sets, and link the...

  • RE: T-Sql rant

    Most of the time when using cursors, it isn't to go through lots of records, but just a few at a time

    This kind of justification inevitably leads to a database...

  • RE: T-Sql rant

    foxjazz (3/13/2009) also instead of using cursurs like they are now, wouldn't it be easier to say:

    foreach( select myfield from tbl where myotherfield > 3)

    {

    insert into myothertable (myotherfield) values (myfield)

    }

    are...

  • RE: DTS Package Encryption Password

    So the guy, on the employer's tab and trust managed to destroy work he was paid for and on top of that he wants money to fix his sabotage.

    This goes...

  • RE: Polymorphed Proc

    I strongly object to such obfuscated programming. How many beginners who subscribed to this forum could be misled into thinking "wow ! clever trick I've got to find an occasion...

  • RE: Stored Procedures

    Thanks Sergyi.

    No, I cannot propose any better alternative, never having faced and coped with such a situation.

    Regards

  • RE: CAST Statement - Month Conversion

    Michael Valentine Jones (3/11/2009)


    Shorter.

    select [Month] = right(100+month(getdate()),2)

    Results:

    Month

    -----

    03

    I like that one! The use of of 100 is clever.

    I used something like RIGHT('00' + CONVERT(varchar(2), month(getdate()), 2)

  • RE: Can I make this any faster

    :laugh:Now that's funny.:laugh: A good way to end a boring day converting data from a foreign RDMS system and having to wait 20 minutes for the sp to complete and...

  • RE: Can I make this any faster

    so...

    you did pee in your boss' cornflakes ...

  • RE: Stored Procedures

    Sergyi

    Good point on the constraints.

    However, since I am working on a specific table, I have to look no further than the table itself to find out about constraints. Also, in...

  • RE: Can I make this any faster

    I break into a sweat just imagining I am the one stuck with debugging this mammoth of an sql statement...

    Note that the divide and conquer comments come from people with...

  • RE: Stored Procedures

    Sergiy

    Triggers ! :w00t:

    I have this deep-rooted prejudice against "hidden" code that executes from somewhere else. Say I am trying to debug a stored proc and I forget that there is...

  • RE: Inserting to Parent and Child tables

    Moojjoo: "I know this is a DB forum site, but I have a question "

    I really fail to see why you should be concerned with posting this here. Master-Detail relationships...

Viewing 15 posts - 31 through 45 (of 311 total)