This challenge presents a scheduleing problem related to recurring appointments. The task is to calculate and generate a list of appointments that are supposed to take place between two given dates. The calculation should be done based on the recurring...
The Challenge This challenge though does not have any resemblance with the real time problem directly, but it measures about logical thinking. The problem is all about finding the factorial of numbers. Though it is known to most of us what a factorial...
DateTime is a very useful yet complex datatype in SQL. I have heard many people saying they are not comfortable when it comes dealing with Date calculations. Let us take a closer look at various functions used for date calculations. DAY Returns an integer...
The Challenge This challenge though does not have any resemblance with the real time problem directly, but it measures about logical thinking. The problem is all about finding the factorial of numbers. Though it is known to most of us what a factorial...
After motivation from a Microsoft SQL Server Development Team Member (Maria Balsamo), I have opened a connect request (feedback) for feature addition to BIDS and SSMS which I described in my previous article that can be read from here . This connect item...
The list of submissions we received for TSQL Challenge 21 is posted at http://databasechallenges.com/SQLServer/TSQL/Challenge21/submissions . This includes all the submissions we received till 11th March 2010. If you have submitted a solution and don...
We have started the evaluation of TSQL Challenge 20 . The list of submissions we received so far are listed at http://databasechallenges.com/SQLServer/TSQL/challenge20/submissions . So far we received 170 submissions and I think this is one of the challenges...