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 31 December 2008 09:47 by Madhivanan

Comments

# Another Seasonal Query, Slightly Late..

08 January 2009 04:52 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