Differences

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

Link to this comparison view

Both sides previous revision Previous revision
compress_macro_ids_in_a_dataset_using_sql [2019/02/06 10:40]
kcifreo
compress_macro_ids_in_a_dataset_using_sql [2019/02/06 10:40] (current)
kcifreo
Line 3: Line 3:
 This document describes the process (and SQLs) used to compress the IDs in a table (or many tables). For example, if you started with a table with 100 records that were scattered between ID=1001 and ID=5873, this routine could compress them so that the IDs ranged from 100 to 200. This document describes the process (and SQLs) used to compress the IDs in a table (or many tables). For example, if you started with a table with 100 records that were scattered between ID=1001 and ID=5873, this routine could compress them so that the IDs ranged from 100 to 200.
  
-<html><div style="margin-left: 40px;"> **WARNING: This article is for reference. The changes made will PERMANENTLY affect your data. This should only be carried out by a skilled implementer and SQL practitioner. Always Backup your data before running this routine.** </div></html>+**WARNING: This article is for reference. The changes made will PERMANENTLY affect your data. This should only be carried out by a skilled implementer and SQL practitioner. Always Backup your data before running this routine.**
 ===== Concept ===== ===== Concept =====