SELECT     TOP (100) PERCENT dbo.imtbl_work_order.wo_id, dbo.imtbl_work_order.description, dbo.imtbl_work_order.date_added,
                      dbo.imtbl_work_order.date_scheduled, dbo.imtbl_work_order.date_completed, GETDATE() AS Today, DATEDIFF(dd, GETDATE(),
                      dbo.imtbl_work_order.date_scheduled) AS Past_Due, DATEDIFF(dd, dbo.imtbl_work_order.date_scheduled, dbo.imtbl_work_order.date_completed)
                      AS Comp_Ontime, dbo.imtbl_work_order.status, dbo.imtbl_work_order_status.id AS Status_ID,
                      dbo.imtbl_work_order_status.description AS Status_Desc, dbo.imtbl_work_type.id AS Type_ID, dbo.imtbl_work_type.description AS Type_Desc,
                      CASE WHEN DATEDIFF(dd, date_scheduled, date_completed) > 0 THEN 1 ELSE 0 END AS OverDue
FROM         dbo.imtbl_work_order LEFT OUTER JOIN
                      dbo.imtbl_work_type ON dbo.imtbl_work_order.work_order_type = dbo.imtbl_work_type.pkey LEFT OUTER JOIN
                      dbo.imtbl_work_order_status ON dbo.imtbl_work_order.status = dbo.imtbl_work_order_status.pkey
WHERE     dbo.imtbl_work_order.status = 4
                          SELECT     dbo.imtbl_work_order.wo_id, dbo.imtbl_work_order.description, dbo.imtbl_work_order.date_added, dbo.imtbl_work_order.date_scheduled,
                                                  dbo.imtbl_work_order.date_completed, GETDATE() AS Today, DATEDIFF(dd, GETDATE(), dbo.imtbl_work_order.date_scheduled)
                                                  AS Past_Due, DATEDIFF(dd, dbo.imtbl_work_order.date_scheduled, dbo.imtbl_work_order.date_completed) AS Comp_Ontime,
                                                  dbo.imtbl_work_order.status, dbo.imtbl_work_order_status.id AS Status_ID, dbo.imtbl_work_order_status.description AS Status_Desc,
                                                  dbo.imtbl_work_type.id AS Type_ID, dbo.imtbl_work_type.description AS Type_Desc, CASE WHEN DATEDIFF(dd, date_scheduled,
                                                  date_completed) <= 0 THEN 1 ELSE 0 END AS OverDue
                           FROM         dbo.imtbl_work_order LEFT OUTER JOIN
                                                  dbo.imtbl_work_type ON dbo.imtbl_work_order.work_order_type = dbo.imtbl_work_type.pkey LEFT OUTER JOIN
                                                  dbo.imtbl_work_order_status ON dbo.imtbl_work_order.status = dbo.imtbl_work_order_status.pkey
                           WHERE     dbo.imtbl_work_order.status = 4
                           ORDER BY dbo.imtbl_work_order.work_order_type