Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
SELECT DISTINCT A.CARRIER_ID, MAX (A.EFFECTIVE), A.TRLR_TYPE_ID, A.CURRENT_NUM_VEHICLES, L.NAME FROM TL_RESOURCE_TRLR A, CARRIER_EQUIP B,LANE L WHERE A.CARRIER_ID = B.CARRIER_ID(+) AND A.TRLR_TYPE_ID = B.TRLR_TYPE_ID(+) AND A.LANE_ID = L.ID AND B.CARRIER_ID IS NULL -- EXCLUDE ROWS ADDED BECAUSE OF THE OUTER JOIN GROUP BY a.carrier_id, a.trlr_type_id, current_num_vehicles, L.NAME ORDER BY A.CARRIER_ID ASC;
|Requesting help with creating an SQL query with 2 tables||6||31|
|how would you excute a sproc on another database on the fly||9||28|
|SQL Query incorrect syntax near the keyword ON any help would be appreciated||18||27|
|compare date to getdate()||8||13|