TECHNICAL ARTICLE: howto_024.htm

 Close Window  

 
 


Title:
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 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.
 

SQL Statement
SELECT First([TX_VEHNUMBER]) AS [TX_VEHNUMBER Field], Count([TX_VEHNUMBER]) AS NumberOfDups FROM Vehicle GROUP BY [TX_VEHNUMBER] HAVING Count([TX_VEHNUMBER])>1;

 
Results:
This query will list each Veh No value that has been duplicated, and will show you the number of duplicates found.
 



If you need additional assistance, please write or call us:
 support@FLEETMATE.com 
410-282-3603


FLEETMATE Software Copyright (c) 2005-2015 by SCB Consulting.  All rights reserved.
FLEETMATE is a registered trademark of SCB Consulting, LLC.