Viewing 15 posts - 1 through 15 (of 280 total)
Look at line 15, you are using two variables to represent your filter dates, but the string representation doesn't include the single quotes ' ' around the date. So...
January 3, 2013 at 6:39 am
Sorry, no. 0 is the correct answer, as each element of this question is a statement, not a query.
As above, BOL defines a query as a request for data,...
November 28, 2012 at 2:07 am
No - clustered indexes deliberately omitted as often these will be wrapped up with your CREATE TABLE scripts (i.e. when using CREATE TABLE myTable ( this INT PRIMARY KEY )...
November 27, 2012 at 6:56 am
That's new to me - hopefully this will be useful though! There's a few functions and things coming in with 2012 which seem ... well a bit 'non-relational'. ...
November 23, 2012 at 3:52 am
My apologies Koen, it wasn't an insult to your code, but mine. And you have a point, yes - SQL Server should be sorting out the date format rather...
November 23, 2012 at 3:19 am
Ignore my post above. Running this you get:
[font="Courier New"] Msg 1046, Level 15, State 1, Line 2
Subqueries are not allowed in this context. Only scalar expressions...
November 23, 2012 at 2:22 am
I'm sure there's a better way of doing this but my first instinctive thought would be to use a CASE statement as a computed column here.
I.e. something like:
DECLARE @dateTable TABLE...
November 23, 2012 at 2:20 am
Thanks for a good question, I know about STUFF for replacing parts of strings but thought the '0' for the length parameter formed part of a trick question (i.e. insert...
November 23, 2012 at 2:08 am
Good question, thanks!
November 20, 2012 at 1:49 am
I agree with other posters on this thread that this is a badly-executed question. Picking two arbitrary values with inconsistent results without explaining the rules governing the rounding by...
November 19, 2012 at 2:15 am
Dammit, a trick question. Annoying when the theme of QoTW is to avoid these in usual cases!
Learned something new though, so thanks!
If something looks too good (simple) to be...
November 14, 2012 at 8:08 am
Thank you for an informative introduction into applying data mining models.
November 12, 2012 at 4:58 am
This was a great question and I learned something new.
I do, however have a question of my own. I was under the impression that due to the internal timekeeping...
November 8, 2012 at 1:44 am
Excellent question, thanks very much. Have a good week.
November 5, 2012 at 1:50 am
For example it's good to know there are accented letters in the area. There are both lowercase and uppercase letters.Without tnis knowledge you are not able to understand string comparisons.
For example it's good to know there are accented letters in the area. There are both lowercase and uppercase letters.
Without tnis knowledge you are not able to understand string comparisons.
November 1, 2012 at 3:51 am