Forum Replies Created

Viewing 15 posts - 91 through 105 (of 271 total)

  • RE: Happy Thanksgiving 2015

    Ed Wagner (11/27/2015)


    I love date math. I hope everyone had a great Thanksgiving and ate too much. 😀

    Yes to both having a great Thanksgiving and to eating too much.:-)

  • RE: Happy Thanksgiving 2015

    I got it right, but the struggle to do so showed how much my brain was slowed down after coming back from the holiday.

  • RE: Pass Through

    Koen Verbeeck (11/17/2015)


    Hugo should get extra points for his very elaborate answer!

    Great question, well done.

    Agreed.

  • RE: SQL Job Schedules

    Megistal (11/17/2015)


    Ok but why does it works like this under the hood? Why 20 minutes? Why on schedule?

    msdn web page is not very chatty about it.

    https://msdn.microsoft.com/en-CA/library/ms188924.aspx

    Just what I was wondering.

  • RE: Create Procedure

    paul 25096 (11/4/2015)


    I think the reason "Options 1, 2 and 3" has more votes than "Option 2" is because of course you should also avoid statements that cause a syntax...

  • RE: Risks of NOLOCK, part 1

    Using NOLOCK is something I was taught to do by an 'expert' when I first started using SQL. Fortunately, I learned better later on. Unfortunately, by that time,...

  • RE: More wildcard searches

    Steve Jones - SSC Editor (10/28/2015)


    Apologies. 5 Rows are returned. The wrong box got checked.

    Awarding back points to everyone.

    OMG. You made a mistake. The world is coming...

  • RE: More wildcard searches

    Sean Lange (10/28/2015)


    Roshan Oozeer (10/28/2015)


    Correct answer is 5 not 4 ... I want my 2 points.... Thank you

    Roshan

    You just got one of them. If you want points that badly you...

  • RE: Casting

    Hugo Kornelis (10/26/2015)


    matthew.flower (10/26/2015)


    I must be missing the explanation here?

    The explanation tells you where the problem is, but not what it is.

    [font="Courier New"]select '19.4615381' * -1.0;[/font] uses constant expressions, for...

  • RE: The TOP 10 Count

    I'll blame my cold medicine for getting this one wrong. It should have been easy if I'd had a clearer brain.

  • RE: Differences Between Lower Compatibility Levels and Level 120

    porter.james (10/19/2015)


    this is the part where i pretend i know what "may" is in dutch, and guess right 🙂

    Same for me.

  • RE: Counting the Tally Table

    One of those days when I click submit and then say, "No, no. That's not what I meant."

  • RE: Finding Azure SQL Database

    Mighty (10/16/2015)


    This question was so simple that I started to doubt if it was a trick question.

    But no, it was that simple! 😀

    Just what I was thinking.

  • RE: LEADing Rows

    Iwas Bornready (9/22/2015)


    Thanks for the question. Of course I can't use these because we are still on 2008.

    Same for me. And there are so many places where this would...

  • RE: Column aliases

    sestell1 (9/16/2015)


    freyes (9/16/2015)


    Ok, then we must agree that only two ways exists, The other ways are only variations of the two main ways.

    Would this count as a third?

    SELECT * FROM...

Viewing 15 posts - 91 through 105 (of 271 total)