<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://blogs.technet.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Another Seasonal Query, Slightly Late..</title><link>http://blogs.technet.com/wardpond/archive/2009/01/07/another-seasonal-query-slightly-late.aspx</link><description>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</description><dc:language>en-US</dc:language><generator>CommunityServer 2.1 SP1 (Build: 61025.2)</generator><item><title>re: Another Seasonal Query, Slightly Late..</title><link>http://blogs.technet.com/wardpond/archive/2009/01/07/another-seasonal-query-slightly-late.aspx#3178334</link><pubDate>Thu, 08 Jan 2009 20:48:10 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3178334</guid><dc:creator>Adam Machanic</dc:creator><description>&lt;p&gt;Can I play?&lt;/p&gt;
&lt;p&gt;---&lt;/p&gt;
&lt;p&gt;/******************************/select/******************************/&lt;/p&gt;
&lt;p&gt;/*********************/space(no//**/4)+stuff(/***********************/&lt;/p&gt;
&lt;p&gt;/*********/replicate(char(42),/*******/((no+1)%2)+1),((no+/**********/&lt;/p&gt;
&lt;p&gt;/****/1)%2)+1,0 ,space(3+/*************************/(1%no)+ (abs/****/&lt;/p&gt;
&lt;p&gt;/********/(abs((no%2)-/************************/1)*sign(no-4/********/&lt;/p&gt;
&lt;p&gt;/*************/))) - ((no/***************/-1) /2)))from/*************/&lt;/p&gt;
&lt;p&gt;/****************/(select top 4/***/row_number()over/****************/&lt;/p&gt;
&lt;p&gt;/***************/(order by/*****************/name) as/***************/&lt;/p&gt;
&lt;p&gt;/************/no from sys/********************/.types)as t/**********/&lt;/p&gt;
&lt;p&gt;---&lt;/p&gt;
&lt;p&gt;... I hope this renders properly!&lt;/p&gt;</description></item><item><title>Yet Another Holiday Query: Adam Wants to Play</title><link>http://blogs.technet.com/wardpond/archive/2009/01/07/another-seasonal-query-slightly-late.aspx#3178580</link><pubDate>Fri, 09 Jan 2009 06:02:56 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3178580</guid><dc:creator>Ward Pond's SQL Server blog</dc:creator><description>&lt;p&gt;If this keeps up, I might need to define a tag for this stuff.. Our old friend Adam Machanic , perhaps&lt;/p&gt;
</description></item><item><title>Database Programming: OBJECT_NAME Take Two Parameters</title><link>http://blogs.technet.com/wardpond/archive/2009/01/07/another-seasonal-query-slightly-late.aspx#3196668</link><pubDate>Wed, 04 Feb 2009 03:48:50 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3196668</guid><dc:creator>Ward Pond's SQL Server blog</dc:creator><description>&lt;p&gt;This post is a cousin of sorts to last December’s post regarding the OBJECT_ID function. I learned this&lt;/p&gt;
</description></item><item><title>DWWTWT?: March 2-6</title><link>http://blogs.technet.com/wardpond/archive/2009/01/07/another-seasonal-query-slightly-late.aspx#3210252</link><pubDate>Sat, 07 Mar 2009 10:32:41 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3210252</guid><dc:creator>Ward Pond's SQL Server blog</dc:creator><description>&lt;p&gt;Here’s another seasonal query for you : select datediff ( dd , '10/20/2008' , '3/3/2009' ) -----------&lt;/p&gt;
</description></item></channel></rss>