Где Railo хранит файлы, созданные <cflog>?

Создайте свой вид без Order By. Удалите ORDER BY PS_Billing. [T / S Date], PS_Time. [Date] и добавьте их в свой SELECT.

SELECT     
PS_Billing.[T/S Date] AS TsDate, 
PS_Time.[Date] AS Date,
 dbo.PS_Proj.[Project ID],
            case 
            when PS_Proj.[City Name] is not null then  concat(PS_Proj.[City Name], ' ', PS_Proj.[State])
            when PS_Billing.[Location] is not null then max(PS_Billing.[Location])
            when PS_Time.[Labor Location ID] is not null then max(PS_Location.[Labor Location Name])
            else null
            end AS [Location]
FROM        dbo.PS_Location RIGHT OUTER JOIN
                     dbo.PS_Time ON dbo.PS_Location.[Labor Location ID] = dbo.PS_Time.[Labor Location ID] RIGHT OUTER JOIN
                     dbo.PS_Proj ON dbo.PS_Time.[Project ID] = dbo.PS_Proj.[Project ID] LEFT OUTER JOIN
                     dbo.PS_Billing ON dbo.PS_Proj.[Project ID] = dbo.PS_Billing.[Project ID] 

И выберите из своего списка с порядком по строке

Select FROM YOUR_VIEW_NAME as V
Order By V.TsDate, V.Date