Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12345»»»

BETWEEN Expand / Collapse
Author
Message
Posted Thursday, June 5, 2008 6:32 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 11, 2014 9:08 AM
Points: 491, Visits: 223
Whereas I can agree with the wording change from 'same' to 'identical', I thought it was obvious what this question was testing.

Good question.


Thanks

-Jeff
Post #512056
Posted Thursday, June 5, 2008 8:06 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, June 26, 2014 6:11 AM
Points: 1,330, Visits: 815
I felt like the question was a good question and was worded mostly well. Based on the feedback already posted, the only word I would have changed or removed was consistently. The way this was used would imply that the statements would be run multiple times on the same data set. In that case, the answer would be YES, which is what most folks were falling in to.

By removing the word consistently, I believe the question would have been completely correctly worded.

Despite my opinion here, I believe this was a good question as it was testing knowledge of the BETWEEN function.
Post #512143
Posted Thursday, June 5, 2008 9:09 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
I thought the question was clear enough. Good test of how Between works, which is all it seemed to me to be about.

I think some may have overthought it. That probably comes from some of the other questions, which have been "tricky".


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #512201
Posted Thursday, June 5, 2008 9:42 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, June 23, 2014 6:40 PM
Points: 612, Visits: 212
I agreed with Mark...Question was not to test ENGLISH it was to test the BETWEEN (T-SQL context).....
Post #512238
Posted Thursday, June 5, 2008 10:03 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, June 26, 2008 7:27 AM
Points: 239, Visits: 165
On my first read I thought that it was asking for consitancy on each execution, but when I thought about the select statements and the order of the between values, it was more clear that the author wanted to compare the result sets. Badly worded, but good example of how between works.

Q

Please take a number. Now serving emergency 1,203,894

Post #512264
Posted Thursday, June 5, 2008 10:07 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:30 AM
Points: 5,344, Visits: 1,388
why complain folks, question is good, only you have to read it long time to understand.....:)


Post #512275
Posted Thursday, June 5, 2008 10:17 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, July 10, 2014 12:43 AM
Points: 217, Visits: 170
I stepped into the answer to quickly as well.... unfortunately selecting yes, as my "interpretation" also (like many others) was running the query on select #1 and #2 multiple times, where my focus should have been on "this a between test" and not "what if the selects are run multiple times".....

good question, if you think a bit longer about it

well better luck next time :D
Post #512284
Posted Thursday, June 5, 2008 12:57 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:24 PM
Points: 7,139, Visits: 15,191
Thanks for the feedback folks... Some good comments. I will try to incorporate them next time.

I did have a bit of a hard time wording it. The goal was to allow you to run the entire script however many times and compare the results from #1 to #2 and not different generations of #1 to each other and #2 to each other. That didn't always come out, so it could have been worded better.

The "consistently" was inserted later to deal with the "1 in a billion" chance that a run of the SELECT...INTO happened to generate a quarter million values all outside of the 3-5 range....which would be the exception where #1 and #2 WOULD in fact be the same. Not likely, but possible.

I do like Philip's rewrite - but it still doesn't quite get to to heart of comparing #1 to #2. You'd have to reword as:

"Would statement #1 always generate a result identical to #2's ?" (answer - no, not always, but once in a blue blue moon, perhaps)

Anyway - as said before - I will take these into account next time..:)


----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Post #512404
Posted Thursday, June 5, 2008 1:06 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, July 1, 2013 4:39 PM
Points: 889, Visits: 97
Good question, does a good job of testing knowledge about BETWEEN,
but bad english.

I think the questioner needs to know the difference between 'consistent' and 'same as'.

Consistent means same result everytime and each time

'same as' - statement #1 's result = statement #2 's result
Post #512411
Posted Thursday, June 5, 2008 1:30 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, December 26, 2011 2:08 PM
Points: 196, Visits: 54
I think that this question was correctly formed.:D
Post #512441
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse