It would help if you provided sample data as outlined in the first link in my signature.  It's confusing, because you're presenting single columns from one table instead of presenting...

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...