Personally, my preferred method is to convert the string to VARBINARY, particularly since the grid view won't properly display many of the whitespace characters, so it can be difficult to...

It's most likely a leading tab instead of a leading space.  LTRIM/RTRIM will only remove spaces.

Drew

Assuming that you really are looking for a T-SQL version, I believe that this gives you what you are looking for.

SELECT
    facility_id,
    record_date,
   ...

In very broad terms, you have three options for fields in the SELECT clause of a query with a GROUP BY clause.

1. Group by the field
2. Aggregate the field
3. Skip the...

I'm reminded of another bad day.  One department at a former employer was using unlicensed software and a disgruntled former employee reported them for software piracy.  The president mandated that...

This wasn't the worst day, but it exemplifies the environment in one of the longest running worst times in my work life.  I was working at a university, and we...