Ward Pond's SQL Server blog

Ruminating on issues pertinent to the design and development of sound databases and processes under Microsoft SQL Server 2008, SQL Server 2005, and SQL Server 2000 (while reserving the right to vent about anything else that's on my mind)

Another Seasonal Query, Slightly Late..

Another Seasonal Query, Slightly Late..

  • Comments 4
  • Likes

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(7-len(replicate(char(42),no)))+ replicate(char(42),no*2-1) 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
  • 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!

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

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

  • Here’s another seasonal query for you : select datediff ( dd , '10/20/2008' , '3/3/2009' ) -----------

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment