Rabu, 02 Februari 2011

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. Source Data id expr x0 dx points --- --------- ---- ----- ------ 1 1+2*(4+x) 0 0.1 4 2 x^2/2 0 0.1 4 3 x^x 0 10 4 Expected

Tidak ada komentar:

Posting Komentar