Second base: pairing with other colors
After celebrating the first color down, now it’s time to give it some friends. Try to visualize the color picker — regardless of the tool of your choice — and then imagine a line that starts in the top left corner of the picker and then it bends all the way down to the bottom right, directly passing through the color you’ve just picked.

Continuing a series on table expressions, Itzik Ben-Gan explains recursive CTEs, features from the standard T-SQL is lacking, and workarounds.

Remember that the syntax of a query against a CTE is as follows:

WITH <CTE name> [ ( <with column list> ) ]
AS
(
<table expression>
)
<outer query>;