Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

This blog is syndicated from http://phelabaum.com and will contain most of the posts from that site.
Browse by Tags · View All
SQL Server 7
BRH 7
SCSUG 5
#SQL Server 4
SSMS 4
#TSQL 4
Goals 4
T-SQL 4
Tips &amp 3
Tricks 3

Archive · View All
April 2010 10
June 2010 5
September 2011 3
April 2011 2
February 2011 2
January 2011 2
May 2010 2
July 2010 1

A T-SQL Holiday Message

Apr 4 2010 12:03AM by Garadin   

Totally pointless, but fun.  Run it to decode the message.

DECLARE @Message varchar(20)
SET @Message = '????????????'

DECLARE @Decode Table(
DSeq tinyint, 
DKey smallint
)
INSERT INTO @Decode(DSeq, DKey)
VALUES(1,9),(2,2),(3,17),(4,17),(5,26),(6,6),(7,2),(8,20),(9,21),(10,6),(11,19)

; WITH
Decoder AS (
    SELECT D.DSeq N,
    CHAR( D.DKey + ASCII(SUBSTRING(@Message,D.DSeq,1)) ) DV
    FROM @Decode D),
Conc (S) AS (
    SELECT DV + ''
    FROM Decoder D
    ORDER BY D.N
    FOR XML PATH(''))
 
SELECT STUFF(S,6,0,' ') [Surprise]
FROM Conc

Tags: T-SQL,


Garadin
59 · 3% · 941
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

2  Comments  

  • Good. This reminded my post http://beyondrelational.com/blogs/madhivanan/archive/2009/12/31/happy-holidays.aspx

    commented on Apr 9 2010 8:44AM
    Madhivanan
    3 · 39% · 12472
  • Hah, good stuff. I like yours more =)

    commented on Apr 9 2010 11:19AM
    Garadin
    59 · 3% · 941

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]