The coalesce function will use the next column value if the first one is null, thereby doing much the same thing accomplished with using case statements as suggested earlier. As...

Ms. Morris?

Mr. Morris, if the question you are referring to is the one about the row with "3, 0, 9".

"The values always increment across the row such that, when the rows...

The values always increment across the row such that, when the rows are in order, the values in all columns also increment top to bottom. There are random cells that...

I'm not making judgements or trying to insult anyone's intelligence, but the sample I posted should be self explanatory. It's the people who can look at the example and fully...

CREATE TABLE #one (id INT)

CREATE TABLE #two (id INT)

INSERT INTO #one VALUES (1)

INSERT INTO #one VALUES (3)

INSERT INTO #one VALUES (5)

INSERT INTO #one VALUES (6)

INSERT INTO #two VALUES (1)

INSERT INTO...