Friday the 13th

Looking forward to the next few ones of these scary days?

SQL Server Closure Tables

SQL Server has a couple of different ways to represent hierarchies, but they do not allow storing any additional information that is important to the relationship between objects. In this article, Phil Factor explains how to use closure tables to overcome this deficiency.

Using T-SQL to Detect Stock Price Reversals with the RSI

Rick Dobson explains the Relative Strength Index (RSI), and shows how to create a TSQL script that computes the RSI for a stock closing price series.

Where conditions

Storing a variable with a SELECT, and why it didn't work.

Using SELECT to store values into variables is an important technique, but you need to know some of the gotchas as well.

Symmetric Except

Set-Based String Splitting table function

Describe and provide a set-based method that takes a multiple character split term and returns as a table

Recursive Queries

Solve Sudoku with T-SQL - Part 1

A Sudoku solution can be resolved using a single select statement. The first article shows this method and next how this can be optimised to resolve complex puzzles in seconds.

Formatted ASCII Results from a SELECT

Generate aligned output from SELECT statement for code comments using a simple stored procedure.