Yes, but it does not fix the problem.  Everything is explicitly cast to a VARCHAR(MAX) and it STILL truncates based on where I place that single line of code.  The...

No.  VARCHAR(MAX) or VARCHAR(8000), it still truncates based on where in the SELECT clause I place it.  The further down it goes, the more severe the truncation.

Yes, I ran this is SSMS, PowerShell, SQLCMD via batch file, SQL CMD within SSMS, EXEC(@var), sp_executeSQL, and an execute SQL task from within SSIS.  Behavior matched for all execution...

1. No, there is nothing wrong with the query plan.  The query plan is the same regardless of where I put that line in the SELECT statement.  It is a...

Your assertions that the OVER clause performs worse than alternative methods is incorrect and misleading. You used an example where it's going to be worse. There are MANY...

Steve, as I said, I don't see anything that was worth an article or editorial about. It reads like a thin marketing pitch.

"Imagine being able to connect to SQL...

Um...the big deal is....what? I connect remotely to every production SQL Server instance that I've worked with for over 2 decades. I rarely have to manage the OS...

If you wanted to have something to populate a drop down, without having any data as the basis for that drop down, you can just as easily hard code 12...

Ummmm. Recursive CTE, why?

Single SELECT statement based on AdventureWorks:

SELECT DISTINCT DATENAME(mm,OrderDate), MONTH(OrderDate)

FROM Sales.SalesOrderHeader

WHERE OrderDate BETWEEN '1/1/2006' and '12/31/2006'

ORDER BY MONTH(OrderDate)

The built in validation procedures (article and publication) have existed since at least SQL Server 7.0. The parameters have not changed, so the same code that worked on SQL...

My thoughts exactly... Uh...Why don't you use the article and publication validation that ships with the product and has been there for multiple versions?

sp_article_validation allows you to do both...

Involved? That doesn't make any sense. You create a cert, backup the cert, and alter the database. It's a three step process that is actually simpler than...

Steven James Gray (6/3/2010)

---

That is quite a strange response. Your article spent time basically explaining how your Gregorian calendar approach using a recursive CTE is the only "good" solution....

Steven James Gray (6/2/2010)

---

Regarding some of the other date concerns:

1) Using non-gregorian calendars: There are free and widely available mechanisms to map UTC time-spans to/from these calendars. These can be...

Let's see:

1. What if you want Gregorian calendar, business calendar, and manufacturing calendar?

2. You need to designate holidays?

3. You need to designate fiscal quarters/years based on both a date and...