It's time for another July TechNet Guru winner!
Multi MCC award winner, three-time TechNet Guru Gold Medal winner, and Wiki Ninja Belt holder, Naomi N is our T-SQL Guru for July! See the TechNet Guru Contributions for July 2013.
ABOUT NAOMI: I am an IT professional with more than 15 years of experience in variety of programming languages and technologies. I am a Microsoft Community Award Recipient and Personality of the Year at UniversalThread.com forum in 2008,2009,2010,2011.
Here is the gold-medal-winning article:
T-SQL: Gaps and Islands Problem
Now let's look at all the winning articles:
Naomi is holding up the T-SQL category for July, thanks Naomi. This should be a category many disciplines can contribute to, so maybe August will pick up. Thanks nonetheless to Naomi for some great contributions!
And here's an excerpt from the article:
The thread originator was kind enough to provide DDL of the table and some data to describe the task:
And he also provided the desired output:
The problem is to find consecutive vouchers (100-104, then 106).
Read the rest here:
Thanks to Naomi N for your great contribution to the TechNet Guru contest! You can read about all the July winners here: TechNet Guru Awards - July 2013
Also, for the August Guru competition, see TechNet Guru Contributions - August 2013.
Are you a Wiki Ninja? http://technet.com/wiki
- User Ed