Thanks! Also, I saw the name Steve Jones as a moderator. Do you know if this is the same Steve Jones who was a SysOpt/TechIMO moderator back in...

SSChampion, that is really intesting (and bizarre) to me.

I inherited the SQL Server solution here and thought that when I read "as Timestamp" in the DML, that I a timestamp...

I got it. It may not be aws elegant as it should be, but it generates the desired output.

select

a.facilityid

, a.facilityName as 'Facility'

, char(39) + REPLACE(CONVERT(VARCHAR(23), max(a.date_created), 126),...

Here's my edit

USE elr_reporting;

select

a.facilityid

, facilityName as Facility

, '-' + REPLACE(CONVERT(VARCHAR(23), max(a.date_created) as Timestamp, 126)

, DATEDIFF(day,max(a.date_created),getdate()) as 'Days_Since'

FROM [elr_reporting].[dbo].[elr_report_dw]as a

group by

a.facilityid

, facilityName

order by

Days_Since desc,

...

Is it possible to do this with a SELECT statement instead of relying upon the creation and use of an extract table?

Ideally I would like to have the conversion and...