Recursive function

Ben Kubicek wrote a recursive function that solves simple math expressions in a select statement. Read about this creative use of T-SQL.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2.48 (23)

You rated this post out of 5. Change rating

2011-11-21

5,894 reads

Blogs

Tired of inventory headaches? Stock shortages and gluts don't just cause stress; they cost...

So, you want to get your SQL skills razor-sharp without dropping any cash? You're...

Here are the slides from my talk today at the Redgate NYC Devour Hour:...

Comments posted to this topic are about the item CONCAT_WS

What’s the best way to find duplicate rows in a sql query? I heard...

Hello, Can you please clarify the following: In Azure SQL DB both ALLOW_SNAPSHOT_ISOLATION/READ_COMMITTED_SNAPSHOT are set...

What output do the queries produce?

SET CONCAT_NULL_YIELDS_NULL ON;
SELECT CONCAT_WS ('-', NULL, NULL);
SET CONCAT_NULL_YIELDS_NULL OFF;
SELECT CONCAT_WS ('-', NULL, NULL);