Alternating Group Colors
Formatting reports can be a fun process. I personally look at myself as a Monet or Picasso when creating my...
2010-06-02
513 reads
BrianKMcDonald
Flipping a Table Sideways
Not too often, someone asks for a strange request like wanting to pivot on every single value inside a table....
2010-05-28
1,602 reads
Using PATINDEX to Split Column Data
A colleague of mine received an Excel file that he needed to load into a table for future lookup values....
2010-05-20
1,195 reads
Using the Report Items Collection in Reporting Services
Using the Report Items Collection in Reporting Services
Sometimes, you may want to do calculations or use some value that has...
2010-05-12
492 reads
SSRS - Time Saver using Templates
Creating a Reporting Services Template
Many companies like to have a consistent look and feel across their applications. Some even make...
2010-05-12
585 reads
Running Totals Using Reporting Services
Sometimes one may need to see a running number that represents a quantity for a period of time. For example,...
2010-05-12
1,461 reads
SQL Saturday 38 Presentation
This past weekend was SQL Saturday 38 in Jacksonville Florida. It was a great event and the turnout was incredible....
2010-05-12
402 reads
Time Matters: Part 1
If you’re anything like me, you value every second of your day and you constantly try to find new ways...
2010-05-10
464 reads
Introduction to SSRS 2008 and SQL Saturday 38
In a few short weeks, another great event is coming to Jacksonville Florida at the UNF campus. There are many...
2010-04-26
360 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
Finding Trailing Spaces
Comments posted to this topic are about the item Finding Trailing Spaces
Question of the Day
Finding Trailing Spaces
I have some data in a SQL Server 2025 database. It looks like this for the dbo.Customer table:
CustomerID CustomerName PreferredName 1 Steve Steve 2 Andy Andy 3 Brian Brian 4 Allan Allan 5 Devin Devin 6 Steve Steve 7 Sally SallyI want to detect which names have a single trailing space. The CustomerName is a varchar() and the PreferredName is a CHAR(). Does this query detect the problem rows?
SELECT
CustomerID,
CustomerName,
PreferredName
FROM Customer
WHERE CustomerName <> RTRIM(CustomerName)
OR PreferredName <> RTRIM(PreferredName); See possible answers