Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
sms_query_to_rebuild_contacts_from_order_information [2021/11/17 17:25]
admin 		sms_query_to_rebuild_contacts_from_order_information [2021/11/17 17:26] (current)
admin [Explanation of SQL]
Line 3: Line 3:
 ===== Explanation of SQL ===== ===== Explanation of SQL =====
  
-This SQL will rebuild the "Contact Database" using information found in the Order and Estimate tables. It replaces the other information that is there.+This SQL will insert any missing contacts in the "Contact Database" using information found in the Order and Estimate tables. 
  
 ===== Risk of Data Corruption if Run Improperly ===== ===== Risk of Data Corruption if Run Improperly =====
Line 111: Line 112:
 ===== Version Information ===== ===== Version Information =====
  
-  * Entered : 03/2010 +  * Modified: 11/2021 
-  * Version : 8.6++  * Version : 8.91