Merry Christmas Everyone :)

Question

Post reply

Merry Christmas Everyone :)

paul.goldstraw

SSCrazy

Points: 2626
More actions
December 24, 2013 at 5:13 am

#104224

DECLARE @3 TABLE ([2] int,j varchar(20), w varchar(50));declare @b-2 table (g int,[1] varchar(10));declare @1 char(1) = char((40-8));declare @a varchar(10) = char(79) + char(110) ;DECLARE @C varchar(max) = Char(84)+Char(104)+Char(101)+Char(32)+Char(84)+Char(119)+Char(101)+Char(108)+Char(118)+Char(101)+Char(32)+Char(68)+Char(97)+Char(121)+Char(115)+Char(32)+Char(79)+Char(102)+Char(32)+Char(67)+Char(104)+Char(114)+Char(105)+Char(115)+Char(116)+Char(109)+Char(97) + char(115);
declare @2 varchar(10) = replace(@a,reverse( char(110) +char(79)),char(((22*5)+6)) + char(abs(-104)) + char(floor((4792.45/47.1))));DECLARE @d varchar(20) = char(13) + CHAR(32) + CHAR(44) + CHAR(101) + CHAR(77) + CHAR(32) + CHAR(111) + CHAR(84) + CHAR(32) + CHAR(101) + CHAR(118) + CHAR(97) + CHAR(71) + CHAR(32) + CHAR(101) + CHAR(118) ;DECLARE @h varchar(15) = CHAR(111) + CHAR(76) + CHAR(32) + CHAR(101) + CHAR(117) + CHAR(114) + CHAR(84) + CHAR(32) + CHAR(121) + CHAR(77) + CHAR(32) + CHAR(115) + CHAR(97) + CHAR(109) + CHAR(116) ;
DECLARE @v-2 varchar(15) = CHAR(115) +CHAR(105) + CHAR(114) + CHAR(104) + CHAR(67) + CHAR(32) + CHAR(102) + CHAR(79) + CHAR(32) + CHAR(121) + CHAR(97) + CHAR(68) + CHAR(32);DECLARE @U varchar(100) = char((9*5)) + char((power(10,2)-3)) + char((39 + (26%10))) ;INSERT INTO @3 VALUES (18,char(70) +char(105) +char(114) +char(115) +char(116),Char(65)+Char(32)+Char(80)+Char(97)+Char(114)+Char(116)+Char(114)+Char(105)+Char(100)+Char(103)+Char(101)+Char(32)+Char(73)+Char(110)+Char(32)+Char(97)+Char(32)+Char(80)+Char(101)+Char(97)+Char(114)+Char(32)+Char(84)+Char(114)+Char(101)+Char(101)),
( 21,char(83) +char(101) +char(99) +char(111) +char(110) +char(100),Char(84)+Char(117)+Char(114)+Char(116)+Char(108)+Char(101)+Char(32)+Char(68)+Char(111)+Char(118)+Char(101)+Char(115)),( 26,char(84) +char(104) +char(105) +char(114) +char(100),Char(70)+Char(114)+Char(101)+Char(110)+Char(99)+Char(104)+Char(32)+Char(72)+Char(101)+Char(110)+Char(115)),( 33,char(70) +char(111) +char(117) +char(114) +char(116) +char(104),Char(67)+Char(97)+Char(108)+Char(108)+Char(105)+Char(110)+Char(103)+Char(32)+Char(66)+Char(105)+Char(114)+Char(100)+Char(115)),
( 42,char(70) +char(105) +char(102) +char(116) +char(104),Char(71)+Char(111)+Char(108)+Char(100)+Char(32)+Char(82)+Char(105)+Char(110)+Char(103)+Char(115)),( 53,char(83) +char(105) +char(120) +char(116) +char(104),Char(71)+Char(101)+Char(101)+Char(115)+Char(101)+@u+Char(76)+Char(97)+Char(121)+Char(105)+Char(110)+Char(103)),( 66,char(83) +char(101) +char(118) +char(101) +char(110) +char(116) +char(104),Char(83)+Char(119)+Char(97)+Char(110)+Char(115)+@u+Char(83)+Char(119)+Char(105)+Char(109)+Char(109)+Char(105)+Char(110)+Char(103)),
( 81,char(69) +char(105) +char(103) +char(104) +char(116) +char(104),Char(77)+Char(97)+Char(105)+Char(100)+Char(115)+@u+Char(77)+Char(105)+Char(108)+Char(107)+Char(105)+Char(110)+Char(103)),( 98,char(78) +char(105) +char(110) +char(116) +char(104),Char(76)+Char(97)+Char(100)+Char(105)+Char(101)+Char(115)+Char(32)+Char(68)+Char(97)+Char(110)+Char(99)+Char(105)+Char(110)+Char(103)),( 117,char(84) +char(101) +char(110) +char(116) +char(104),Char(76)+Char(111)+Char(114)+Char(100)+Char(115)+@u+Char(76)+Char(101)+Char(97)+Char(112)+Char(105)+Char(110)+Char(103)),
( 138,char(69) +char(108) +char(101) +char(118) +char(101) +char(CEILING((13603.392 / 124.3))) +char(116) + char(104),Char(80)+Char(105)+Char(112)+Char(101)+Char(114)+Char(115)+Char(32)+Char(80)+Char(105)+Char(112)+Char(105)+Char(110)+Char(103)),( 161,char(84) +char(119) +char(101) +char(108) +char(102) +char(116) +char(104),Char(68)+Char(114)+Char(117)+Char(109)+Char(109)+Char(101)+Char(114)+Char(115) + CHAR(32) +Char(68)+Char(114)+Char(117)+Char(109)+Char(109)+Char(105)+Char(110)+Char(103));WITH g AS (SELECT top ((700-(7*4))/56) ROW_NUMBER() OVER (ORDER BY s.id) AS n FROM sys.syscolumns s)
SELECT @C = @C + case when x.n = k.n THEN char(13) + char(10) + char(13) + char(10) + @a + @1 + @2 + @1 + rtrim(r2.j) + reverse (@d + @h + @v-2) ELSE ',' + char(13) + char(10) end + case when x.n = 1 THEN CASE WHEN x.n = k.n THEN '' ELSE char(65)+ char(110) + char(100) + char(32) END else cast((sqrt((r1.[2]-17))) AS varchar(10)) + @1 END + r1.w FROM g k CROSS JOIN g x INNER JOIN @3 r1 ON x.n = (sqrt((r1.[2]-17))) INNER JOIN @3 r2 ON k.n = (sqrt((r2.[2]-17))) WHERE x.n <= k.n ORDER BY k.n asc,x.n DESC; SELECT @C
Obfuscation with a festive theme 🙂

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 1

Beatrix Kiddo

SSC-Dedicated

Points: 32407

December 24, 2013 at 5:23 am

#1675755

Very good :-D. Merry Christmas.

Ron McCullough SSC Guru Points: 63877 More actions · Answer 2

For those that want to hear what I want for Christmas ....

http://www.songfacts.com/detail.php?id=9570

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

I hope everyone had a safe and Merry Christmas this year.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Steve Jones - SSC Editor SSC Guru Points: 736193 More actions · Answer 4

Nice!

Thanks, and a belated Merry Christmas and Happy Holiday.

Jeff Moden SSC Guru Points: 1004329 More actions · Answer 5

bitbucket-25253 (12/24/2013)
For those that want to hear what I want for Christmas ....
http://www.songfacts.com/detail.php?id=9570

Speaking of Christmas, I got a nice present just before the holiday. One of my sessions was accepted for SQL Saturday in Cleveland. I'm looking forward to see you and Steve in Feb, ol' friend.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)