Great article - In my experience, the subset of "heresies" that should be discussed under the "it depends" clause is almost always substantially larger than the actual heresies. And as you...

Thanks very much Daniel. I figured that that was the case, but didn't want to make an assumption since I'm just starting out with this.

I'm following the steps as listed, and everything is working, but I'm getting different probabilities and results, even though I am using the AdventureWorksDW2012 DB (which of course you have...

I stumbled across this article, and it's definitely at a level above my current abilities. That said, I do get the general idea, and why Tally tables are preferable to...

One thing that isn't illustrated in this example is the actual mapping of variables to values in the container. In this instance, since there was only one variable (SourceFileName), and...

GilaMonster (9/6/2016)

---

Because there's no un-aggregated columns being returned from that subquery. Group By is only needed when you have columns in aggregate and columns that aren't in aggregate in the...

I understand the logic behind listing #3, but I was surprised to see, and uncertain on how it works, that it is not necessary to use another GROUP BY clause...

@DataJoe - I don't see anywhere that the author says what the number returned to the TOP function actually is. The example just shows that some number will...

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 also...

Found one!!!

http://tidesonline.nos.noaa.gov/data_read.shtml?station_info=9444900+Port+Townsend,+WA

The data itself is not particularly interesting, but it gave me the opportunity to do what I thought was some pretty fun stuff, given the low level of analysis...

Steve, thanks very much. Starting to really hate this assignment.

Both of those would be great, but I'm running into issues trying to access them via Excel. The World Monitor page...