Viewing 15 posts - 16 through 30 (of 118 total)
Thanks for the question. I have made this mistake many of times of creating a left join and then filtering the right table.
April 5, 2013 at 6:51 am
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...
March 12, 2013 at 5:59 am
...
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...
March 6, 2013 at 5:56 am
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...
March 6, 2013 at 5:54 am
Thanks for the question
Always define the length of your VARCHARS people ๐
March 6, 2013 at 5:52 am
Wow it's like I am looking into the future... reading an article that will come out two weeks from now.
January 30, 2013 at 6:59 am
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...
January 29, 2013 at 7:23 am
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...
January 28, 2013 at 7:22 am
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...
January 25, 2013 at 6:32 am
Koen Verbeeck (1/23/2013)
Also, I would think the structure of your website is known, so a relational model is preferred.
Curious to see...
January 25, 2013 at 6:31 am
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)...
January 22, 2013 at 5:59 am
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?
January 11, 2013 at 7:33 am
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...
January 10, 2013 at 6:41 am
Hugo Kornelis (12/23/2012)
December 26, 2012 at 6:41 am
Viewing 15 posts - 16 through 30 (of 118 total)