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.

GROUPING

T-SQL sorting

SET the results

ReSETting the value