Forum Replies Created

Viewing 15 posts - 196 through 210 (of 1,033 total)

  • RE: Halloween Protection

    bitbucket-25253 (10/30/2012)


    Hmm caught me on that one with Halloween coming up in the USA tomorrow thought this was one of those joke questions ... OH well so be it

    Same here......

  • RE: Parsing values in the WHERE clause

    johnf_amic (10/29/2012)


    Good question (Translation: I got it right).

    Hah I'll second that one... the pair in the parethesis just seemed innately wrong to me. A single value didn't... 🙂

  • RE: SELECT (Transact-SQL)

    Thanks, I needed an easy Friday question... the coffee machines are out of order today.

  • RE: PARSENAME

    Koen Verbeeck (10/25/2012)


    Great question about a function I didn't even know it existed 😀

    I knew it existed, but never had much use for it. A guy who I help...

  • RE: Five percent rounded down

    Koen Verbeeck (10/24/2012)


    Interesting question, thanks.

    I do wonder how people are supposed to get this right without running the script.

    I got it right when I realized my answer wasn't on the...

  • RE: A Versioning system for SSRS

    2008R2 and later support Sharepoint 2010 quite handily. Turn on the Document Version control for the site and you have each saved change in the history.

    Not with check-in comments...

  • RE: Table Variables

    Wow.... I knew I had to have this one wrong. I answered it out of memory and didn't even use BOL.

    Imagine my surprise when I was one of the...

  • RE: STR

    Michael Poppers (10/18/2012)


    I answered the QotD based on how I received it (STR(123.45, 2, 2)) via email. The Webpage currently lists a different statement (iirc, STR(987.65, 2, 3)) --...

  • RE: Noise

    I knew what they were, but I couldn't remember the nomenclature. So I popped open BOL and searched for noise words. Which took me to the stopwords area...

  • RE: VIEW - 9

    My only thought was.... where is the index for the statistics?

    I kept trying to figure out a way that would have allowed for the statistics, but couldn't come up with...

  • RE: While loop 2

    Saw the division by zero error.... and knew it was 4.

    Thanks for a question that I can unequivically feel that I know the answer to 🙂

  • RE: Dynamic Grouping in SSRS Reports

    jcrawf02 (10/11/2012)


    Interesting idea, have you seen a lot of use for this? Seems to me if the users wished to dig into the data and summarize on their own, they...

  • RE: T-SQL

    Good question, at least I didn't have to think too hard about this one and got it right.

    Then I started reading the discussion on Seeds and Hugo and Tom's discussion...

  • RE: SELECT

    sam.dahl (10/4/2012)


    I recognised the attempt to insert null and hence picked 2,0 because that's what the two select statements return: 2 and 0. It's the insert statement that fails.

    The question...

  • RE: FTS

    I wouldn't call this one easy or hard, but I'm glad I was able to answer it correctly without having to use google or think too hard... 🙂

Viewing 15 posts - 196 through 210 (of 1,033 total)