|
HOW TO:
Locate Vehicles with Duplicate Veh No Values
Overview:
This document will
help you locate the asset records where duplicate Veh No values are found.
Procedure:
Start FLEETMATE to access your existing database. Use the File
| Database | Issue
SQL Statement... menu option to open the Issue SQL Statement
dialog. Copy and paste the SQL Statement below into the center pane of the Issue
SQL Statement dialog. Make sure that the Query Type is set to Select,
and click the Execute! button for your
results. With a very large database, this query may take several seconds to run.
| SQL
Statement |
| SELECT '[' + Vehicle.TX_VEHNUMBER + ']' AS VehNo, Vehicle.TX_VIN FROM Vehicle WHERE (((Vehicle.TX_VEHNUMBER) In (SELECT [TX_VEHNUMBER] FROM [Vehicle] As Tmp GROUP BY [TX_VEHNUMBER] HAVING Count(*)>1 ))) ORDER BY
TX_VEHNUMBER; |
Results:
This query will list each Veh No value and VIN where the Veh No value has been duplicated, and will
show you the number of duplicates found.
|