The Big 4 Oh Oh Oh - 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

The Big 4 Oh Oh Oh

Author

Topic

JustinBigelow
SQL Gigolo

1157 Posts

Posted - 2004-03-24 : 12:15:40

Everybody raise a wrist or two for Brett.

Justin

"Hit me with a shovel 'cause I can't believe I dug you."

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-03-24 : 12:30:42

Congratulations, Brett!

Have an extra margarita on us while skiing this weekend.

Tara

JustinBigelow
SQL Gigolo

1157 Posts

Posted - 2004-03-24 : 12:32:47

quote:
Have an extra margarita on us while skiing this weekend.

What kind of person waits until the weekend to have a margarita? Don't tell me you skip breakfast.

Justin

"Hit me with a shovel 'cause I can't believe I dug you."

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2004-03-24 : 13:08:53

I was going to put 4000 but why break the server.

Hey Bill when he makes 5000 can we get a margarita Smilie ????
Jim
Users <> Logic

X002548
Not Just a Number

15586 Posts

Posted - 2004-03-24 : 13:14:57

Shake....shake....shake...

Man I'm going to need a big shaker for all these margaritas I gotta pour for all the poeple who have helped me....

[margarita]

Nope...damn...

Anyway, Thanks everyone for all the help AND for all the kind words....

Brett

8-)

drymchaser
Aged Yak Warrior

552 Posts

Posted - 2004-03-24 : 13:24:47

Cheers and Congrats!!!

X002548
Not Just a Number

15586 Posts

Posted - 2004-03-24 : 13:35:07

Thanks Preston...that's just great...

Is that with or without salt?

Brett

8-)

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2004-03-24 : 14:54:03

Well Done Brett!

Try this:
Ensure that your results pane in qa is set to Text and the font is Courier.

Then run this code:

--******************************************************

SET NOCOUNT ON

DECLARE @InpString VARCHAR(4000)
DECLARE @CharCT INT
DECLARE @PrevY INT
DECLARE @CurrX INT
DECLARE @CurrY INT
DECLARE @InpRow VARCHAR(4000)
DECLARE @RowCT INT

SET @RowCT = 1
SET @InpString = '04040404080409041004110415041604170418042204230424042504'
SET @InpString = @InpString + '030503050405070512051405190521052605'
SET @InpString = @InpString + '030603060406070612061406190621062606'
SET @InpString = @InpString + '020702070407070712071407190721072607'
SET @InpString = @InpString + '020802080408070812081408190821082608'
SET @InpString = @InpString + '010901090409070912091409190921092609'
SET @InpString = @InpString + '011001100410071012101410191021102610'
SET @InpString = @InpString + '0011001101110211031104110511071112111411191121112611'
SET @InpString = @InpString + '04120412071212121412191221122612'
SET @InpString = @InpString + '04130413081309131013111315131613171318132213231324132513'

CREATE TABLE #Stuff(X INT, Y INT)
CREATE TABLE #BK(BID INT, B VARCHAR(4000))

SET @CharCT = 1

WHILE @CharCT < LEN(@InpString)
BEGIN
INSERT INTO #Stuff VALUES(CAST(SUBSTRING(@InpString, @CharCT, 2) as INT) + 1, SUBSTRING(@InpString, @CharCT + 2, 2))
SET @CharCT = @CharCT + 4
END

DECLARE BrettCur
CURSOR FOR
SELECT * FROM #Stuff
ORDER BY 2

SET @InpRow = ''

OPEN BrettCur
FETCH NEXT FROM BrettCur INTO @CurrX, @CurrY
SET @CharCT = 0
SET @PrevY = @CurrY
WHILE @@FETCH_STATUS = 0
BEGIN
IF @CurrY = @PrevY
BEGIN
WHILE @CharCT < @CurrX
BEGIN
SET @InpRow = @InpRow + ' '
SET @CharCT = @CharCT + 1
END
SET @InpRow = @InpRow + '@'
SET @CharCT = @CharCT + 1
END
ELSE
BEGIN
INSERT INTO #BK VALUES(@PrevY, @InpRow)
SET @CharCT = 0
SET @PrevY = @CurrY
SET @InpRow = ''
END
FETCH NEXT FROM BrettCur INTO @CurrX, @CurrY
END

CLOSE BrettCur
DEALLOCATE BrettCur

INSERT INTO #BK VALUES(99, @InpRow)

SELECT B
FROM #BK
ORDER BY BID

DROP TABLE #Stuff
DROP TABLE #BK

--************************************************************

Cheers!

Duane.

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2004-03-24 : 15:09:14

Wow! There's some impressive stuff in this thread !

Congratulations Mr. Brett !!!

- Jeff

X002548
Not Just a Number

15586 Posts

Posted - 2004-03-24 : 15:15:09

Duane,

I'm honored...

How long did that take you to write?

Mind if I poist it in my blog...I'll make sure to identify the author...

Brett

8-)

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2004-03-24 : 15:18:37

Brett!
Go 4 IT!
Took about 1/2 hour.

It's after hours here now. 22H20 - so it didn't interfere with my normal work (in case anyone is wondering)

Cheers!

Duane.

X002548
Not Just a Number

15586 Posts

Posted - 2004-03-24 : 15:47:51

Done:

http://weblogs.sqlteam.com/brettk/archive/2004/03/24/1110.aspx

Brett

8-)

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-03-24 : 16:02:34

Wow, you are sooooo old.

Happy Birthday.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

SamC
White Water Yakist

3467 Posts

Posted - 2004-03-24 : 16:18:48

To the tune of "La Cucaracha"

Con-gra-tu-la-tions !
Con-gra-tu-la-tions !

Thank me later for stopping there.

Sam

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-03-24 : 16:23:25

WOW 4000
Congrats Brett!

Just as well these user accounts aren't companies or I think we would see Tara stage a hostile takeover of Brett to aquire his post count and lay him off. Then she would use her monopoly position to crush her competitors

Damian

X002548
Not Just a Number

15586 Posts

Posted - 2004-03-24 : 16:25:01

quote:
Originally posted by derrickleggett

Wow, you are sooooo old.

Happy Birthday.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Old, well you're as old as you feel...and I feel like a margarita....

And it's not my bday...stop rushing me to my grave...I'm doing a good enough job on my own..

Sam, yes, thanks for stopping...damn thing is ringing my head now...

Have to fix that...

Another good excuse for a margarita....

Brett

8-)

SamC
White Water Yakist

3467 Posts

Posted - 2004-03-24 : 16:25:49

to the tone of a horse track announcer:

It's Robvolk, in the lead by a two full millenia !

With nr, charging up behind, followed by Tara, Princess Warrior closing the gap rapidly..

And then it's Brett, "Not just a number" picking up steam in position number 4.

X002548
Not Just a Number

15586 Posts

Posted - 2004-03-24 : 17:00:39

quote:
Originally posted by Merkin

WOW 4000
Congrats Brett!

Just as well these user accounts aren't companies or I think we would see Tara stage a hostile takeover of Brett to aquire his post count and lay him off. Then she would use her monopoly position to crush her competitors

Damian

Got a kick ouf that...

Well it's that time of the day again...

But today for me is FRIDAY...

Pack up the car and the kiddies...

I'M GOING SKIING

Hav a good rest the week everyone, and Thanks again..

http://www.mountsnow.com/index.html

quote:

So I'll put on my Bob Marley tape
And practice what I preach
Get Ja lost in the reggae mon
As I walk along the beach

--JB

Brett

8-)

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2004-03-24 : 19:14:25

Wow, Brett, WAY TO GO!!!!

It's good to see SQLTeam prosper like this! Now, if we could just come up with a good revenue stream and get Damian to PASS. Or better yet, send the 1000+ crowd to visit him in OZ!

--------------------------------------------------------------
Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url]

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-03-24 : 20:15:12

Congratulations Brett !!

Amethystium
Aged Yak Warrior

701 Posts

Posted - 2004-03-25 : 03:49:28

quote:
Originally posted by drymchaser

Cheers and Congrats!!!

Very nice... I am impressed.

________________
Make love not war!

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources