I'm trying to find a way to convert a TOSTRING value to a number so that in my reporting I can display "order by" correctly and not in text.
,case when ack.timestamp is null then 'N/A'
end as [Minutes Until Acknowledged]
I love when I see my SWQL scripts floating around, haha.
I think you could do something like order by minutediff(ah.TimeStamp,ack.timestamp) to get what you want done.