More wildcard searches

October 28, 2015 at 4:04 am

This was removed by the editor as SPAM

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

You must be logged in to reply to this topic. Login to reply

Mighty SSCrazy Eights Points: 9063 More actions · Answer 1

radek.hruby (10/28/2015)
The author possibly overlooked that in the first sentence the word "coffee" is twice.

+1

Forgot the "coffee " in "coffee bean". Obviously the "coffee." didn't meet the selection criteria. 😀

antydsr SSC Rookie Points: 38 More actions · Answer 2

Should be five. I ran the query and it returned 5 rows. Hmmm... 😉

Thom A SSC Guru Points: 99128 More actions · Answer 3

There are clearly 5 rows in the create table script, if "all" the rows are returned, then all = 5.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

l.vignando Old Hand Points: 313 More actions · Answer 4

All rows are returned.

Probably author intended to put a trap on line 1 with 'coffee.' but there is also a ' coffee ' at the beginning.

I suppose the score and result must awarded considering the correct result.

matthew.flower Default port Points: 1414 More actions · Answer 5

The other potential "trap" is that depending on the collation settings (which were not mentioned) the LIKE operator can be case sensitive so the sentences starting with "Coffee" wouldn't match; the default for SQL Server will match them though.

tripleAxe SSCertifiable Points: 5706 More actions · Answer 6

Am I missing something here?

All rows are returned, but that is five rows not four.

Off to get my coffee.......

Toreador SSChampion Points: 11365 More actions · Answer 7

Toreador

SSChampion

Points: 11365

October 28, 2015 at 3:33 am

#1835960

Oops!

vasantha.kumar.magadi Grasshopper Points: 12 More actions · Answer 8

How it is 4? it will return 5 (all rows which are inserted) and 5 should be the answer

christopherbaigent SSC Enthusiast Points: 139 More actions · Answer 9

Stewart "Arturius" Campbell (10/28/2015)
My first thought upon seeing the result was "Hmmm, maybe my first 2 cups of coffe have not kicked into gear yet, maybe i need another".
however, even after the third cup, the answer still does not make sense.
The idea behind the question was good, just a glitch with execution...

Only three?! You need five! Or is it four....?

Katargin Grasshopper Points: 19 More actions · Answer 10

It is you? who is wrong.

I tried this example and received FIVE records:-P

tom.w.brannon Hall of Fame Points: 3976 More actions · Answer 11

Actually on my system the answer is an error because the table would be created in my personal schema but then the insert and select are from dbo. Converting everything to a temporary table, the select returns 5 rows.

Umer Akram SSC-Insane Points: 22209 More actions · Answer 12

Hey Folks, It happens on QotD. Don't worry Steve will fix it 😉

As per the question, good basic question thanks for sharing. And Steve you will be be very happy to see the 84% have answered 5 😀

Cheers!!!

david.dilworth Right there with Babe Points: 780 More actions · Answer 13

I'm in the 5 camp as well. Perhaps someone could nudge the question setter to double check his question and answer! 🙂

Heals SSCrazy Points: 2234 More actions · Answer 14

david.dilworth (10/28/2015)
I'm in the 5 camp as well. Perhaps someone could nudge the question setter to double check his question and answer! 🙂

It happens every now and again - points are usually awarded back in the case of something being totally incorrect so you won't miss out (If you're worried about them).

Did make me think though - thought I'd missed something sneaky at first so read it a lot more carefully the second time round 🙂