Forum Replies Created

Viewing 8 posts - 1 through 8 (of 8 total)

  • RE: Testing values in R

    Just to point out that R is a case-sensitive language, so REP actually is not a defined function. 
    Assuming that the function was rep(x, ...), well, the correct answer would be...
  • RE: Only Use My Application

    +x

    TomThomson - Tuesday, May 30, 2017 7:25 PM

    I picked the 1st option despite knowing it to be a very bad answer...

  • RE: The Hidden Trigger

    manie (4/18/2016)


    roger.plowman (4/18/2016)


    Personally, I use three triggers on *almost every single table*--BUT 😀

    I only use them to create an audit log of insertions, deletions, updates and updates where I have...

  • RE: The Hidden Trigger

    Triggers are my nemesis.

    The ERPs I manage come out in many flavours, it has a lot of modules that can exists or not so the db structure depends on the...

  • RE: Convert datetime to bigint

    ScottPletcher (12/22/2014)


    As stated above, timestamp and datetime are not compatible. Timestamp has nothing to do with date time, it's simply the equivalent of a binary counter.

    Sure, i agree they...

  • RE: Convert datetime to bigint

    hjelmesethe (12/22/2014)


    The original poster's code creates a human-readable date/time in a bigint format.

    Ok, but the point stated was to use a bigint to improve performance not to get a...

  • RE: Convert datetime to bigint

    I'm really missing the scope of this conversion :doze: ..

    It sound likes this script is doing a large amount of CPU work for just change 8bytes into another 8byte...

  • RE: Convert Rows into Columns

    I dislike the solution proposed, it's far too complicated to reach a so easy task.

    You requirement was to print 3 lots at a time per line of document. This mean...

Viewing 8 posts - 1 through 8 (of 8 total)