Who Has The Monitor?

Question

Who Has The Monitor?

Viewing 15 posts - 31 through 45 (of 50 total)

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

jereme.guenther@gmail.com SSCarpal Tunnel Points: 4259 More actions · Answer 1

Lol, some people have way too much time.

I take my hat off the solution in SQL, a truly indigenous method of employing our skills. I don't know why but for every work related problem I immediately turn to SQL, however as soon as a simple none work related puzzle is introduced I bring out the pencil and paper.

Joel Rea Old Hand Points: 339 More actions · Answer 2

“indigenous&rdquo?

You keep using that word. I do not think it means what you think it means.

Okay, let’s see you SQL gurus use SQL to come up with a solution to this puzzle. What is the next item in this sequence:

O, T, T, F, F, S, S, __ ?

cs_troyk SSCertifiable Points: 5383 More actions · Answer 3

cs_troyk

SSCertifiable

Points: 5383

April 28, 2006 at 12:32 pm

#634981

E, N, T

Julie Hargraves SSCarpal Tunnel Points: 4457 More actions · Answer 4

Aw, cs_troyk, you beat me. I didn't see your post until just after I clicked Reply to answer the same thing. And just to prove I did know the answer, I'll continue it.

E, T, T, F, F

jereme.guenther@gmail.com SSCarpal Tunnel Points: 4259 More actions · Answer 5

Your right, it is one of the more common words I miss-spell. I meant ingenious.

However the meaning could still sort of apply.

Joshua Perry SSC-Addicted Points: 454 More actions · Answer 6

Name	Color	Car	Drink	Monitor
Sue	Blue	Prius	Mountain Dew	15" CRT
Steve	Green	Caravan	Coffee	17" CRT
Kevin	White	Suburban	Red Bull	15" LCD
Andy	Yellow	Accord	Iced Tea	19" DUALS!!
Brian	Red	Corvette	Beer	17" LCD

John Suit Mr or Mrs. 500 Points: 555 More actions · Answer 7

Red

Blue

Green

White

Yellow

Suburban

Accord

Prius

Corvette

Caravan

Red Bull

Mtn Dew

Beer

Coffee

Iced Tea

17" CRT

15" CRT

Dual 19"

15" LCD

17" LCD

First

Second

Third

Fourth

Fifth

Brian

Y

N

n

N

y

Y

N

n

y

N

Y

N

Steve

N

n

y

N

y

N

n

N

y

n

N

Y

N

y

N

n

Andy

N

y

n

N

n

y

N

n

N

Y

N

y

n

N

n

N

y

Sue

N

Y

N

n

y

n

N

n

y

N

n

y

n

Y

N

Kevin

N

y

n

N

Y

N

n

N

y

N

n

y

n

N

y

n

B

Y

R

G

W

This is what I came up with.

-John

Mark Shindler Grasshopper Points: 14 More actions · Answer 8

Mark Shindler

Grasshopper

Points: 14

April 28, 2006 at 3:45 pm

#635013

Andy

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 9

I'm surprised at the number of posts claiming that there is just one solution. Below are the four solutions that SQL Server returned on my query. As far as I can see, all clues are satisfied in each of the four solutions. Am I missing anything?

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Glenn Adams-245014 Newbie Points: 7 More actions · Answer 10

BTW, the execution plan is definitely, ahem, "interesting"

You can knock out about 100 possible combitation by adding the following inferred clues:

AND NOT (Car = 'Accord' AND Monitor = '17" LCD')

AND NOT (Car = 'Caravan' AND Monitor = '15" LCD')

AND NOT (Person = 'Andy' AND Color = 'green')

Unfortunately I can't see if that affects the results as my laptop's not capable of generating an execution plan for the final query! That's a first for me!

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 11

Unfortunately I can't see if that affects the results as my laptop's not capable of generating an execution plan for the final query! That's a first for me!

Hi Glenn,

I thinks it's the SQL Server version, not the laptop - SQL 2000 doesn't produce a plan for me either, but SQL 2005 does.

Anyway, adding the extra filters doesn't change the results. Still four solutions!

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Joel Rea Old Hand Points: 339 More actions · Answer 12

Read it again: I didn’t ask you to guess the sequence (which is easy enough). I asked you to use SQL to come up with a solution to it — without hard-coding the English names of the numerals, by the way, nor having them in a Table of any kind.

cs_troyk SSCertifiable Points: 5383 More actions · Answer 13

Oops You're absolutely right -- I missed the part about using SQL Server, but now you're adding more conditions...

The only thing that comes to mind is if SQL Server has a built in function to return english numeral names, or if it can call out to a system-supplied function. I'm not aware of such a function in either case. Do you have a solution?

TroyK

Norman Rasmussen Ten Centuries Points: 1055 More actions · Answer 14

Looks like http://en.wikipedia.org/wiki/Einstein's_Puzzle with a coat of paint!

Except that there's a typo with: "Sue has the blue office". Perhaps it should read: "Sue is next to the blue office".

RJ Smith-262986 SSC Enthusiast Points: 110 More actions · Answer 15

Joshua-

In your solution, the Green room is not to the left of the White room....

Who Has The Monitor?

Cookies on SQLServerCentral