Monday, October 10, 2005
Good News!
I am committed that I will be posting only things that are 'SQL', not anything personal, here.
But what will I do when I have some great news to tell you guys?
Hmmm.. I will tell that in an SQL (read crazy) way.
So here you go.
SELECT
CHAR(LEFT(P.m,2)) +
CHAR(SUBSTRING(P.m,3,2^1)) +
CHAR(SUBSTRING(P.m,6,~2 * -1)) +
CHAR(RIGHT(P.m,(-3 & 4 -1))) +
SPACE(1)+
STUFF(REPLACE(STUFF(OBJECT_NAME(1), 1, 4, ''),'j',''),4,1,REVERSE('emo'))+
SPACE(1)+ CHAR(ASCII('`')+1)+ SPACE(1)+
LEFT(@@VERSION,20)+
SPACE(1)+ UPPER(LEFT(DB_NAME(1),1))+
CHAR(CAST(LEFT(P.m,2) AS INT)+4)+
CONVERT(CHAR(2), 0x5021) AS [Good News]
FROM
(SELECT REVERSE(V.hugo+V.adam+V.david+V.louis)
FROM
(SELECT
CAST(M.a AS VARCHAR) AS thanksto_JCelko,
CAST(M.a + POWER(8^2,DB_ID('tempdb')) AS VARCHAR) AS thanksto_Sommarskog,
REPLICATE(DB_ID('master'),3) As thanksto_ItzikBenGan,
CAST(M.s AS VARCHAR) As thanksto_Tibor
FROM
(SELECT
(DB_ID('msdb') + 1) * POWER(10,DB_ID('tempdb')) + 1 AS thanksto_ASen,
DATEDIFF(yy, '19760509','20051007')-1 AS thanksto_SKass) As M(a,s)
)AS V(hugo, adam, david, louis)) P(m)
UNION ALL
SELECT CONVERT(VARCHAR, 0x5468616E6B7320746F20796F7520616C6C21)
-- :)