6k to Michael Valentine Jones - SQL Server Forums

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.

All Forums

Site Related Forums

The Yak Corral

6k to Michael Valentine Jones

Author

Topic

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-11-11 : 15:05:00

Congrats!

I am a little late but I think it is ok.

No, you're never too old to Yak'n'Roll if you're too young to die.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-11-11 : 15:06:59

I think it's ok.

Congrats Michael!

N 56°04'39.26"
E 12°55'05.63"

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-11-11 : 20:37:45

[code]
select 'Congrats MVJ'
from F_TABLE_NUMBER_RANGE(1, 6000)
[/code]

KH
[spoiler]Time is always against us[/spoiler]

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-11-11 : 20:46:52

[code]
select 'Congrats MVJ'
from F_TABLE_DATE('20080602', '20091111')
[/code]

KH
[spoiler]Time is always against us[/spoiler]

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-11-12 : 01:20:19

quote:
Originally posted by khtan

select 'Congrats MVJ'
from F_TABLE_DATE('20080602', '20091111')

KH
[spoiler]Time is always against us[/spoiler]

Those who dont know that TVF may complain about this error
Msg 208, Level 16, State 1, Line 3
Invalid object name 'F_TABLE_DATE'.

Madhivanan

Failing to plan is Planning to fail

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-11-12 : 01:21:14

[code]select
MVJ=[datetime]
from
(
select cast(0x436F6E67726174756C6174696F6E7320746F204461746574696D65205370656369616C697374 as varchar(100)) as [datetime]
) t
union all
select 'Keep it up'
[/code]

Madhivanan

Failing to plan is Planning to fail

learntsql

524 Posts

Posted - 2009-11-12 : 01:33:16

Hearlty Congrats!!
Keep it up.....

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2009-11-12 : 11:32:49

Congratulations! I have a folder called "UsefulThings" that has a whole buch of your code in it!

Jim

Everyday I learn something that somebody else already knew

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2009-11-12 : 12:38:51

Really? I have a folder called "Peso", but it pops up in a browser with "SQLTEAM.com" in the address bar

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2009-11-12 : 12:40:22

Thank you everyone!

It’s been a long time since 5K, but I'm not an iron man like Peter and Visakh.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=103992 id="size1">

CODO ERGO SUM

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-11-12 : 12:58:23

quote:
Originally posted by Michael Valentine Jones

It’s been a long time since 5K, but I'm not an iron man like Peter and Visakh.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=103992 id="size1">
CODO ERGO SUM

Well, you're on a faster pace than me :)

Great Work !!

Be One with the Optimizer
TG

X002548
Not Just a Number

15586 Posts

Posted - 2009-11-12 : 13:51:30

Where's THE List?

Ohn and many thanks and congrats!

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2009-11-12 : 14:16:41

quote:
Really? I have a folder called "Peso", but it pops up in a browser with "SQLTEAM.com" in the address bar

I keep Peso's stuff in a drawer called "MyOwnBriliantSolutionsThatIFiguredOutAllByMyself"

Jim

Everyday I learn something that somebody else already knew

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-11-13 : 03:17:21

quote:
Originally posted by jimf

quote:
Really? I have a folder called "Peso", but it pops up in a browser with "SQLTEAM.com" in the address bar

I keep Peso's stuff in a drawer called "MyOwnBriliantSolutionsThatIFiguredOutAllByMyself"

Jim

Everyday I learn something that somebody else already knew

We know!

No, you're never too old to Yak'n'Roll if you're too young to die.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources