SELECT DISTINCT Status_Legend.Status_Legend_ID, Status_Legend.Status_Legend_Desc, Status_Legend.Status_Legend_Severity, Station_Status_History.Status_Time FROM Status_Legend CROSS JOIN Station_Status_History WHERE (Status_Legend.Status_Legend_Desc = @Status_Legend_Desc) ORDER BY Status_Legend.Status_Legend_ID
1 good 7 2013-06-24 03:22:58 PM 1 good 7 2013-07-21 01:40:14 PM 1 good 7 2013-07-25 09:20:20 AM 1 good 7 2013-08-09 03:03:44 AM 1 good 7 2013-07-04 09:26:21 PM 1 good 7 2013-07-26 09:00:16 PM 1 good 7 2013-08-08 08:07:13 AM 1 good 7 2013-07-17 06:00:15 AM 1 good 7 2013-07-21 08:20:17 AM 1 good 7 2013-07-26 01:20:16 AM 1 good 7 2013-07-27 03:20:20 AM 1 good 7 2013-07-31 10:00:25 AM
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)