Alpha doesn't support Over is there any way to bring the row in as data?
Code:
SELECT row_number() over (ORDER BY dbo.device_info.DevName) as Row, dbo.device_info.DevId, dbo.device_info.DevName, dbo.device_info.PhoneNumber, CASE WHEN dbo.cwc_last_record_history.[TimeStamp] BETWEEN '2016-03-13' AND '2016-11-13' THEN DATEADD(HOUR, - 4, dbo.cwc_last_record_history.[TimeStamp]) ELSE DATEADD(HOUR, - 5, dbo.cwc_last_record_history.[TimeStamp]) END AS est, dbo.cwc_device_logid.logid, dbo.cwc_groups.GrpName, dbo.device_info.Online, dbo.device_info.LastConnTime, dbo.device_info.BatteryStatus, dbo.device_info.DevName AS unbound1, dbo.device_info.DevName AS unbound2, dbo.device_info.DevName AS unbound3, dbo.device_info.DevName AS unbound4, dbo.cwc_last_record_history.Speed / .62137 AS km, dbo.cwc_last_record_history.TimeStamp, dbo.cwc_last_record_history.StatType, dbo.cwc_last_record_history.Latitude, dbo.cwc_last_record_history.Longitude, dbo.cwc_last_record_history.Altitude, dbo.cwc_last_record_history.Heading, dbo.cwc_last_record_history.Speed FROM dbo.device_info INNER JOIN dbo.cwc_device_logid ON dbo.cwc_device_logid.DevId = dbo.device_info.DevId INNER JOIN dbo.cwc_groups ON dbo.cwc_groups.logid = dbo.cwc_device_logid.logid INNER JOIN dbo.cwc_last_record_history ON dbo.cwc_last_record_history.DevId = dbo.device_info.DevId
Comment