Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Reader Challenge #3: Find the Yak!
 Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 3

Page47
Flowing Fount of Yak Knowledge

USA
2878 Posts

Posted - 05/06/2002 :  09:10:18  Show Profile  Reply with Quote
quote:

(... but I am interested in seeing what the winning solution is)



Chadmat,Fribble, whoever . . . I'll show you mine if you show me yours. (Or if you don't have one, in the case of Chad, I can show you mine and you can just look at it.)

<O>
Go to Top of Page

Arnold Fribble
Yak-finder General

United Kingdom
1961 Posts

Posted - 05/06/2002 :  09:22:25  Show Profile  Reply with Quote

CREATE TABLE #n (n int PRIMARY KEY) INSERT #n
SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4
UNION SELECT 5 SELECT CASE WHEN o=a THEN 'DK' WHEN o=b
THEN 'EN' WHEN o =c THEN 'DE' WHEN o=d THEN
'NO'ELSE'SE' END yak FROM (SELECT a.n a ,b.n b,c.n
c,d.n d,15 -a.n-b.n -c.n-d. n e,e.n f,f. n g,g.n h,
h.n i,15 -e.n-f.n-g.n-h.n j,i .n k,j.n l ,k.n m,l.n
n,15-i. n-j.n-k.n-l.n o,m.n p,n.n q,o.n r, p.n s,15
-m.n-n.n -o.n-p.n t,q.n u, r.n v,s. n w,t. n x,15
-q.n-r.n -s.n-t.n y FROM #n a,#n b,#n c, #n d,#n
e,#n f, #n g,#n h, #n i,#n j,#n k, #n l,#n
m,#n n, #n o,#n p,#n q, #n r,#n s,#n t) z WHERE
NOT(b=a OR c IN (a,b)OR d IN(a, b,c))AND NOT(g=

f OR h IN(f,g)OR i IN(f,g,h))AND NOT(l=k OR m IN(k,l)OR n IN(k,l,m))AND NOT(q
=p OR r IN(q,p)OR s IN(q,p,r))AND NOT(v=u OR w IN(u,v)OR x IN(u,v,w))AND q=g
AND x=k AND j=w AND r=3 AND d=1 AND v=p AND 1=ABS(u-l)AND g=i-1 AND 1=ABS(n-w)
AND c=y AND 1=ABS(d-f)AND e=m AND 1=ABS(t-u)AND a=s AND b=h DROP TABLE #n



Go to Top of Page

Page47
Flowing Fount of Yak Knowledge

USA
2878 Posts

Posted - 05/06/2002 :  10:07:44  Show Profile  Reply with Quote
Frib . . . you are certifiable . . . (emailed you my solution . . . at touch slower, and a bit more readable :) )



<O>
Go to Top of Page

chadmat
The Chadinator

USA
1974 Posts

Posted - 05/06/2002 :  19:24:54  Show Profile  Visit chadmat's Homepage  Reply with Quote
Wow AF! You are the Man. I can't make any sense out of it (My eyes glaze over somwhere in the middle of that sub-query), but it gives the correct answer!

Maybe that is why I gave up after about 10 minutes?

-Chad

Go to Top of Page

chadmat
The Chadinator

USA
1974 Posts

Posted - 05/06/2002 :  19:26:43  Show Profile  Visit chadmat's Homepage  Reply with Quote
Page47, You entered this? I didn't think you were around back then? I hear Jay99's answer kicks A** though

-Chad

Go to Top of Page

Arnold Fribble
Yak-finder General

United Kingdom
1961 Posts

Posted - 05/11/2002 :  11:11:34  Show Profile  Reply with Quote
Oh yeah, 6


Go to Top of Page

Arnold Fribble
Yak-finder General

United Kingdom
1961 Posts

Posted - 05/18/2002 :  10:30:03  Show Profile  Reply with Quote
7
sigh.


Go to Top of Page

davidpardoe
Constraint Violating Yak Guru

United Kingdom
324 Posts

Posted - 05/20/2002 :  05:26:28  Show Profile  Reply with Quote
Did antone notice that Mr Fribble's post was formatted to spell a big YAK!

I only just noticed!

============================
Chairman of
The NULL Appreciation Society
"Keep NULLs as NULL"
Go to Top of Page

Arnold Fribble
Yak-finder General

United Kingdom
1961 Posts

Posted - 05/20/2002 :  07:28:20  Show Profile  Reply with Quote
It was a long time ago, and I was young and foolish then.


Go to Top of Page

chadmat
The Chadinator

USA
1974 Posts

Posted - 05/20/2002 :  14:27:21  Show Profile  Visit chadmat's Homepage  Reply with Quote
I don't know if antone noticed, but I did.
J/K

Hey Graz, we need those red squigglies under misspelled words.

-Chad


Go to Top of Page

rrb
SQLTeam Poet Laureate

Australia
1479 Posts

Posted - 05/20/2002 :  19:19:52  Show Profile  Reply with Quote
Who's antone anyway - and why does he keep hitting me?!!!

--
I hope that when I die someone will say of me "That guy sure owed me a lot of money"
Go to Top of Page

chadmat
The Chadinator

USA
1974 Posts

Posted - 05/31/2002 :  15:55:29  Show Profile  Visit chadmat's Homepage  Reply with Quote
9


Go to Top of Page

Page47
Flowing Fount of Yak Knowledge

USA
2878 Posts

Posted - 05/31/2002 :  16:14:56  Show Profile  Reply with Quote
quote:

9



Have you ever tried it?




<O>
Go to Top of Page

Page47
Flowing Fount of Yak Knowledge

USA
2878 Posts

Posted - 06/10/2002 :  10:28:38  Show Profile  Reply with Quote
TEN
Go to Top of Page

Nazim
A custom title

United Arab Emirates
1408 Posts

Posted - 06/10/2002 :  11:47:16  Show Profile  Reply with Quote
Now we better start with abcd

-------------------------
What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

USA
3246 Posts

Posted - 06/14/2002 :  11:54:51  Show Profile  Visit AjarnMark's Homepage  Reply with Quote
Hey Rob!

I believe these are the numbers you were looking for...
7,267,980,000 or if you prefer, 7.26798 e^10

Now, where's the ?



Edited by - AjarnMark on 06/14/2002 11:55:57
Go to Top of Page

Arnold Fribble
Yak-finder General

United Kingdom
1961 Posts

Posted - 06/14/2002 :  16:02:54  Show Profile  Reply with Quote
Not sure I'd pay quite that much to know.


Go to Top of Page

juggler
Starting Member

9 Posts

Posted - 07/09/2002 :  15:17:37  Show Profile  Reply with Quote

14


or did I lose count?
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

USA
4149 Posts

Posted - 07/09/2002 :  16:02:05  Show Profile  Visit graz's Homepage  Reply with Quote
Ok, On Monday -- or maybe sooner depending on proof readers -- I'll post a solution.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page
Page: of 3 Previous Topic Topic Next Topic  
Previous Page
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000