Category Archives: SQL Server

Remove multiple CR LF characters from the end of text strings in SQL

Data entry, it’s where users love to copy and paste. Especially when their text is nicely arranged with multiple spaces, cartridge returns and line feeds amongst other special character formatting. In a perfect world this would be captured during input … Continue reading

Posted in Excel, Microsoft, SQL Server | Leave a comment

SQL 2012 ORDER BY list of RANGE window frame cannot contain expressions of LOB type

I ran into this error when preparing some data for a report in SQL Server Reporting Services 2012. I was trying to partition data showing construction progress for work areas by week number using the updated ORDER BY clause for … Continue reading

Posted in Microsoft, SQL Server | 3 Comments