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

Congrats to Peso for winning Adam's challenge!

Author

Topic

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2009-05-31 : 17:14:25

yep the results are in for the last Adam Machanic's Grouped String Concatenation challenge:
http://sqlblog.com/blogs/adam_machanic/archive/2009/05/31/grouped-string-concatenation-the-winner-is.aspx

Peter nailed it on the spot winning one year MSDN subscription!

CONGRATS PETER!!!

___________________________________________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.5 out!

Stoad again
Posting Yak Master

240 Posts

Posted - 2009-05-31 : 17:47:36

I don't know who is Peso but surely he is a kid if compared to these guys: http://www.spoj.pl/ranks/users/
Or these: http://acm.tju.edu.cn/toj/ranklist.html

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2009-05-31 : 17:58:42

just saying congrats would be enough

Stoad again
Posting Yak Master

240 Posts

Posted - 2009-05-31 : 18:17:30

Then: Congrats to Peso!
:)

Stoad again
Posting Yak Master

240 Posts

Posted - 2009-05-31 : 18:40:20

As a follow up:
and all these crowod like graz, nr, robvolk etc
Do you think they like ms sql server?
At first turn they like themselves.

You, Mladen, (you know what I mean)

PS
I knew from Rocko. You visited Stock. Glad for you.
Rock said you are a charming boy ! :)

PS
to all:
if I sounded a bit wicked just ignore it.

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2009-05-31 : 19:43:07

Congratulations Peter!

=================================================
Creating tomorrow's legacy systems today. One crisis at a time.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-05-31 : 22:53:05

[code]
use AdventureWorks

;WITH data(ContactID, Data)
AS
(
SELECT ContactID, Data = left(FirstName, 3)
FROM Person.Contact
WHERE ContactID = 212
UNION ALL
SELECT ContactID, Data = LOWER(STUFF(FirstName, 4, 1, '') + MiddleName + ' ')
FROM Person.Contact
WHERE ContactID = 8495
UNION ALL
SELECT ContactID, Data = FirstName + ' ' + MiddleName
FROM Person.Contact
WHERE ContactID = 19637
)
SELECT '' + x.Data
FROM data AS x
ORDER BY '' + x.ContactID
FOR XML PATH('')
[/code]

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

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-06-01 : 02:40:58

Well done Peso. Keep it up

Madhivanan

Failing to plan is Planning to fail

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-01 : 04:47:56

Thank you all for the fabulous congrats-party!

quote:

Originally posted by khtan

WITH data(ContactID, Data)
AS
(
	SELECT	ContactID, Data = left(FirstName, 3)
	FROM	Person.Contact
	WHERE	ContactID	= 212
	UNION ALL
	SELECT	ContactID, Data = LOWER(STUFF(FirstName, 4, 1, '') + MiddleName + ' ')
	FROM	Person.Contact
	WHERE	ContactID	= 8495
	UNION ALL
	SELECT	ContactID, Data = FirstName + ' ' + MiddleName
	FROM	Person.Contact
	WHERE	ContactID	= 19637
)
SELECT	'' + x.Data
FROM 	data AS x 
ORDER BY '' + x.ContactID
FOR XML PATH('')

This evaluates as

Congrats Peter L

I think it's really time for khtan to earn a custom title!

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

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2009-06-01 : 13:07:06

Grats to our resident Entry Level DBA™

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL or How to sell Used Cars
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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-06-01 : 13:32:17

Very cool, congrats Peter!

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-01 : 13:52:07

Thank you both!

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

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2009-06-01 : 14:30:34