<?xml version="1.0"?><?xml-stylesheet type="text/xsl" href="http://www.codeplex.com/rss.xsl"?><rss version="2.0"><channel><title>TSQL Challenges</title><link>http://tsqlchallenges.codeplex.com/Project/ProjectRss.aspx</link><description>TSQL Challenges aim at helping people enhance their SET based query writing skills by presenting real life TSQL challenges. TSQL Challenges encourages people to think differently and come up with b...</description><item><title>Updated Release: TSQL Challenge 1 (Aug 18, 2009)</title><link>http://tsqlchallenges.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=31710</link><description>&lt;div class="wikidoc"&gt;&lt;a href="http://beyondrelational.com/blogs/tc/archive/2009/02/27/tsql-challenge-1.aspx" class="externalLink"&gt;TSQL Challenge 1&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt; is the first of the several challenges we run at &lt;a href="http://beyondrelational.com/blogs/tc" class="externalLink"&gt;TSQL Challenges&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt;. A number of SQL Server experts participated in the challenge and the Challenges Evaluation Team identified &lt;a href="http://beyondrelational.com/blogs/tc/archive/2009/04/23/tsql-challenge-1-answer-and-winners.aspx" class="externalLink"&gt;three winning solutions&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt;. The winning solutions are listed above and are available for download.&lt;br /&gt;&lt;br /&gt;&lt;a href="http://beyondrelational.com/blogs/tc" class="externalLink"&gt;TSQL Challenges&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt; aims at helping people to enhance their SET based query writing skills, either by participating in one of the challenges and trying to solve it, or by looking at the solutions of SQL Server experts. If it interests you, we invite you to participate in the next &lt;a href="http://beyondrelational.com/blogs/tc" class="externalLink"&gt;TSQL Challenge&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;If you have a solution that performs better than the solutions listed below, we will be glad to look into your solution. Please review the &lt;a href="http://beyondrelational.com/blogs/tc/pages/tsql-challenges-terms-and-conditions-submission-guidelines-evaluation-process-and-faq.aspx" class="externalLink"&gt;Submission Guidelines and Evaluation Criteria&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt; and send us your entries following the instructions in the &lt;a href="http://beyondrelational.com/blogs/tc/pages/tsql-challenges-terms-and-conditions-submission-guidelines-evaluation-process-and-faq.aspx" class="externalLink"&gt;Submission Guidelines&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt;.&lt;/div&gt;&lt;div class="ClearBoth"&gt;&lt;/div&gt;</description><author>jacobsebastian</author><pubDate>Sun, 13 Sep 2009 01:51:22 GMT</pubDate><guid isPermaLink="false">Updated Release: TSQL Challenge 1 (Aug 18, 2009) 20090913015122A</guid></item><item><title>Released: TSQL Challenge 1 (Aug 18, 2009)</title><link>http://tsqlchallenges.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=31710</link><description>&lt;div&gt;&lt;a href="http://beyondrelational.com/blogs/tc/archive/2009/02/27/tsql-challenge-1.aspx"&gt;TSQL Challenge 1&lt;span&gt;&lt;/span&gt;&lt;/a&gt; is the first of the several challenges we run at &lt;a href="http://beyondrelational.com/blogs/tc"&gt;TSQL Challenges&lt;span&gt;&lt;/span&gt;&lt;/a&gt;. A number of SQL Server experts participated in the challenge and the Challenges Evaluation Team identified &lt;a href="http://beyondrelational.com/blogs/tc/archive/2009/04/23/tsql-challenge-1-answer-and-winners.aspx"&gt;three winning solutions&lt;span&gt;&lt;/span&gt;&lt;/a&gt;. The winning solutions are listed above and are available for download.&lt;br&gt;&lt;br&gt;&lt;a href="http://beyondrelational.com/blogs/tc"&gt;TSQL Challenges&lt;span&gt;&lt;/span&gt;&lt;/a&gt; aims at helping people to enhance their SET based query writing skills, either by participating in one of the challenges and trying to solve it, or by looking at the solutions of SQL Server experts. If it interests you, we invite you to participate in the next &lt;a href="http://beyondrelational.com/blogs/tc"&gt;TSQL Challenge&lt;span&gt;&lt;/span&gt;&lt;/a&gt;&lt;br&gt;&lt;br&gt;If you have a solution that performs better than the solutions listed below, we will be glad to look into your solution. Please review the &lt;a href="http://beyondrelational.com/blogs/tc/pages/tsql-challenges-terms-and-conditions-submission-guidelines-evaluation-process-and-faq.aspx"&gt;Submission Guidelines and Evaluation Criteria&lt;span&gt;&lt;/span&gt;&lt;/a&gt; and send us your entries following the instructions in the &lt;a href="http://beyondrelational.com/blogs/tc/pages/tsql-challenges-terms-and-conditions-submission-guidelines-evaluation-process-and-faq.aspx"&gt;Submission Guidelines&lt;span&gt;&lt;/span&gt;&lt;/a&gt;.&lt;/div&gt;&lt;div&gt;&lt;/div&gt;</description><author></author><pubDate>Sun, 13 Sep 2009 01:51:22 GMT</pubDate><guid isPermaLink="false">Released: TSQL Challenge 1 (Aug 18, 2009) 20090913015122A</guid></item><item><title>Updated Release: TSQL Challenge 1 (Aug 18, 2009)</title><link>http://tsqlchallenges.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=31710</link><description>&lt;div class="wikidoc"&gt;&lt;a href="http://beyondrelational.com/blogs/tc/archive/2009/02/27/tsql-challenge-1.aspx" class="externalLink"&gt;TSQL Challenge 1&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt; is the first of the several challenges we run at &lt;a href="http://beyondrelational.com/blogs/tc" class="externalLink"&gt;TSQL Challenges&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt;. A number of SQL Server experts participated in the challenge and the Challenges Evaluation Team identified &lt;a href="http://beyondrelational.com/blogs/tc/archive/2009/04/23/tsql-challenge-1-answer-and-winners.aspx" class="externalLink"&gt;three winning solutions&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt;. The winning solutions are listed above and are available for download.&lt;br /&gt;&lt;br /&gt;&lt;a href="http://beyondrelational.com/blogs/tc" class="externalLink"&gt;TSQL Challenges&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt; aims at helping people to enhance their SET based query writing skills, either by participating in one of the challenges and trying to solve it, or by looking at the solutions of SQL Server experts. If it interests you, we invite you to participate in the next &lt;a href="http://beyondrelational.com/blogs/tc" class="externalLink"&gt;TSQL Challenge&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;If you have a solution that performs better than the solutions listed below, we will be glad to look into your solution. Please review the &lt;a href="http://beyondrelational.com/blogs/tc/pages/tsql-challenges-terms-and-conditions-submission-guidelines-evaluation-process-and-faq.aspx" class="externalLink"&gt;Submission Guidelines and Evaluation Criteria&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt; and send us your entries following the instructions in the &lt;a href="http://beyondrelational.com/blogs/tc/pages/tsql-challenges-terms-and-conditions-submission-guidelines-evaluation-process-and-faq.aspx" class="externalLink"&gt;Submission Guidelines&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt;.&lt;/div&gt;&lt;div class="ClearBoth"&gt;&lt;/div&gt;</description><author>jacobsebastian</author><pubDate>Wed, 26 Aug 2009 03:31:30 GMT</pubDate><guid isPermaLink="false">Updated Release: TSQL Challenge 1 (Aug 18, 2009) 20090826033130A</guid></item><item><title>Released: TSQL Challenge 1 (Aug 18, 2009)</title><link>http://tsqlchallenges.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=31710</link><description>&lt;div&gt;&lt;a href="http://beyondrelational.com/blogs/tc/archive/2009/02/27/tsql-challenge-1.aspx"&gt;TSQL Challenge 1&lt;span&gt;&lt;/span&gt;&lt;/a&gt; is the first of the several challenges we run at &lt;a href="http://beyondrelational.com/blogs/tc"&gt;TSQL Challenges&lt;span&gt;&lt;/span&gt;&lt;/a&gt;. A number of SQL Server experts participated in the challenge and the Challenges Evaluation Team identified &lt;a href="http://beyondrelational.com/blogs/tc/archive/2009/04/23/tsql-challenge-1-answer-and-winners.aspx"&gt;three winning solutions&lt;span&gt;&lt;/span&gt;&lt;/a&gt;. The winning solutions are listed above and are available for download.&lt;br&gt;&lt;br&gt;&lt;a href="http://beyondrelational.com/blogs/tc"&gt;TSQL Challenges&lt;span&gt;&lt;/span&gt;&lt;/a&gt; aims at helping people to enhance their SET based query writing skills, either by participating in one of the challenges and trying to solve it, or by looking at the solutions of SQL Server experts. If it interests you, we invite you to participate in the next &lt;a href="http://beyondrelational.com/blogs/tc"&gt;TSQL Challenge&lt;span&gt;&lt;/span&gt;&lt;/a&gt;&lt;br&gt;&lt;br&gt;If you have a solution that performs better than the solutions listed below, we will be glad to look into your solution. Please review the &lt;a href="http://beyondrelational.com/blogs/tc/pages/tsql-challenges-terms-and-conditions-submission-guidelines-evaluation-process-and-faq.aspx"&gt;Submission Guidelines and Evaluation Criteria&lt;span&gt;&lt;/span&gt;&lt;/a&gt; and send us your entries following the instructions in the &lt;a href="http://beyondrelational.com/blogs/tc/pages/tsql-challenges-terms-and-conditions-submission-guidelines-evaluation-process-and-faq.aspx"&gt;Submission Guidelines&lt;span&gt;&lt;/span&gt;&lt;/a&gt;.&lt;/div&gt;&lt;div&gt;&lt;/div&gt;</description><author></author><pubDate>Wed, 26 Aug 2009 03:31:30 GMT</pubDate><guid isPermaLink="false">Released: TSQL Challenge 1 (Aug 18, 2009) 20090826033130A</guid></item><item><title>Updated Release: TSQL Challenge 1 (Aug 18, 2009)</title><link>http://tsqlchallenges.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=31710</link><description>&lt;div class="wikidoc"&gt;&lt;a href="http://beyondrelational.com/blogs/tc/archive/2009/02/27/tsql-challenge-1.aspx" class="externalLink"&gt;TSQL Challenge 1&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt; is the first of the several challenges we run at &lt;a href="http://beyondrelational.com/blogs/tc" class="externalLink"&gt;TSQL Challenges&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt;. A number of SQL Server experts participated in the challenge and the Challenges Evaluation Team identified &lt;a href="http://beyondrelational.com/blogs/tc/archive/2009/04/23/tsql-challenge-1-answer-and-winners.aspx" class="externalLink"&gt;three winning solutions&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt;. The winning solutions are listed below and are available for download.&lt;br /&gt;&lt;br /&gt;&lt;a href="http://beyondrelational.com/blogs/tc" class="externalLink"&gt;TSQL Challenges&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt; aims at helping people to enhance their SET based query writing skills, either by participating in one of the challenges and trying to solve it, or by looking at the solutions of SQL Server experts. If it interests you, we invite you to participate in the next &lt;a href="http://beyondrelational.com/blogs/tc" class="externalLink"&gt;TSQL Challenge&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;If you have a solution that performs better than the solutions listed below, we will be glad to look into your solution. Please review the &lt;a href="http://beyondrelational.com/blogs/tc/pages/tsql-challenges-terms-and-conditions-submission-guidelines-evaluation-process-and-faq.aspx" class="externalLink"&gt;Submission Guidelines and Evaluation Criteria&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt; and send us your entries following the instructions in the &lt;a href="http://beyondrelational.com/blogs/tc/pages/tsql-challenges-terms-and-conditions-submission-guidelines-evaluation-process-and-faq.aspx" class="externalLink"&gt;Submission Guidelines&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt;.&lt;br /&gt;&lt;/div&gt;&lt;div class="ClearBoth"&gt;&lt;/div&gt;</description><author>jacobsebastian</author><pubDate>Wed, 26 Aug 2009 03:30:20 GMT</pubDate><guid isPermaLink="false">Updated Release: TSQL Challenge 1 (Aug 18, 2009) 20090826033020A</guid></item><item><title>Updated Wiki: Home</title><link>http://tsqlchallenges.codeplex.com/Wiki/View.aspx?title=Home&amp;version=6</link><description>&lt;div class="wikidoc"&gt;&lt;b&gt;Project Description&lt;/b&gt;&lt;br /&gt;TSQL Challenges aim at helping people enhance their SET based query writing skills by presenting real life TSQL challenges. TSQL Challenges encourages people to think differently and come up with better solutions than what they are used do or learn from other people.&lt;br /&gt;&lt;br /&gt;This is a sub project of &lt;a href="http://beyondrelational.com/blogs/tc/" class="externalLink"&gt;TSQL Challenges&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt;. The winning solutions of each TSQL Challenge will be available for download within this project. To review the solutions of a challenge, go to the &lt;a href="http://tsqlchallenges.codeplex.com/Release/ProjectReleases.aspx" class="externalLink"&gt;releases&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt; pages. Each release represents a TSQL Challenge and you can identify the specific challenge by the release name.&lt;br /&gt;&lt;br /&gt;&lt;/div&gt;&lt;div class="ClearBoth"&gt;&lt;/div&gt;</description><author>jacobsebastian</author><pubDate>Wed, 19 Aug 2009 14:25:47 GMT</pubDate><guid isPermaLink="false">Updated Wiki: Home 20090819022547P</guid></item><item><title>Updated Wiki: Home</title><link>http://tsqlchallenges.codeplex.com/Wiki/View.aspx?title=Home&amp;version=5</link><description>&lt;div class="wikidoc"&gt;&lt;b&gt;Project Description&lt;/b&gt;&lt;br /&gt;TSQL Challenges aim at helping people enhance their SET based query writing skills by presenting real life TSQL challenges. TSQL Challenges encourages people to think differently and come up with better solutions than what they are used do or learn from other people.&lt;br /&gt;&lt;br /&gt;This is a sub project of &lt;a href="http://beyondrelational.com/blogs/tc/" class="externalLink"&gt;TSQL Challenges&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt;. The winning solutions of each TSQL Challenge will be available for download within this project. To review the solutions of a challenge, go to the &amp;quot;releases&amp;quot; tab. Each release represents a TSQL Challenge and you can identify the specific challenge by the release name. &lt;/div&gt;&lt;div class="ClearBoth"&gt;&lt;/div&gt;</description><author>jacobsebastian</author><pubDate>Wed, 19 Aug 2009 14:24:48 GMT</pubDate><guid isPermaLink="false">Updated Wiki: Home 20090819022448P</guid></item><item><title>Updated Wiki: Home</title><link>http://tsqlchallenges.codeplex.com/Wiki/View.aspx?title=Home&amp;version=4</link><description>&lt;div class="wikidoc"&gt;&lt;b&gt;Project Description&lt;/b&gt;&lt;br /&gt;TSQL Challenges aim at helping people enhance their SET based query writing skills by presenting real life TSQL challenges. TSQL Challenges encourages people to think differently and come up with better solutions than what they are used do or learn from other people.&lt;br /&gt;&lt;br /&gt;This is a sub project of &lt;a href="http://beyondrelational.com/blogs/tc/" class="externalLink"&gt;TSQL Challenges&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt;. The winning solutions of each TSQL Challenge will be available for download within this project. &lt;/div&gt;&lt;div class="ClearBoth"&gt;&lt;/div&gt;</description><author>jacobsebastian</author><pubDate>Wed, 19 Aug 2009 14:23:42 GMT</pubDate><guid isPermaLink="false">Updated Wiki: Home 20090819022342P</guid></item><item><title>Updated Wiki: Home</title><link>http://tsqlchallenges.codeplex.com/Wiki/View.aspx?title=Home&amp;version=3</link><description>&lt;div class="wikidoc"&gt;&lt;b&gt;Project Description&lt;/b&gt;&lt;br /&gt;TSQL Challenges aim at helping people enhance their SET based query writing skills by presenting real life TSQL challenges. TSQL Challenges encourages people to think differently and come up with better solutions than what they are used do or learn from other people.&lt;br /&gt;&lt;br /&gt;This is a sub project of &lt;a href="http://beyondrelational.com/blogs/tc/" class="externalLink"&gt;http://beyondrelational.com/blogs/tc/&lt;span class="externalLinkIcon"&gt;&lt;/span&gt;&lt;/a&gt;TSQL Challenges&lt;a href="http://tsqlchallenges.codeplex.com/Wiki/View.aspx?title=%2furl"&gt;&amp;#47;url&lt;/a&gt;.&lt;/div&gt;&lt;div class="ClearBoth"&gt;&lt;/div&gt;</description><author>jacobsebastian</author><pubDate>Wed, 19 Aug 2009 14:21:28 GMT</pubDate><guid isPermaLink="false">Updated Wiki: Home 20090819022128P</guid></item><item><title>Patch Uploaded: #3622</title><link>http://tsqlchallenges.codeplex.com/SourceControl/PatchList.aspx</link><description>
&lt;p&gt;&lt;a href='http://www.codeplex.com/site/users/view/jacobsebastian'&gt;jacobsebastian&lt;/a&gt; has uploaded a patch.&lt;/p&gt;
&lt;p&gt;&lt;b&gt;Description:&lt;/b&gt;&lt;br /&gt;Insert script for TSQL Challenge &amp;#35;1&lt;/p&gt;</description><author>jacobsebastian</author><pubDate>Tue, 18 Aug 2009 15:11:32 GMT</pubDate><guid isPermaLink="false">Patch Uploaded: #3622 20090818031132P</guid></item><item><title>Updated Release: TSQL Challenge 1 (Aug 18, 2009)</title><link>http://tsqlchallenges.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=31710</link><description>&lt;div class="wikidoc"&gt;TSQL Challenge #1&lt;/div&gt;&lt;div class="ClearBoth"&gt;&lt;/div&gt;</description><author>jacobsebastian</author><pubDate>Tue, 18 Aug 2009 15:06:20 GMT</pubDate><guid isPermaLink="false">Updated Release: TSQL Challenge 1 (Aug 18, 2009) 20090818030620P</guid></item><item><title>Released: TSQL Challenge 1 (Aug 18, 2009)</title><link>http://tsqlchallenges.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=31710</link><description>&lt;div&gt;TSQL Challenge #1&lt;/div&gt;&lt;div&gt;&lt;/div&gt;</description><author></author><pubDate>Tue, 18 Aug 2009 15:06:20 GMT</pubDate><guid isPermaLink="false">Released: TSQL Challenge 1 (Aug 18, 2009) 20090818030620P</guid></item><item><title>Created Release: TSQL Challenge 1 (Aug 18, 2009)</title><link>http://tsqlchallenges.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=31710</link><description>&lt;div class="wikidoc"&gt;TSQL Challenge #1&lt;/div&gt;&lt;div class="ClearBoth"&gt;&lt;/div&gt;</description><author>jacobsebastian</author><pubDate>Tue, 18 Aug 2009 15:05:08 GMT</pubDate><guid isPermaLink="false">Created Release: TSQL Challenge 1 (Aug 18, 2009) 20090818030508P</guid></item></channel></rss>