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...
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...
One of the complaints we often received from people is about locating the previous challenges. Though http://databasechallenges.com lists all the challenges and the results, many people are not aware of it. We created a new page at beyondrelational.com...
We are getting ready for the logic testing of TSQL Challenge 18 . The tricky data for the logic testing is published at http://databasechallenges.com/SQLServer/TSQL/Challenge18/logic_testing . We will test the solutions with SQL Server language settings...
Kun Cheng from SQL Server Customer Advisory Team has come up with an interesting article that points out three tips that helps you to optimize XML operations. The first tip is to use property promotion, the next is using TYPED XML and the third is using...
Often I see people asking questions in the forums about finding the database name where the particular procedure exists You can use many methods to get a solution (cursor, undocumented procedure,dynamic sql,etc) The simplest are 1 Use Undocumented procedure...