Adam, thank you for your example, it got me thinking.  I didn't have the table you used in the your CTE so I picked a Tally table creator that I got...

Like Jeff said, "just look at the MS provided system stored procedures."  For a quicker example right click on a table and pick either, "Select Top 1000" or "Script Table as"....

Interesting topic with a diverse set of opinions. But, I was confused when I started reading the editorial. When I first read CA at the top of the...

After reading just the first section "The Horror Begins", I thought you were talking about a Microsoft Dynamics application. With a slight bit of exaggeration added, just slight. ...

And here I thought that the SSDT Add-In to Visual Studio was going to be the new path MS was going.

Where I work, our production SQL server is the Enterprise edition as the underlying database to Microsoft Dynamic's Axapta application. But, for our POS location machines (also a part...

It would be nice if MS could add pre-compile directives similar to C++ or C# -

#define, #if, #undefine, etc...

As for SQL Server running only on a Microsoft platform, I can understand it. It is much easier for MS to maintain SQL Server. But, you have to...