Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Merry Christmas Everyone :) Expand / Collapse
Author
Message
Posted Tuesday, December 24, 2013 5:13 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 5:13 AM
Points: 1,029, Visits: 1,394
DECLARE @3 TABLE ([2] int,j varchar(20), w varchar(50));declare @b 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 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) 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 :)
Post #1525727
Posted Tuesday, December 24, 2013 5:23 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 10:04 AM
Points: 453, Visits: 1,671
Very good . Merry Christmas.
Post #1525729
Posted Tuesday, December 24, 2013 6:44 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:28 AM
Points: 5,573, Visits: 24,808
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

Before posting a performance problem please read
Post #1525741
Posted Thursday, December 26, 2013 9:54 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 1:50 PM
Points: 3,978, Visits: 2,994
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
Post #1526079
Posted Friday, January 3, 2014 8:52 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:10 PM
Points: 33,095, Visits: 15,202
Nice!

Thanks, and a belated Merry Christmas and Happy Holiday.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1527585
Posted Friday, January 3, 2014 9:13 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:47 PM
Points: 36,781, Visits: 31,238
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1527777
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse