Forum Replies Created

Viewing 15 posts - 1,636 through 1,650 (of 7,483 total)

  • RE: Column manipulation with ALTER TABLE

    ArnoKwetters (6/16/2015)


    Thanks to all who have the courage to answer this question before tomorrow.

    At this moment the incorrect answers are still the majority.

    And they are still the majority.

    It's...

    Tom

  • RE: Using EXCEPT

    mitzyturbo (6/15/2015)


    Can anyone tell me the 'official' reason why such behaviour occurs on SQL server when comparing float values.

    If I run my code again, the values might match and...

    Tom

  • RE: The Rename Game

    I don't like renaming unless it's really necessary (to make column names indicate what the column is, including to replace meaningless names like Col1, Col2, and to ensure that a...

    Tom

  • RE: The Rename Game

    Alvin Ramard (6/12/2015)


    freecellwizard (6/12/2015)


    ...

    Also next time I listen to two engineers debate CountryId vs. CountryID for an hour I'm gonna slap someone!

    It should be country_id. 😀

    (just kidding)

    No, no,...

    Tom

  • RE: DEBIT AND CREDITS

    cbrammer1219 (6/15/2015)


    This is exactly how the data is stored, that is why I am having so much trouble pulling the correct data. This data comes from a Unix system and...

    Tom

  • RE: SQL Join

    sgmunson (6/15/2015)


    syed_3177 (6/14/2015)


    I have a right join query where i have a table where all employees attendence entry are registered and another table where pay master table.

    I need a query...

    Tom

  • RE: Five Minute Refactoring

    I tend to look at an approach to a pronblem with a few questions in mind (in no particular order of consideration or of importance):

    a) how likely is the aproach...

    Tom

  • RE: Question regarding database architecture

    ScottPletcher (6/15/2015)


    Our company has that exact situation. Just accept that you will have different "versions" of the product in effect for different clients at different times. It's just...

    Tom

  • RE: Seconds to AM/PM Time

    sgmunson (6/15/2015)


    sqldummy79 (6/15/2015)


    I have tried to find a blog or forum for the following issue, if someone could provide a link or the code, it would be greatly appreciated.

    I have...

    Tom

  • RE: Are the posted questions getting worse?

    Ed Wagner (6/15/2015)


    Steve Jones - SSC Editor (6/15/2015)


    Jeff Moden (6/15/2015)


    The thing that scares me about that is that it worked. Add a mobility unit, a carbon power cell, and...

    Tom

  • RE: Today's Random Word!

    Ed Wagner (6/15/2015)


    djj (6/15/2015)


    Eirikur Eiriksson (6/15/2015)


    Ed Wagner (6/15/2015)


    Revenant (6/15/2015)


    Ed Wagner (6/15/2015)


    djj (6/15/2015)


    crookj (6/15/2015)


    Guzzled

    Gin (reference to the late Red Skelton)

    Rum

    Captain

    Picard

    Packard

    Automobile

    Repair

    Mend

    Tom

  • RE: How Many Rows Returned

    It's a nice question, but I think the explanation lacks something.

    An explanation of how each of the three joins leaves the number of "Jim rows" alone, the first...

    Tom

  • RE: What will happen with below code???

    Hany Helmy (6/14/2015)


    Nice tricky question, thanx.

    I thought it was quite a nice question.

    It seemed pretty trick-free to me, although you did have to remember three facts: (i) that UNION...

    Tom

  • RE: Are the posted questions getting worse?

    SQLRNNR (6/13/2015)


    I have a few freeware apps (linux based) and another I purchased for about $100. The $100 software was able to recover after 5 passes of zeroing the...

    Tom

  • RE: Are the posted questions getting worse?

    SQLRNNR (6/13/2015)


    Luis Cazares (6/12/2015)


    Lynn Pettis (6/12/2015)


    Alvin Ramard (6/12/2015)


    Lynn Pettis (6/12/2015)


    Has anyone ever heard about "disk unformating?" Did not know if you formatted your hard drive you could undo it....

    Tom

Viewing 15 posts - 1,636 through 1,650 (of 7,483 total)