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 invites you to play with date calculations. A lot of people are scared of date calculations and this challenge aims to help them to fight their fear! This challenge is to find the date based on year, month, day of the week...
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...
Configuring a software feature is usually much harder than removing it. Most of the times, removing a feature could be just a matter of a mouse click or a simple command/statement. So what do you think about this question? Enabling FILESTREAM storage...
Master Data Services (MDS) is the newest offering and the first of it's kind in SQL Server which is getting shipped with SQL Server 2008 R2 version. As it's claimed to be, it serves the purpose of Master Data Management within or across the enterprises...
In my previous post I mentioned that we have setup a new home page for TSQL Challenges. The URL is http://beyondrelational.com/tc.aspx . We have been working on displaying the names of people with most SQL Stars on the page and I am very happy to announce...
You can assign value to a variable by using SET or SELECT statement and almost they work the same except that a SELECT statement has the ability to have the source value come from a column within the SELECT statement. Let's see these examples to clarify...