Forum Replies Created

Viewing 15 posts - 16 through 30 (of 64 total)

  • RE: 15 Quick Short Interview Questions Useful When Hiring SQL Developers

    Related to "A test with at least one tough question ": it's useful to see how people react to things that they don't know. I'd sooner see...

  • RE: Basic maths - operator precedence

    Jamie Longstreet-481950 (2/25/2013)


    May have something to do with a sense of pride. I was raised to think there was a difference between proper and improper. I was not...

  • RE: Bring Solutions

    In the graphic that illustrates this artlcle, you can save yourself the bother of working out the exact value of 2008 squared and then converting to mod 7, because...

  • RE: The Lonely and Neglected Cartesian Product (Cross Join)

    I selected "none of these are correct".

    The first two are wrong for the reasons stated in the answer.

    The third is wrong because the requirements are that the three rows for...

  • RE: Basic maths - operator precedence

    It actually doesn't matter whether you do the division or multiplication first, but it's easier to keep track if you work left to right.

    It can matter whather you do the...

  • RE: Basic maths - operator precedence

    the link provided in the reference section, does that follows the actual BODMAS flow? in the table, the level 2 shows multiply first and then followed by division.. but in...

  • RE: Computed column

    L' Eomot Inversé (1/31/2013)


    nice simple question.

    I wonder why MS has this restriction?

    My guess is that is makes it much easier if they don;t need to deal with the possibility of...

  • RE: LEAD - 1

    Koen Verbeeck (10/30/2012)


    Konstantin Reu (10/30/2012)


    I think the question is not ready to be published. Description is not clear and have many mistakes like mentioned term "SalesGoal" but I did not...

  • RE: Days Difference Between 2 Dates

    wolfkillj (10/2/2012)


    archie flockhart (10/2/2012)


    "Interesting" behaviour:

    DECLARE @date datetime

    SET @date='2012-10-01 13:21:00'

    SELECT CAST(@date AS int)

    result: 41182

    SELECT CAST(CAST(@date AS float) AS int)

    result: 41181

    This occurs because casting DATETIME to INT rounds...

  • RE: Days Difference Between 2 Dates

    Dave62 (10/2/2012)


    L' Eomot Inversé (10/2/2012)


    ...

    Yes, I change the avatar every few months; and switch languages (and messages) in the signature message quite often too. Avoids being too much...

  • RE: Days Difference Between 2 Dates

    "Interesting" behaviour:

    DECLARE @date datetime

    SET @date='2012-10-01 13:21:00'

    SELECT CAST(@date AS int)

    result: 41182

    SELECT CAST(CAST(@date AS float) AS int)

    result: 41181

  • RE: Table Variable

    The hardware-related nature of this question reminded me of the urban legend about the newspaper story about the inmate who escaped from the asylum, raped one of the cleaners, and...

  • RE: "Question of the Day" is about:

    Steve Jones - SSC Editor (7/30/2012)


    I wanted to get some idea from those of you that answer this regularly, and this works better than a survey, unfortunately.

    If you didn't...

  • RE: "Question of the Day" is about:

    "This is an opportunity to learn new/different thing and your answer will never be wrong if you read the related subject first."

    Isn't this a bit paradoxical and self-referential ? ...

  • RE: One Single View

    I think in many cases, a 'single view of the truth' is almost impossible to define. The way we tackle the question will depend on why we want the answer.

    Take...

Viewing 15 posts - 16 through 30 (of 64 total)