Monthly Archives: May 2011

More Recursion–Removing Multiple Spaces

My last post about recursive CTEs reminded me of a recursive SQL Server function I wrote a while back for removing multiple spaces from strings.  By removing multiple spaces, I mean replacing all consecutive repeating spaces with a single space. … Continue reading

Posted in Uncategorized | Leave a comment

The Missing UNGROUP BY Clause (T-SQL Tuesday #18)

For May 2011, T-SQL Tuesday is brought to us by Chicago’s own Bob Pusateri  (blog | @SQLBob). Bob chose common table expressions, otherwise know as CTEs as the topic of the month.  Thanks for hosting Bob, and for the great … Continue reading

Posted in Uncategorized | 6 Comments