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
Go to Top of Page

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."
Go to Top of Page

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
Go to Top of Page

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-)
Go to Top of Page

drymchaser
Aged Yak Warrior

552 Posts

Posted - 2004-03-24 : 13:24:47
Cheers and Congrats!!!





















Go to Top of Page

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-)
Go to Top of Page

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.
Go to Top of Page

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
Go to Top of Page

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-)
Go to Top of Page

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.
Go to Top of Page

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-)
Go to Top of Page

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.
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page

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-)
Go to Top of Page

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.
Go to Top of Page

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-)
Go to Top of Page

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]
Go to Top of Page

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-03-24 : 20:15:12
Congratulations Brett !!
Go to Top of Page

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!
Go to Top of Page
    Next Page

- Advertisement -