Forum Replies Created

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

  • RE: LEFT JOIN

    Thanks for the question. I have made this mistake many of times of creating a left join and then filtering the right table.

  • RE: Delete v Truncate

    Thanks for the question.

  • RE: INNER JOIN

    First, Like others have said the question is subjective.

    Second, The answer of "Dates which get matched will be returned" is always correct because that is what an inner join...

  • RE: ISNUMERIC

    ...

    Because that would point you directly to the answer. I would have called it "You figure it out."

    ...

    I like that. All questions going forward should have the title...

  • RE: ISNUMERIC

    L' Eomot Inversรฉ (3/6/2013)


    Nice question, but I don't much like the heading. Fortunately I've learnt not to pay much attention to QotD headings.

    Yeah, I understand everyone's complaint about the...

  • RE: ISNUMERIC

    Thanks for the question

    Always define the length of your VARCHARS people ๐Ÿ˜€

  • RE: Stairway to XML: Level 10 - Converting XML Data

    Wow it's like I am looking into the future... reading an article that will come out two weeks from now.

  • RE: CHOOSE - 1

    Christian Buettner-167247 (1/29/2013)


    mtassin (1/28/2013)


    Christian Buettner-167247 (1/28/2013)


    Don't have AdventureWorks either... ๐Ÿ™

    You know, google and 5 minutes of download time and you can get it... MS puts it up on Codeplex for...

  • RE: CHOOSE - 1

    Good attempt at a question. Next time it would help to include the dataset or sql to insert data into the table. This was a question of what...

  • RE: Relational Model versus XML

    Sean Pearce (1/25/2013)


    sipas (1/25/2013)Personally I don't give two hoots if I get the answer right or not - as long as I learn something useful.

    I agree with that sentiment, however...

  • RE: Relational Model versus XML

    Koen Verbeeck (1/23/2013)


    I'd like to see the performance of the XML solution.

    Also, I would think the structure of your website is known, so a relational model is preferred.

    Curious to see...

  • RE: BIT data type

    Good question but this real doesn't have to do with the data type bit but instead about reading double negatives

    IF NOT EXISTS (SELECT 1 WHERE @BIT IS NOT NULL)...

  • RE: Precedence in math

    Carlo Romagnano (1/11/2013)


    Unbelievable, 98% of right answers! I think it's the record on ssc.

    Next, I will submit the following question:

    What color was the Napoleon's WHITE horse?

    ๐Ÿ˜›

    African or European WHITE horse?

  • RE: Precedence in math

    Nice attempt at the question, however I think this one is flawed

    Seeing how result two does not need the parentheses that is

    SELECT @a + (@B-@C) AS 'Result...

  • RE: Divide by zero

    Hugo Kornelis (12/23/2012)


    I have to offer my apologies for this question. I don't know what went wrong. I always check my question, answers and explanation several times before submitting, but...

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