Great article. And since you are going to clean it up for "Windows" vs "Windowing", you can clean up the following typos, too 🙂

1. "Meaning it is the only...

Great article. Couple of typos in your code that do not affect the execution. Look for "EndDateunion" aliases.

Thanks for the article.

[Edit]

BTW, we have a commercial product that does something...

Yea, when the first sentence is wrong, it makes you wonder about the correctness of the rest of the article 🙂

I'll add a few to the mix:

*Creative uses of CASE, since there's no if structure except in procedures, functions

*Know how to create a user defined function and when it is...

Thankfully, if Microsoft takes away the author's licenses, he will still have Talend to work with, not to mention many wonderful cheaper-to-free databases! 🙂

We use both SSIS and Talend. Typically we use SSIS when writing to SQL Server and Talend for everything else. On your performance measurement, you might want to...

Steve, did you make all those typos in your "It Happens" paragraphs just to make the point that we could still somehow figure out what you were saying? You're...

[font="Courier New"]Here's the way I send out a single error message (error message 1) to my pager.

1) Set up a variable at the package level as an error counter; such...

Should be TOP 1 for T-SQL, instead of FIRST, I think. First is used in other SQL's, it think, like db2, at the end of the select clause. First...