Attention: We are retiring the ASP.NET Community Blogs. Learn more >

V-Days Vs SQL

Open query analyzer and press Ctrl + T and run this below code.
See what the magic will be happen.Thanks  Narayan.
With regards,
-Suresh ,Microsoft MVP .Net
-----------------------------------------------------
/*
Author: Steve Kass, Drew University
Hosted by: http://vyaskn.tripod.com
Script works on SQL Server 7.0 and 2000
*/
USE tempdb
GO
SET NOCOUNT ON
CREATE TABLE [seqA1740E61-1E21-11D6-B831-E02C0D466A26] (nbr int IDENTITY)
DECLARE @i int
SET @i = 0
WHILE @i < 25
BEGIN
	INSERT INTO [seqA1740E61-1E21-11D6-B831-E02C0D466A26] DEFAULT VALUES
	SET @i = @i + 1
END
DECLARE @heart binary(264)
SET @heart =
  0x010b0e12220b0108100e25
+ 0x080105120a280501031406
+ 0x2a03010215042b02010116
+ 0x022c010100160201000100
+ 0x1602010001000100010001
+ 0x0001000100010101002c01
+ 0x010201002b020104010029
+ 0x0401060100270601080100
+ 0x2508010a0100230a010c01
+ 0x00210c010e01001f0e0110
+ 0x01001d10011201001b1201
+ 0x1401001914011601001716

SELECT
  STUFF(STUFF(STUFF(
      R,A/256,A%256,SPACE(A%256)),
        B/256,B%256,SPACE(B%256)),
        C/256,C%256,SPACE(C%256))
AS N'I love you/Eu te amo/Ti amo/Je t''aime/Ya vas lyublyu/Ich liebe Dich!!!'
FROM (
  SELECT Nbr AS L, SUBSTRING(S,Nbr,2*L) AS R FROM (
    SELECT
      LEN(S+'*') AS L,
      REPLICATE(S+'*',4) AS S
    FROM (
      SELECT 'Happy-Valentine''s-Day' AS S
    ) X
  ) V CROSS JOIN [seqA1740E61-1E21-11D6-B831-E02C0D466A26]
  WHERE Nbr BETWEEN 1 AND L
) W JOIN (
  SELECT
    Nbr,
    CONVERT(int,SUBSTRING(@heart,6*Nbr-5,2)) AS A,
    CONVERT(int,SUBSTRING(@heart,6*Nbr-3,2)) AS B,
    CONVERT(int,SUBSTRING(@heart,6*Nbr-1,2)) AS C
  FROM [seqA1740E61-1E21-11D6-B831-E02C0D466A26]
  WHERE Nbr BETWEEN 1 AND 24
) X
ON L = Nbr
GO
DROP TABLE [seqA1740E61-1E21-11D6-B831-E02C0D466A26]

3 Comments

Comments have been disabled for this content.