jetboy2k (9/5/2016)

---

What other Stairways should one take prior to this one? There's a reference to the Stairway to T-SQL DML Stairway, which I've finished, but in this article, there is...

Well, this would be part of the problem. 😛 There is no table, and definitely no insert statements; there's just the spreadsheet (attached in the OP). I've been making all...

Alan.B - thanks for the DDL correction. Sorry about that; I totally forgot to indicate NULL/NOT NULL when setting up the table originally, so SQL Server assumed NULL for the...

I read that here: http://www.sqlservercentral.com/articles/Stairway+Series/105972/

That blog post uses, in its example, this CTE:

with ctePerf ( objname, colid, colname, max_length...

Update: looks like I posted too soon. The consensus in that thread now seems to be that CTEs, in and of themselves (as long as they're not recursive) are no...

Question: in Listing 7, is there a way to see each recursion? Like, is there a way to see the contents of ReportingStructure after each recursion? I just want to...

I don't know enough about the issue you're having, but I thought I'd share a brief walk-through (as best I can recall) of a recent successful setup of a SQL...

Oh. Ok, I think I see now. 🙂

There are a couple ways I know of, both of which involve queries, not calculated columns in the table.

You could use a correlated...

I'm sorry; I'm half-asleep at the moment, so that may be why, but I'm having a hard time understanding the math in your example. The Values listed for PK1, for...

jasona.work (3/11/2015)

---

Katerine459 (3/11/2015)

---

Thanks, all, for the recommendations... I'll be sure to check those out when I have a chance.

If a stairway ever does get created, I just wanted to give...

Thanks, all, for the recommendations... I'll be sure to check those out when I have a chance.

If a stairway ever does get created, I just wanted to give a quick...

Agree with the others; listings 5 and 6 have been switched. Which led to a lot of confusion, as I'm looking at this:

To demonstrate using a subquery in a function...

Sorry, I started typing before you posted. 🙂 I'll give that a shot.

Edit: Ok, that does give me a readable view, which I can then save to my Kindle Fire....

A couple possible solutions:

1) Make a separate RSS feed, properly-ordered, for each Stairway. This would make it possible to read on any e-reader. (right now, trying to use the RSS...