Another Seasonal Query, Slightly Late..


On the heels of Christmas Eve’s seasonal query from Dirk Gubbels comes this gem from Madhivanan (with a tip of the hat to Dave Edwards’ link in Log Buffer #129).


set nocount on


select space(7len(replicate(char(42),no)))+ replicate(char(42),no*21) from
(
    select top 5 row_number() over (order by name) as no from sysobjects
) as t
union all
select space(5)+replicate(char(124),3)
union all
select cast(0x4861707079204E65772059656172 as varchar(100))


This is safe to run on any database on any SQL Server 2005 or SQL Server 2008 instance.


Nice job, Madhivanan!


     -wp

Comments (4)

  1. Anonymous says:

    This post is a cousin of sorts to last December’s post regarding the OBJECT_ID function. I learned this

  2. Anonymous says:

    Here’s another seasonal query for you : select datediff ( dd , ’10/20/2008′ , ‘3/3/2009’ ) ———–

  3. Anonymous says:

    If this keeps up, I might need to define a tag for this stuff.. Our old friend Adam Machanic , perhaps

  4. Adam Machanic says:

    Can I play?

    /******************************/select/******************************/

    /*********************/space(no//**/4)+stuff(/***********************/

    /*********/replicate(char(42),/*******/((no+1)%2)+1),((no+/**********/

    /****/1)%2)+1,0 ,space(3+/*************************/(1%no)+ (abs/****/

    /********/(abs((no%2)-/************************/1)*sign(no-4/********/

    /*************/))) – ((no/***************/-1) /2)))from/*************/

    /****************/(select top 4/***/row_number()over/****************/

    /***************/(order by/*****************/name) as/***************/

    /************/no from sys/********************/.types)as t/**********/

    … I hope this renders properly!