Happy New Year

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))

Published Wednesday, December 31, 2008 9:47 AM by Madhivanan

Comments

# Another Seasonal Query, Slightly Late..

Thursday, January 8, 2009 4:52 AM by Ward Pond's SQL Server blog

On the heels of Christmas Eve’s seasonal query from Dirk Gubbels comes this gem from Madhivanan (with

# Another Seasonal Query, Slightly Late.. | Ward Pond's SQL Server blog

Pingback from  Another Seasonal Query, Slightly Late.. | Ward Pond's SQL Server blog