Please start any new threads on our new site at http://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
 The Yak Corral
 Simple Quiz
 Reply to Topic
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 36

madhivanan
Premature Yak Congratulator

India
22864 Posts

Posted - 04/18/2005 :  07:34:01  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
quote:
Originally posted by Kristen


SELECT TallyNo, 
	[Letter]=SUBSTRING(CONVERT(varchar, 
			CONVERT(datetime, '2000-' 
					+ RIGHT('0'+CONVERT(varchar, TallyNo), 2) 
					+ '-01'), 113),
			4, 1)
FROM	
(	SELECT	[TallyNo] = 1 
	UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5
	UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9
	UNION ALL SELECT 10 UNION ALL SELECT 11 UNION ALL SELECT 12
) Tally




Excellent Kristen

Which word when pronounced wrong is right and right is wrong?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Kristen
Test

United Kingdom
22859 Posts

Posted - 04/18/2005 :  09:39:33  Show Profile  Reply with Quote
Well the first occurrence of "wrong" in that sentence should be spelt, and pronounced, "wrongly"
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22864 Posts

Posted - 04/18/2005 :  09:55:38  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
You are asked to choose any one of the following options

(1) Everyday you get $10000 for 30 days
(2) First Day you get $1, second day $2, third day $4 ...... for 30 days

Which one do you prefer?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Kristen
Test

United Kingdom
22859 Posts

Posted - 04/18/2005 :  11:52:25  Show Profile  Reply with Quote
I'll have (1) and the wife can have (2) please ... Humans were not intended to understand the difference between linear and exponential growth.

You fold a piece of paper in half 50 times, how thick will it be?
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22864 Posts

Posted - 04/19/2005 :  00:58:06  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
quote:
I'll have (1) and the wife can have (2)

You are too ambitioius Kristan :)

It depends on the thickness of paper. Anyway it will be 2^50 times thicker(enough to reach moon or sun)

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11752 Posts

Posted - 04/19/2005 :  05:41:51  Show Profile  Visit spirit1's Homepage  Reply with Quote
not to mention that there's no piece of paper that can be folded more that 8 times.

Go with the flow & have fun! Else fight the flow
Go to Top of Page

Kristen
Test

United Kingdom
22859 Posts

Posted - 04/19/2005 :  08:23:20  Show Profile  Reply with Quote
See I told you humans don't understand exponential growth ... "enough to reach moon or sun" there is a significant difference between those two units!

And you can fold paper 11 times ...

Kristen
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22864 Posts

Posted - 04/19/2005 :  09:05:12  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
Well

There are four persons A,B,C and D
Two of them are liars and others are not

A says B is a liar
B says C is a liar
C says D is a liar
D says A is a liar

Who are not liars and why?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

rockmoose
SQL Natt Alfen

Sweden
3279 Posts

Posted - 04/19/2005 :  12:28:12  Show Profile  Reply with Quote
set nocount on
select 'A' as bloke into #person union select 'B' union select 'C' union select 'D'
select 'A' as bloke,'B' as bloke_isliar into #proposition union select 'B','C' union select 'C','D' union select 'D','A'

select liar1.bloke as liar1, liar2.bloke as liar2
from
	#person liar1 join #person liar2 on liar1.bloke < liar2.bloke
	cross join #proposition p
where
(
	(p.bloke <> liar1.bloke and p.bloke <> liar2.bloke)
	and
	(p.bloke_isliar = liar1.bloke or p.bloke_isliar = liar2.bloke)
)
or
(
	(p.bloke = liar1.bloke or p.bloke = liar2.bloke)
	and
	(p.bloke_isliar <> liar1.bloke and p.bloke_isliar <> liar2.bloke)
)
group by liar1.bloke, liar2.bloke
having count(*) = 4 -- true propositions

drop table #person
drop table #proposition


rockmoose
Go to Top of Page

rockmoose
SQL Natt Alfen

Sweden
3279 Posts

Posted - 04/19/2005 :  13:43:05  Show Profile  Reply with Quote
The old Yak herder had 3 sons, and when he died he left 17 Yaks to be split among them.
His last will stated that:
the oldest son should have 1/2 the Yaks,
his second son should have 1/3 of the Yaks,
and his youngest son should have 1/9 of the Yaks.

These were holy Yaks, so the sons could not slaughter them.
They thought for a while and finally managed to split the Yaks between them.

How did they do it ?

rockmoose
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11752 Posts

Posted - 04/19/2005 :  13:53:25  Show Profile  Visit spirit1's Homepage  Reply with Quote
9+6+2
but i think you forgot the wise man with his yak

Go with the flow & have fun! Else fight the flow

Edited by - spirit1 on 04/19/2005 13:53:55
Go to Top of Page

TG
Flowing Fount of Yak Knowledge

USA
6065 Posts

Posted - 04/19/2005 :  13:59:25  Show Profile  Reply with Quote
Edit:


1/2 = 9/18
1/3 = 6/18
1/9 = 2/18

9+6+2=17

Oldest son: 9
Second son: 6
Youngest: 2

2 for 1:
What is the answer to this question?
4966206120636869636B656E20616E6420612068616C66206C61797320616E6420656
76720616E642068616C6620696E20612064617920616E6420612068616C662C20686F
77206D616E7920656767732077696C6C206F6E6520636869636B656E206C617920696
E206F6E65206461793F

Be One with the Optimizer
TG

Edited by - TG on 04/19/2005 14:25:25
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11752 Posts

Posted - 04/19/2005 :  14:11:37  Show Profile  Visit spirit1's Homepage  Reply with Quote
0x322F3320656767

man you have no idea what you started with this, TG.
we already had a thread with this hex stuff...

Go with the flow & have fun! Else fight the flow
Go to Top of Page

TG
Flowing Fount of Yak Knowledge

USA
6065 Posts

Posted - 04/19/2005 :  14:24:23  Show Profile  Reply with Quote
LOL :) Every year or so, starting when I was about 6 years old, my father would ask me that question (in English not hex) He'd never tell me the answer. I think I was about 25 when I finally got it. (I wasn't such a good student in school, if you couldn't already tell)

Be One with the Optimizer
TG
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11752 Posts

Posted - 04/19/2005 :  14:31:28  Show Profile  Visit spirit1's Homepage  Reply with Quote
smart dad.
if he asked you that in hex and you answered in binary, you'd be using real programmers keyboard now.
with only 3 buttons 0,1 and return.

Go with the flow & have fun! Else fight the flow
Go to Top of Page

TG
Flowing Fount of Yak Knowledge

USA
6065 Posts

Posted - 04/19/2005 :  14:50:58  Show Profile  Reply with Quote
Well that would certainly make typing easier...
Spirit1, I left you a message yesterday in one of my posts. I was sure I'd hear from you telling me exactly what episode I was talking about (and probably correcting my quote).
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=48565

Be One with the Optimizer
TG
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11752 Posts

Posted - 04/19/2005 :  15:20:48  Show Profile  Visit spirit1's Homepage  Reply with Quote
haven't acctually seen the post because yesterday i just checked the yak coral and that was it.
but now as i look at it i must say that i have absolutly no idea what's it about.
give the 5th light!

Go with the flow & have fun! Else fight the flow
Go to Top of Page

TG
Flowing Fount of Yak Knowledge

USA
6065 Posts

Posted - 04/19/2005 :  16:02:17  Show Profile  Reply with Quote
That's hilarious! Remember the S.T. Next Generation episode when Picard was being held and tortured by the Cardassians? The guy was trying to "break" Picard, and one of the things he was trying to do was make Picard say that he saw 5 lights when if fact there were clearly only 4? That's what the comma discussion reminded me of.

Edit: you were one the StarTrek geeks that knew answers to every question asked in that Enterprise thread, weren't you?

Be One with the Optimizer
TG

Edited by - TG on 04/19/2005 16:03:31
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11752 Posts

Posted - 04/19/2005 :  16:11:31  Show Profile  Visit spirit1's Homepage  Reply with Quote
yeah...
but i really don't remember that one.
but man, you sure do have some weird associations....
commas -> lights -> star trek -> picard
... of course!! how could i miss that logical connection

Go with the flow & have fun! Else fight the flow
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22864 Posts

Posted - 04/21/2005 :  06:40:10  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
A vehicle is travelling at the speed of 30 mph. What should be the speed in return so that average speed is 60 mph?



Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
Page: of 36 Previous Topic Topic Next Topic  
Previous Page | Next Page
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.41 seconds. Powered By: Snitz Forums 2000