Locate Vehicles with Duplicate Veh No Values
This document will
help you locate the asset records where duplicate Veh No values are found.
Start FLEETMATE Standard Edition 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.
|SELECT First([TX_VEHNUMBER]) AS [TX_VEHNUMBER Field], Count([TX_VEHNUMBER]) AS NumberOfDups FROM Vehicle GROUP BY [TX_VEHNUMBER] HAVING Count([TX_VEHNUMBER])>1;
This query will list each Veh No value that has been duplicated, and will
show you the number of duplicates found.