I Am Bored
-
If you are truly bored, here is something to play with. Execute in management studio
WITH
XGEN(X, IX) AS (
SELECT CAST(-2.2 AS FLOAT) AS X, 0 AS IX UNION ALL
SELECT CAST(X + 0.031 AS FLOAT) AS X, IX + 1 AS IX
FROM XGEN
WHERE IX < 100
),
YGEN(Y, IY) AS (
SELECT CAST(-1.5 AS FLOAT) AS Y, 0 AS IY UNION ALL
SELECT CAST(Y + 0.031 AS FLOAT) AS Y, IY + 1 AS IY
FROM YGEN
WHERE IY < 100
),
Z(IX, IY, CX, CY, X, Y, I) AS (
SELECT IX, IY, X, Y, X, Y, 0
FROM XGEN, YGEN
UNION ALL
SELECT IX, IY, CX, CY, X * X - Y * Y + CX AS X, Y * X * 2 + CY, I + 1
FROM Z
WHERE X * X + Y * Y < 16
AND I < 100
)
SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
(X0+X1+X2+X3+X4+X5+X6+X7+X8+X9+X10+X11+X12+X13+X14+X15+X16+X17+X18+X19+
X20+X21+X22+X23+X24+X25+X26+X27+X28+X29+X30+X31+X32+X33+X34+X35+X36+X37+X38+X39+
X40+X41+X42+X43+X44+X45+X46+X47+X48+X49+X50+X51+X52+X53+X54+X55+X56+X57+X58+X59+
X60+X61+X62+X63+X64+X65+X66+X67+X68+X69+X70+X71+X72+X73+X74+X75+X76+X77+X78+X79+
X80+X81+X82+X83+X84+X85+X86+X87+X88+X89+X90+X91+X92+X93+X94+X95+X96+X97+X98+X99),
'A',' '), 'B','.'), 'C',','), 'D',','), 'E',','), 'F','-'), 'G','-'),
'H','-'), 'I','-'), 'J','-'), 'K','+'), 'L','+'), 'M','+'), 'N','+'),
'O','%'), 'P','%'), 'Q','%'), 'R','%'), 'S','@'), 'T','@'), 'U','@'),
'V','@'), 'W','#'), 'X','#'), 'Y','#'), 'Z',' ')
FROM (
SELECT 'X' + CAST(IX AS VARCHAR) AS IX,
IY, SUBSTRING('ABCDEFGHIJKLMNOPQRSTUVWXYZ', ISNULL(NULLIF(I, 0), 1), 1) AS I
FROM Z) ZT
PIVOT (
MAX(I) FOR IX IN (
X0,X1,X2,X3,X4,X5,X6,X7,X8,X9,X10,X11,X12,X13,X14,X15,X16,X17,X18,X19,
X20,X21,X22,X23,X24,X25,X26,X27,X28,X29,X30,X31,X32,X33,X34,X35,X36,X37,X38,X39,
X40,X41,X42,X43,X44,X45,X46,X47,X48,X49,X50,X51,X52,X53,X54,X55,X56,X57,X58,X59,
X60,X61,X62,X63,X64,X65,X66,X67,X68,X69,X70,X71,X72,X73,X74,X75,X76,X77,X78,X79,
X80,X81,X82,X83,X84,X85,X86,X87,X88,X89,X90,X91,X92,X93,X94,X95,X96,X97,X98,X99)
) AS PZTIt won't zoom in, damn it! :laugh:
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952) Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
-
Go away! I don't like women with lisps.
-
Oh, I think its great. At least you wont deal with VB(I hope so) I was following some of your posts. Just I had no way to help you :( I am sure you will find a better job. And screw that firm, they didn't know what they had :)
Microsoft ... the only place where VARIANT_TRUE != true
Argonia wrote:
I had no way to help
You help just by being you.
You'll never get very far if all you do is follow instructions.
-
I dunap
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
-
Hey Guys, I am bored..! How about you? Could anyone share a joke...for me...??
-
It's your mother-in-law, you dimwit. Who do you think it was the Pope? You forgot that we're coming this weekend, didn't you? Now, turn off that computer thingie of yours. You'll be painting the whole house in a different color we picked from a catalog earlier with our daughter, you lazy bum.
-
Hey Guys, I am bored..! How about you? Could anyone share a joke...for me...??
Microsoft started to support VB 6.0 Again...
-
Hey Guys, I am bored..! How about you? Could anyone share a joke...for me...??
srinivas vadepally wrote:
I am bored..!
When I'm bored I look around my social network connections for a picture with at least three girl acquaintances on it and drop a comment to the tone of "you two gals look awesome!". Brace for the ensuing drama :cool:
-
srinivas vadepally wrote:
Could share any joke
Michael Gove
Didn't you mean Ed Balls?
Regards, Rob Philpott.
-
Microsoft started to support VB 6.0 Again...
-
Hey Guys, I am bored..! How about you? Could anyone share a joke...for me...??
-
srinivas vadepally wrote:
I am bored..!
When I'm bored I look around my social network connections for a picture with at least three girl acquaintances on it and drop a comment to the tone of "you two gals look awesome!". Brace for the ensuing drama :cool:
:laugh: :thumbsup: I really have to try that!
Whether I think I can, or think I can't, I am always bloody right!
