Share via

Another Seasonal Query, Slightly Late..

  • Article

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

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

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

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

  • Anonymous
    January 08, 2009
    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!