SQLServerCentral / Discuss Content Posted by Steve Jones / Article Discussions / Article Discussions by Author / NOT BETWEEN / Latest Posts

RE: NOT BETWEEN

kapil_kk — Wed, 10 Oct 2012 00:49:53 GMT

OMG I confused that may ne NOT BETWEEN '2012/1/2' AND '2012/1/5'includes the dates used in not between clause also and i put 4 as answer...:( :( :(Well, learn something new today

RE: NOT BETWEEN

zymos — Wed, 11 Apr 2012 07:57:30 GMT

Thanks for the interesting and easy question.

RE: NOT BETWEEN

KWymore — Mon, 02 Apr 2012 07:23:04 GMT

Nice and easy one to end the week on. Thanks Steve!

RE: NOT BETWEEN

skanker — Mon, 02 Apr 2012 03:53:18 GMT

I was expecting a trick to this one and was very relieved to get it right. Just proves that sometimes you have to go with your instinct.:-D

RE: NOT BETWEEN

baabhu — Mon, 02 Apr 2012 03:12:46 GMT

Good Question.....

RE: NOT BETWEEN

Hardy21 — Mon, 02 Apr 2012 00:30:43 GMT

Nice & Easy one...

RE: NOT BETWEEN

Britt Cluff — Sun, 01 Apr 2012 07:03:45 GMT

Should have read the question better. Missed my point because I didn't read NOT BETWEEN.

RE: NOT BETWEEN

L' Eomot Inversé — Fri, 30 Mar 2012 14:52:44 GMT

Nice easy question, thanks.I spent a liitle time poring over it looking for some liitle snag that could make 2 the wrong answer; but then I remembered there was a very similar question recently (BETWEEN instead of NOT BETWEEN, also don with dates, even the same 6 dates in the table if I recall correctly) and that one had no little tricks, so decided that probably this one was OK too.

RE: NOT BETWEEN

lbrigham — Fri, 30 Mar 2012 11:53:42 GMT

The only hesitation I had is that I use BETWEEN enough to know that it's inclusive at the lower and upper bounds, but don't use NOT BETWEEN very often so I thought maybe NOT BETWEEN would be exactly opposite and the lower/upper bounds would be exclusive so almost went with 4 rows returned, but went with gut and got it right.

RE: NOT BETWEEN

EL Jerry — Fri, 30 Mar 2012 10:20:17 GMT

Thanks for the easy question. I also was hesitant at first thinking it was too easy.Have a nice weekend, everyone."El" Jerry.

RE: NOT BETWEEN

SQLRNNR — Fri, 30 Mar 2012 09:58:29 GMT

[quote][b]dipmala.shende (3/30/2012)[/b][hr]Hi..I got 1,6 as output..I run this query on SQL server and got the same output.Please let me know how we can get 2 as output.[/quote]The request was number of rows

RE: NOT BETWEEN

jeff.mason — Fri, 30 Mar 2012 09:13:05 GMT

Amazing that we are nearly 20 comments in and no one complained about the date format regional issue. Of course, that might be because the results would be the same in other regions....

RE: NOT BETWEEN

DBA_Dom — Fri, 30 Mar 2012 08:55:10 GMT

I am a little surprised at the number of people that got this wrong. Maybe they read it wrong or looked at it too quickly. This is a straight back to basics logic question. While yes I agree with the others I was a little hesitant since it seemed too easy. Thanks for the nice light thinking after a long week.

RE: NOT BETWEEN

Danny Ocean — Fri, 30 Mar 2012 08:00:20 GMT

thx for easy point.

RE: NOT BETWEEN

Dana Medley — Fri, 30 Mar 2012 07:07:30 GMT

Nice n easy question to finish off the week. It's one of those, "No, it can't be this easy" kind of questions. Always looking for the QotD trick, but there was none...this time. (Insert evil laugh in background here, 'Muhahahaha' :laugh:) Great question.

RE: NOT BETWEEN

benkoskysa — Fri, 30 Mar 2012 05:57:26 GMT

I guessed 2 because BETWEEN is inclusive, and then I tried to run it. I found out that I needed SQL Server 2008 compatibility, don't have that, only 2005, so I changed the VALUES clause to UNIONs, and the DATE to DATEtime, then fuond out I had to be logged in as dbo, don't have that either, so I took the dbo. off of the select, and then it returned two rows, voilà!CREATE TABLE SalesDates(id INT, saledate DATEtime);goINSERT INTO SalesDatesSELECT 1, '2012/1/1'UNIONSELECT 2, '2012/1/2'UNIONSELECT 3, '2012/1/3'UNIONSELECT 4, '2012/1/4'UNIONSELECT 5, '2012/1/5'UNIONSELECT 6, '2012/1/6';go SELECT id FROM SalesDates s WHERE s.saledate NOT BETWEEN '2012/1/2' AND '2012/1/5';goDROP TABLE SalesDates;

RE: NOT BETWEEN

Thomas Abraham — Fri, 30 Mar 2012 05:26:47 GMT

[quote][b]Carlo Romagnano (3/30/2012)[/b][hr][quote][b]cengland0 (3/30/2012)[/b][hr]This one was so easy that I was looking for the "trick." I kept look and looking but never found one so I finally submitted my answer. I was relieved to see that I got it right. The amount of tension waiting to see the "You got it right" message was overwhelming.[/quote]+1I do not like qotd too easy or without tricks.:w00t:[/quote]I get paranoid when the question SEEMS too easy. Sometimes life really is that easy - strange but true. :-)

RE: NOT BETWEEN

Carlo Romagnano — Fri, 30 Mar 2012 03:20:23 GMT

[quote][b]cengland0 (3/30/2012)[/b][hr]This one was so easy that I was looking for the "trick." I kept look and looking but never found one so I finally submitted my answer. I was relieved to see that I got it right. The amount of tension waiting to see the "You got it right" message was overwhelming.[/quote]+1I do not like qotd too easy or without tricks.:w00t:

RE: NOT BETWEEN

Stuart Davies — Fri, 30 Mar 2012 02:56:22 GMT

Easy point today - thanks Steve

RE: NOT BETWEEN

palotaiarpad — Fri, 30 Mar 2012 02:39:38 GMT

Thanks for the easy QOTD!

RE: NOT BETWEEN

cengland0 — Fri, 30 Mar 2012 02:21:33 GMT

This one was so easy that I was looking for the "trick." I kept look and looking but never found one so I finally submitted my answer. I was relieved to see that I got it right. The amount of tension waiting to see the "You got it right" message was overwhelming.

RE: NOT BETWEEN

paul s-306273 — Fri, 30 Mar 2012 01:53:10 GMT

Nice QOTD to end the week.Thanks Steve.

RE: NOT BETWEEN

Koen Verbeeck — Fri, 30 Mar 2012 01:53:09 GMT

Thanks Steve for an easy question to finish the week!

RE: NOT BETWEEN

nghiavt — Fri, 30 Mar 2012 01:13:27 GMT

just wake up from snap. I miss NOT BETWEEN --> BETWEEN so my answer: 4 :hehe:

RE: NOT BETWEEN

Dave Brooking — Fri, 30 Mar 2012 00:54:38 GMT

The question asked [b]how many[/b] rows are returned. It didn't ask [b]which[/b] rows were returned.Dave

RE: NOT BETWEEN

dipmala.shende — Fri, 30 Mar 2012 00:03:10 GMT

Hi..I got 1,6 as output..I run this query on SQL server and got the same output.Please let me know how we can get 2 as output.

RE: NOT BETWEEN

SQLRNNR — Thu, 29 Mar 2012 22:23:18 GMT

We like these questions that require fewer brain cells to cap the week.

RE: NOT BETWEEN

mohammed moinudheen — Thu, 29 Mar 2012 21:50:19 GMT

Good question Steve.

RE: NOT BETWEEN

bitbucket-25253 — Thu, 29 Mar 2012 21:28:22 GMT

Nice easy one to end the week ....

NOT BETWEEN

Steve Jones - SSC Editor — Thu, 29 Mar 2012 21:27:48 GMT

Comments posted to this topic are about the item [B]NOT BETWEEN[/B]