TSQL Challenge 48 - Parse and evaluate Arithmetic Expressions using TSQL
The primary goal of this challenge is to demonstrate the power of Recursive CTEs introduced in SQL Server 2005. Recursive CTEs allow you to implement almost any algorithm in a single TSQL statement. This challenge is to parse and evaluate arithmetic expressions using TSQL.
http://beyondrelational.com/blogs/tc/archive/2011/01/24/tsql-challenge-48-parse-and-evaluate-arithmetic-expressions-using-tsql.aspx
This problem is related to a reservation system where customers book a service and pay it in one or more transactions which may happen on different dates.
2010-06-28
1,576 reads
The idea of this challenge is to clean up the phrase from the words identified as 'noise' words from the beginning and end of sentences.
2010-06-14
2,667 reads
This is a matrix transposition challenge. Your job is to change the position of the numbres in a 5x5 matrix.
2010-05-17
2,132 reads
Your job is to reorganize the items in the table by sales amount (quantity * price). Reorganize the items from left to right, bottom to top. The item with the highest sales amount should come on top left of each invoice.
2010-05-03
1,836 reads
Here is another scheduling problem that deals with the allotment of classrooms for various training programs. Your chalenge is to read the source data and build an output result set that shows the weekly schedule of each training topic and the class room in which training is scheduled.
2010-03-22
1,783 reads
