SQL Files List

Tip: use browser’s search on page (Ctrl+F) to help find scripts of interest. The string “RM8” is typically added to the names of those written for scripts revised for or written for RootsMagic 8. The search term “rm8.sql” (sans quotes) will highlight them fast.

SQL files and where they are referenced

SQL FileUsed inDescription
Addresses-HowUsed.sqlAddresses - How Used
Addresses-with-No-Name-1.sql
Addresses-with-No-Name.sql
Ahnentafel-64_tidy.sqlAhnentafel 64 generations #ahnentafel #ancestors #reports
Ahnentafel-64.sqlAhnentafel 64 generations #ahnentafel #ancestors #reports
Ahnentafel-64.sqlList of Pages imported from Wikispaces Site
Ahnentafel-64.sqlQuery Menu
Ahnentafel-64.sqlSQLite Queries #sqlitemanagers #sql
AllCitations-Copy-1.sql
AllCitations-Copy.sql1 new page #colorcoding
AllCitations-RM7.sqlAll Citations - Query #citationsCitation list (for RM7 database format)
AllCitations-RM8.sqlAll Citations - Query #citationsCitation list (for RM8 database format)
AllCitations.sqlAll Citations & Dupes Count - Query #citations #duplicates
AllCitations.sqlAll Citations - Query #citations
AllCitations.sqlAllCitations.sql Error
AllCitations.sqlBundled Utilities - Groupings #application
AllCitations.sqlList of Pages imported from Wikispaces Site
AllCitations.sqlEarlier Queries by Date
AllCitations.sqlQuery Menu
AllCitations.sqlSQLite Queries #sqlitemanagers #sql
AllCitations.sqlhome - as exported
AllCitations.sql1 new page #colorcoding
AllCitationsDupes-1.sql
AllCitationsDupes.sql
AllFacts4Person10-OO.sql
AllFacts4Person11-OO.sqlPulling Together All the Events for An Individual #person #events #lifeline
AllFacts4Person4.sqlPulling Together All the Events for An Individual #person #events #lifeline
AllFacts4Person5.sqlBirths of children as facts #birth #child #events
AllFacts4Person8.sqlPulling Together All the Events for An Individual #person #events #lifeline
AllFacts4Person9.sql
AllFactsWidthTestGenerate.sqlGEDCOM & DnD Event Description Length Anomalies & Bugs #gedcom #events
AllFactsWidthTestParameters.sqlGEDCOM & DnD Event Description Length Anomalies & Bugs #gedcom #events
Ancestors.sqlAhnentafel 64 generations #ahnentafel #ancestors #reports
Ancestors.sqlAncestors Named Group #namedgroup #pedigree
Ancestors.sqlAncestors Query - Recursive #recursive
Ancestors.sqlAncestors Query #pedigree
Ancestors.sqlAnother version of a Set Living query #living
Ancestors.sqlBundled Utilities - Groupings #application
Ancestors.sqlChildren - Set Lineage to Birth #birth #ancestors #lineage
Ancestors.sqlList of Pages imported from Wikispaces Site
Ancestors.sqlEarlier Queries by Date
Ancestors.sqlGroup - Ancestors #ancestors #namedgroup #recursive
Ancestors.sqlGroup - Descendants #descendants #namedgroup #recursive
Ancestors.sqlLiving Flag - Set Globally #living #update #recursive
Ancestors.sqlMaps - Geo-Pedigree, plotting your ancestors' birth places #googlemaps #geocoding
Ancestors.sqlNamed Group Refresh #namedgroup
Ancestors.sqlNames - Delete Duplicate Alternate Names of Type 'Married' #alternatenames #names #duplicates
Ancestors.sqlQuery - All Names in Tree
Ancestors.sqlQuery Menu
Ancestors.sqlRecursive Queries - Ancestors and Descendants #recursive #ancestors #descendants
Ancestors.sqlSQLite Queries #sqlitemanagers #sql
Ancestors.sqlSet Living Flag #update #living
Ancestors.sqlSplitTree #splittreeancestorsleaves #application #visualc
Ancestors.sqlSubmit Your Problem #requestforhelp
Ancestors.sqlWish List
Ancestors.sqlhome - as exported
AncestorsGroup.sqlAncestors Named Group #namedgroup #pedigree
AncestorsGroup.sqlBundled Utilities - Groupings #application
AncestorsGroup.sqlQuery Menu
AncestorsGroup.sqlSQLite Queries #sqlitemanagers #sql
AncestorsRecursive.sqlRecursive Queries - Ancestors and Descendants #recursive #ancestors #descendants
Birth-AddFromChristenBaptism.sqlBirths - Add from Christening or Baptism #birth #events
BirthYearMisMatch.sqlBirth Year Mis-Match #date #birth
BirthYearMisMatch.sqlBundled Utilities - Groupings #application
BirthYearMisMatch.sqlDeath Year Mismatch #date #death
BirthYearMisMatch.sqlQuery Menu
BirthYearMisMatch.sqlSQLite Queries #sqlitemanagers #sql
BMD_private_multiples.sqlPrivatise Extra BMD Events #events #reports #privateScript for privatising plural BMD events.
BMD_private_multiples2.sqlPrivatise Extra BMD Events #events #reports #privateEnhanced to privatise all non-Primary BMD mults
Census-needed-1871-Canada-group-Unmark-list-1.sql
Census-needed-1871-Canada-group-Unmark-list.sqlNamed Group - Mark or Unmark List refresh #namedgroup
CensusNeededGroup.sqlA Proposal for a Named Group and Color Manager
CensusNeededGroup.sqlBundled Utilities - Groupings #application
CensusNeededGroup.sqlCensus Needed - Named Group #namedgroup #census
CensusNeededGroup.sqlQuery Menu
CensusNeededGroup.sqlSQLite Queries #sqlitemanagers #sql
CensusNeededGroup.sqlAargh! Systemic Error re: GroupID
CensusNeededGroup2.sqlBundled Utilities - Groupings #application
CensusNeededGroup2.sqlCensus Needed - Named Group #namedgroup #census
CensusNeededGroup2.sqlQuery Menu
CensusNeededGroup2.sqlSQLite Queries #sqlitemanagers #sql
CensusNeededGroup2.sqlAargh! Systemic Error re: GroupID
CensusNeededGroup2.sql
CheckTMGimportforCodes.sqlTMG-RootsMagic Sentence Variables & Format Codes #tmg
Children-NeedingManualArranging-2.sqlChildren - Needing Manual Arranging #child #family #sortdate
Children-NeedingManualArranging.sqlChildren - Needing Manual Arranging #child #family #sortdate
Children-SetLineage2Birth.sqlChildren - Set Lineage to Birth #birth #ancestors #lineage
Children-SetOrderByBirthSortDate.sqlChildren - Needing Manual Arranging #child #family #sortdate
Children-SetOrderByBirthSortDate.sqlChildren - Set Order by Birth SortDate #child #family #sortdate #update
Citations_TMGimport_splitCDtoCD1-2.sql
Citations_TMGimport_splitCDtoCD1-9.sqlTMG-RootsMagic Split Citation Details #tmg #citations #sourcetemplates
Citations-Dupes-Delete.sqlCitations - Delete Duplicates #citations #sources #duplicates
Citations-Invisible-Convert-to-Personals-1.sql
Citations-Invisible-Convert-to-Personals-Flagged-1.sql
Citations-Invisible-Convert-to-Personals-Flagged.sqlCitations Invisible - Reveal and Revert #citations #sources #ftm2014 #ftm2012 #ancestrycom #gedcom
Citations-Invisible-Convert-to-Personals.sqlCitations Invisible - Reveal and Revert #citations #sources #ftm2014 #ftm2012 #ancestrycom #gedcom
Citations-Invisible-Convert-to-Personals.sqlCitations Invisible Revealed #citations #ancestrycom
Citations-Invisible-List-1.sql
Citations-Invisible-List.sqlCitations Invisible Revealed #citations #ancestrycom
Citations-Invisible-Revealed-Revert-1.sql
Citations-Invisible-Revealed-Revert-Bitwise-1.sql
Citations-Invisible-Revealed-Revert-Bitwise.sqlCitations Invisible - Reveal and Revert #citations #sources #ftm2014 #ftm2012 #ancestrycom #gedcom
Citations-Invisible-Revealed-Revert.sqlCitations Invisible - Reveal and Revert #citations #sources #ftm2014 #ftm2012 #ancestrycom #gedcom
CitationSort.sql
ColorCode-byConsanguinity1.sqlColor Code by Consanguinity Degree #colorcoding #relationships
ColorCode-byConsanguinity2.sqlColor Code by Consanguinity Degree #colorcoding #relationships
ColorCode-byConsanguinity3.sqlColor Code by Consanguinity Degree #colorcoding #relationships
ColorCode-byLivingFlag.sqlLiving Flag - Set Globally #living #update #recursive
CopyFact2Group.sqlBundled Utilities - Groupings #application
CopyFact2Group.sqlCopy Fact to Group #update #namedgroup #events
CopyFact2Group.sqlQuery Menu
CopyFact2Group.sqlSQLite Queries #sqlitemanagers #sql
CopyFact2Group.sqlAargh! Systemic Error re: GroupID
CopyFact2Group.sqlrev, 2020-05-16
cte-facts-citations-RM7.sqlCommon Table Expressions – The Building Blocks of SQLEvents and Citations list demonstrating use of Common Table Expressions (for RM7 database format)
cte-facts-citations-RM8.sqlCommon Table Expressions – The Building Blocks of SQLEvents and Citations list demonstrating use of Common Table Expressions (for RM8 database format)
CustomDatabaseShell.sqlBundled Utilities - Groupings #application
CustomDatabaseShell.sqlDepopulate but keep Customs, Places, Sources #database #places #placedetails #sourcetemplates #sources #facttypes #custom #media #roles
CustomDatabaseShell.sqlQuery Menu
CustomDatabaseShell.sqlSQLite Queries #sqlitemanagers #sql
Database-CopyMasterListsToShell.sqlDatabase - Copy Master Lists to Shell
DateDecoder.sqlBundled Utilities - Groupings #application
DateDecoder.sqlDate Decoder #date
DateDecoder.sqlDates - SortDate Algorithm #date #sortdate
DateDecoder.sqlQuery Menu
DateDecoder.sqlSQLite Queries #sqlitemanagers #sql
DateFormat.sqlDate Decoder #date
DeathYearMisMatch.sqlBundled Utilities - Groupings #application
DeathYearMisMatch.sqlDeath Year Mismatch #date #death
DeathYearMisMatch.sqlQuery Menu
DeathYearMisMatch.sqlSQLite Queries #sqlitemanagers #sql
DeleteByColorCode.sqlDelete Many #delete
DeleteByColorCode.sqlDelete Phantoms #database #delete #phantom
DeleteByColorCode.sqlQuery Menu
DeleteByColorCode.sqlSQLite Queries #sqlitemanagers #sql
DeleteByNamedGroup.sqlDelete Many #delete
DeleteByNamedGroup.sqlQuery Menu
DeleteByNamedGroup.sqlSQLite Queries #sqlitemanagers #sql
DeleteByNamedGroup2.sqlDelete Many #delete
DeletePhantoms.sqlDelete Many #delete
DeletePhantoms.sqlDelete Phantoms #database #delete #phantom
DeletePhantoms.sqlMedia - Delete Unused #media #delete
DeletePhantoms.sqlPlaces - Delete Unused #places #placedetails #delete #phantom
DeletePhantoms.sqlQuery Menu
DeletePhantoms.sqlSQLite Queries #sqlitemanagers #sql
DeletePhantoms.sqlUpdates responding to TreeShare
DeletePhantoms2.sqlDelete Phantoms #database #delete #phantom
DeletePhantoms3.sqlDelete Phantoms #database #delete #phantom
DeletePhantoms3.sqlUpdates responding to TreeShare
DeletePhantoms3.sql
DescendantsRecursive.sqlRecursive Queries - Ancestors and Descendants #recursive #ancestors #descendants
DNA_mtDNA_locationslist.sqlBundled Utilities - Groupings #application
DNA_mtDNA_locationslist.sqlDNA Test results list #dna #xml #replace
DNA_mtDNA_locationslist.sqlQuery Menu
DNA_mtDNA_locationslist.sqlSQLite Queries #sqlitemanagers #sql
DNA_Y-STR_markerslist.sqlBundled Utilities - Groupings #application
DNA_Y-STR_markerslist.sqlDNA Test results list #dna #xml #replace
DNA_Y-STR_markerslist.sqlQuery Menu
DNA_Y-STR_markerslist.sqlSQLite Queries #sqlitemanagers #sql
DummyFamily-Add.sqlQuery Menu
DummyFamily-Add.sqlReports, Narrative, Jerry Bryan Trick #reports
DummyFamily-Add.sqlSQLite Queries #sqlitemanagers #sql
DummyFamily-Add2.sqlReports, Narrative, Jerry Bryan Trick #reports
DummyFamily-Delete.sqlQuery Menu
DummyFamily-Delete.sqlReports, Narrative, Jerry Bryan Trick #reports
DummyFamily-Delete.sqlSQLite Queries #sqlitemanagers #sql
DuplicateNameSearch.sqlBundled Utilities - Groupings #application
DuplicateNameSearch.sqlDuplicate Name Search - query #duplicates #names
DuplicateNameSearch.sqlQuery Menu
DuplicateNameSearch.sqlSQLite Queries #sqlitemanagers #sql
Empty4084Schema.sqlVersion Monitoring #database #databaseproperties #datadefinitions
Empty4097Schema.sql
Empty4098Schema.sql
Empty4114Schema.sql
Empty4121Schema.sqlVersion Monitoring #database #databaseproperties #datadefinitions
Event-Add_Marriage.sqlList of Pages imported from Wikispaces Site
Event-Add_Marriage.sqlEvent - Add Marriage to Couples Without #events
Event-Add_Marriage.sqlQuery Menu
EventDescriptionToNote-Move.sqlEvents - Move Description to Note #events #notes
EventNoteToDescription-Move.sqlEvents - Move Short Note to Description #events #tmg #notes
Events-CitationsMissing-UsingViews.sqlA Sample Query Created with Views #events #colorcoding #sql #views #citations #sources
Events-CitationsMissing-UsingViews.sqlEarlier Queries by Date
Events-CitationsMissing-UsingViews.sqlhome - as exported
Events-FMNO.sqlFacts - Add custom MRIN event to each family #facttypes #events #mrin
Events-MismatchedFMNO.sqlFacts - Add custom MRIN event to each family #facttypes #events #mrin
Events-MismatchedMRIN.sql
Events-MRIN.sql
Events-sans_media_rescensus-1.sql
Events-sans_media_rescensus.sqlEvents with no Media attached #events #media
FactOrderTable.sqlFacts - Sort Order Problems #events #date #sortdate
FactOrderTable.sqlQuery Menu
Facts_shared-ChangeType.sqlFacts - Change Fact Type #facttypes #events
Facts-ChangeType.sql
Facts-RefNos_person_spouse_parents.sqlFacts - Reference Numbers for person, spouse and parents. #facttypes #events #refno
Facts-Split-HideTracks.sqlFacts - Split Shared to Individual #facttypes #events #sharedevent
Facts-Split-HideTracks.sqlQuery Menu
Facts-Split-Undo.sqlFacts - Split Shared to Individual #facttypes #events #sharedevent
Facts-Split-Undo.sqlQuery Menu
Facts-SplitSharedToIndiv-NoRIN.sqlFacts - Split Shared to Individual #facttypes #events #sharedevent
Facts-SplitSharedToIndiv.sqlFacts - Split Shared to Individual #facttypes #events #sharedevent
Facts-SplitSharedToIndiv.sqlQuery Menu
Facts-TranslateNames.sqlLanguage other than English #languages #reports #french
Facts-Unshare.sqlFacts - Split Shared to Individual #facttypes #events #sharedevent
Facts-Unshare.sqlQuery Menu
FactsHavingPlaceDetails.sqlBundled Utilities - Groupings #application
FactsHavingPlaceDetails.sqlFacts Having Place Details - Query #placedetails #events
FactsHavingPlaceDetails.sqlQuery Menu
FactsHavingPlaceDetails.sqlSQLite Queries #sqlitemanagers #sql
FactsHavingPlaceDetails2.sqlFacts Having Place Details - Query #placedetails #events
FactsHavingPlaceDetails3.sqlBundled Utilities - Groupings #application
FactsHavingPlaceDetails3.sqlFacts Having Place Details - Query #placedetails #events
FactsHavingPlaceDetails3.sqlQuery Menu
FactsHavingPlaceDetails3.sqlSQLite Queries #sqlitemanagers #sql
FactsSharedWithTreelessPersons-OO.sqlPeople Who Share A Fact with a Principal, But Who Are Not in a Tree in The File List - Query #sharedevent #person
FactType-Convert-Census_shared-to-Year_Census-1.sql
FactType-Convert-Census_shared-to-Year_Census.sqlFact Type - Convert Census to yyyy Census and back #facttypes #census
FactType-Convert-Census_unshared-to-Year_Census-1.sql
FactType-Convert-Census_unshared-to-Year_Census.sqlFact Type - Convert Census to yyyy Census and back #facttypes #census
FactType-Convert-Census-to-Year_Census.sql
FindAlmostEverywhere-Build_FTS_table.sqlSearch - wayfinding from data tables to RootsMagic screens #database #fts #search
FindAlmostEverywhere-Build_FTS_table.sqlSearch - Find Almost Everywhere #search #fts
FindAlmostEverywhere-Search_LocateQuery.sqlSearch - Find Almost Everywhere #search #fts
FindAlmostEverywhere-Search_Simple.sqlSearch - Find Almost Everywhere #search #fts
FindAlmostEverywhere-Snippet_Waymarks_LocateQuery.sqlSearch - wayfinding from data tables to RootsMagic screens #database #fts #search
FindAlmostEverywhere.sqlSearch - wayfinding from data tables to RootsMagic screens #database #fts #search
FindAlmostEverywhere.sqlSearch - Find Almost Everywhere #search #fts
FindEverywhere.sql
FTMimport-MoveEventPlaceDetail2Description.sqlFTM import - restore Event description from Place Details #ftm2014 #ftm2012 #placedetails #events
Geo-Lifelines.sql
Group-Ancestors.sql
Group-Descendants.sql
Group-Extract.sqlGroups - Extract most everything for one to a new database #namedgroup #TreeShare
Group-PersonsWithDuplicateEvents.sqlGroup - Persons with Duplicate Events #namedgroup #events #date #duplicates
Group-PersonsWithTextDates.sqlGroup - Persons with Text Dates #date #namedgroup
Group-UnconnectedPersons.sqlGroup - Unconnected Persons #namedgroup
GroupsPopulation.sqlGroup - Population statistic #namedgroup
GroupTableWrite.sqlNamed Group Refresh #namedgroup
ImportPicasaDescriptions.sqlMedia Metadata, Read, Write, Compare with Picasa #media #metadata #picasa
ImportPicasaDescriptions.sqlQuery Menu
ImportPicasaDescriptions.sqlSQLite Queries #sqlitemanagers #sql
KinshipList.sql
LifeLines-OO.sqlLifeLines #places #placedetails #events #lifelines
LifeLines-OO.sqlSQLiteManagers #sqlitemanagers
LifeLines-RINparm.sqlLifeLines #places #placedetails #events #lifelines
LivingFlag-GlobalSet.sqlLiving Flag - Set Globally #living #update #recursive
Make-Pop-TmpCitation.sql
MapEvents-KML.sqlBundled Utilities - Groupings #application
MapEvents-KML.sqlList of Pages imported from Wikispaces Site
MapEvents-KML.sqlEarlier Queries by Date
MapEvents-KML.sqlMapEvents-KML query #googlemaps #places #placedetails #geocoding #events
MapEvents-KML.sqlQuery Menu
MapEvents-KML.sqlSQLite Queries #sqlitemanagers #sql
MarkNotProblem.sqlBundled Utilities - Groupings #application
MarkNotProblem.sqlDuplicate Search Merge Database #datadefinitions #duplicates
MarkNotProblem.sqlQuery Menu
MarkNotProblem.sqlSQLite Queries #sqlitemanagers #sql
MarriageLength.sql
MasterSources.sqlEarlier Queries by Date
MasterSources.sqlSource List Query #sources #sourcetemplates #citations #xml #date
MasterSources.sqlhome - as exported
MasterSources.sql
Media-DupFilesList.sqlMedia Duplicates - Reports and Remedies
Media-DupThumbnailsList.sqlMedia Duplicates - Reports and Remedies
Media-MergeDuplicates.sqlMedia Duplicates - Reports and Remedies
Media-UsersList.sqlMedia Users List Query #media
Media-UsersList3.sqlMedia Users List Query #media
Media-UsersList4.sqlMedia Users List Query #media
MediaDeleteUnused.sqlMedia - Delete Unused #media #delete
MediaDeleteUnused.sqlQuery Menu
MediaList-RM5.sqlMedia List Query #media #filenames #msexcel #date #person #family #events #sources #citations #places #placedetails
MediaList.sqlMedia List Query #media #filenames #msexcel #date #person #family #events #sources #citations #places #placedetails
MediaRepair.sqlBundled Utilities - Groupings #application
MediaRepair.sqlMedia Repair Queries #filenames #duplicates #media #links #rmnocase #delete #update
MediaRepair.sqlQuery Menu
MediaRepair.sqlSQLite Queries #sqlitemanagers #sql
MediaShuffle.sqlMedia - Bulk Rename and Relink #media #multimediatable #batch
MediaTags-CopySharedFactsMediaToShareePersonal.sqlMediaTags - Copy Shared Facts Media To Sharee Personal #media #sharedevent
MediaTags-CopySharedFactsMediaToShareePersonal.sqlQuery Menu
MediaTags-DeletePersonalHavingFactDupes.sqlMediaTags - Copy Shared Facts Media To Sharee Personal #media #sharedevent
MediaTags-DeletePersonalHavingFactDupes.sqlMediaTags - Delete Personal Having Fact Duplicates #media
MediaTags-DeletePersonalHavingFactDupes.sqlQuery Menu
MediaTags-SetPrimaryForPersons.sqlMedia - Set Primary Photo for Persons #media #update
MediaTypeReset.sqlMedia Type Reset #media #update
MediaTypeReset.sqlQuery Menu
MediaTypeReset.sqlSQLite Queries #sqlitemanagers #sql
MergeAncestryURLsToFTM.sqlAncestry.com and RootsMagic 5 #ancestrycom #sources #update #gedcom
MergeAncestryURLsToFTM.sqlQuery Menu
MergeAncestryURLsToFTM.sqlSQLite Queries #sqlitemanagers #sql
missing_stuff.sqlEvents with no Media attached #events #media
Multi-spouses.sql
Name-Add_Married.sqlNames - Add Married #names #alternatenames #marriage #spouse
Name-Add_Married.sqlQuery Menu
Name-Add_Married.sqlSQLite Queries #sqlitemanagers #sql
Name-Married_in_DeathSentence.sqlNames - married name in death sentences #names #alternatenames #death
NameFind.sqlBundled Utilities - Groupings #application
NameFind.sqlName Find query #search
NameFind.sqlQuery Menu
NameFind.sqlSQLite Queries #sqlitemanagers #sql
Names-AltMarriedDupeDelete.sqlNames - Delete Duplicate Alternate Names of Type 'Married' #alternatenames #names #duplicates
Names-ConcordanceCaps.sql
Names-ConcordanceCapsFirstYrsMids.sql
Names-Edit_NameTable.sqlList of Pages imported from Wikispaces Site
Names-Edit_NameTable.sqlEarlier Queries by Date
Names-Edit_NameTable.sqlNames - Edit NameTable with SQLite Expert #names #alternatenames #editable #sqliteexpert
Names-Swap_AltBirth_to_Primary.sqlNames - Set Alternate of type Birth to Primary #names #alternatenames #birth
NickAltNameConflict.sqlNickname Manipulations #nicknames
NickGivenCombine.sqlNickname Manipulations #nicknames
NickGivenSplit.sqlNickname Manipulations #nicknames
NicknameAmbivalent.sqlNickname Manipulations #nicknames
Notes-Invisible-Convert-to-General-1.sql
Notes-Invisible-Convert-to-General.sqlNotes Invisible Revealed #notes #tmg #gedcom
Notes-Invisible-List-1.sql
Notes-Invisible-List.sqlNotes Invisible Revealed #notes #tmg #gedcom
OrphanedPlaceDetails_DeleteUnused.sqlPlace Details without a Place #places #phantom
OrphanedPlaceDetails_DeleteUnused.sqlPlace Errors #placedetails #places
OrphanedPlaceDetails.sqlPlace Details without a Place #places #phantom
OrphanedPlaceDetails.sqlPlace Errors #placedetails #places
Paragraph-add.sqlBundled Utilities - Groupings #application
Paragraph-add.sqlParagraphing #update #paragraphing #reports
Paragraph-add.sqlQuery Menu
Paragraph-add.sqlSQLite Queries #sqlitemanagers #sql
Paragraph-strip.sqlBundled Utilities - Groupings #application
Paragraph-strip.sqlParagraphing #update #paragraphing #reports
Paragraph-strip.sqlQuery Menu
Paragraph-strip.sqlSQLite Queries #sqlitemanagers #sql
ParentSingleMerge.sqlMerge Duplicate Single Parent Couples #merge #spouse #child #phantom
PersonsBegatChildren.sqlBirths of children as facts #birth #child #events
PersonsBegatChildren.sqlBundled Utilities - Groupings #application
PersonsBegatChildren.sqlQuery Menu
PersonsBegatChildren.sqlSQLite Queries #sqlitemanagers #sql
PersonsWithTextDates.sqlGroup - Persons with Text Dates #date #namedgroup
Place_Details-Convert_to_Place.sqlPlaces to Place Details Conversion #places #placedetails #update
Place_Frequency_GPSVisualizer.sqlMaps - markers proportional to number of events #googlemaps #geocoding
Place_Frequency.sqlMaps - markers proportional to number of events #googlemaps #geocoding
Place_Frequency.sqlPlaces - Frequency of Use #places #geocoding
Place_Frequency.sqlQuery Menu
PlaceAbbrevUpdate.sqlPlace Names - parse and recombine #places #instr
PlaceAbbrevUpdate.sqlQuery Menu
PlaceCommaParse.sqlPlace Names - parse and recombine #places #instr
PlaceCommaParse.sqlQuery Menu
PlaceErrors3.sql
PlaceNameUpdate.sqlPlace Names - parse and recombine #places #instr
PlaceNameUpdate.sqlQuery Menu
PlaceParse.sql
PlaceReverse.sqlPlaces - Count People and Events for a Group #places #statistics #events #namedgroup
Places-ConvertPlaceDetailsToPlaces.sqlPlaces - Conversion of Place Details to Places #places #placedetails #update
Places-EventCount.sqlPlaces - Count People and Events for a Group #places #statistics #events #namedgroup
Places-FirstNameExploit.sql
Places-PeopleCount.sqlPlaces - Count People and Events for a Group #places #statistics #events #namedgroup
Places-RecombineFTMfractures.sqlPlaces - Recombine Fractures from FTM 2012 #ancestrycom #ftm2012 #places
Places-RecombineFTMfractures.sqlQuery Menu
Places-UnConvertPlaceDetailsConvertedToPlaces.sqlPlaces - Conversion of Place Details to Places #places #placedetails #update
PlacesDeleteUnused.sqlPlaces - Delete Unused #places #placedetails #delete #phantom
PlacesWithoutGeocodesForGroup.sql
PrivatizeLiving.sqlPrivatize Living #private #reports #gedcom
Proven.sqlBackup Media with Database - RAR #batch #backup #media #rar
Proven.sqlChildren - Set Lineage to Birth #birth #ancestors #lineage
Proven.sqlList of Pages imported from Wikispaces Site
Proven.sqlEarlier Queries by Date
Proven.sqlQuery Menu
Proven.sqlReportNon_proven #events
Proven.sqlSource Templates by Origin #sourcetemplates
Proven.sqlSources - Adventures in Extreme Splitting #sources #sourcetemplates #replace
Proven.sqlTools - Problem Search - Spouse Order Questioned #tools #spouse
Proven.sqlCommon Table Expressions – The Building Blocks of SQL
RecursiveAncestors.sqlAncestors Query - Recursive #recursive
REFN_CopyFSID.sqlCOPY FamilySearchID to REFN fact #refno #FamilySearch
REFN-MRIN.sqlRIN MRIN - add Reference Number fact to all persons #mrin #refno #rin
REFN-RematchFSID.sqlREMATCH to FamilySearch ID in REFN fact #FamilySearch #refno
Reports-NewParagraphGeneralNote.sqlReports - New Paragraph for General Note #paragraphing #reports
Reports-PointFormNarrativeSetup.sqlReports - Point Form Narratives Setup #reports
Reports-PointFormNarrativeSetup2.sqlReports - Point Form Narratives Setup #reports
Reports-RestoreAfterPointForm.sqlReports - Point Form Narratives Setup #reports
Reports-RestoreAfterPointForm2.sqlReports - Point Form Narratives Setup #reports
RM4_Copy_data_to_DB3_NOCASE.sqlConvert Database to NOCASE #rmnocase
RM4_CREATE_as_DB3_NOCASE.sqlComparing Two RM Databases #compare #database #rmnocase
RM4_CREATE_as_DB3_NOCASE.sqlConvert Database to NOCASE #rmnocase
RM4_Queries.sqlFour Little Queries #names #blanks #placedetails
RM4_Queries.sqlSubmit Your Problem #requestforhelp
RM4_Queries.sqlhome - as exported
RM4-MultiLinkedMediaDuplicationPreRM5.sqlMedia - Preserve Captions et al from RM4 to RM5 #media #metadata #batch
RM4-MultiLinkedMediaDuplicationPreRM5.sqlQuery Menu
RM4-MultiLinkedMediaDuplicationPreRM5.sqlSQLite Queries #sqlitemanagers #sql
RM5_Copy_data_to_DB3_NOCASE.sqlConvert Database to NOCASE #rmnocase
RM5_CREATE_as_DB3_NOCASE.sqlConvert Database to NOCASE #rmnocase
RM5copyMetadataToImageFileExifToolArgList.sqlMedia Metadata, Read, Write, Compare with Picasa #media #metadata #picasa
RM5copyMetadataToImageFileExifToolArgList.sqlQuery Menu
RM5copyMetadataToImageFileExifToolArgList.sqlSQLite Queries #sqlitemanagers #sql
RM5copyMetadataToRM.sqlMedia Metadata, Read, Write, Compare with Picasa #media #metadata #picasa
RM5copyMetadataToRM.sqlQuery Menu
RM5copyMetadataToRM.sqlSQLite Queries #sqlitemanagers #sql
RM6_WaymarksViews.sql
RM7_5_WaymarksViews-1.sql
RM7_5_WaymarksViews.sqlAncestry TreeShare - Impact #ancestrycom #TreeShare
RM7_5_WaymarksViews.sqlEvents with no Media attached #events #media
RM7_5_WaymarksViews.sqlSearch - wayfinding from data tables to RootsMagic screens #database #fts #search
RM7_5_WaymarksViews.sqlTreeShare - Rename Cryptic Filenames for Citation Media #TreeShare #media #citations #batch
RM7_5_WaymarksViews.sqlUpdates responding to TreeShare
RM7_5_WaymarksViews.sql
RMGC_Properties.sqlBundled Utilities - Groupings #application
RMGC_Properties.sqlCitations - Delete Duplicates #citations #sources #duplicates
RMGC_Properties.sqlList of Pages imported from Wikispaces Site
RMGC_Properties.sqlGEDCOM & DnD transfer losses #gedcom
RMGC_Properties.sqlMedia Repair Queries #filenames #duplicates #media #links #rmnocase #delete #update
RMGC_Properties.sqlPlace Details without a Place #places #phantom
RMGC_Properties.sqlQuery Menu
RMGC_Properties.sqlRMGC_Properties - Query #databaseproperties #subqueries #integrity
RMGC_Properties.sqlSQLite Queries #sqlitemanagers #sql
RMGC_Properties.sqlShared Events With Missing Witnesses #sharedevent
RMGC_TablesRowCount.sql
RoleSort.sqlRoles-Sort Alphabetically #roles #facttypes
SharableEvents-Convert.sqlBundled Utilities - Groupings #application
SharableEvents-Convert.sqlQuery Menu
SharableEvents-Convert.sqlSQLite Queries #sqlitemanagers #sql
SharableEvents-Convert.sqlSharable Events - Find and Convert to Shared #sharedevent
SharableFacts2.sqlBundled Utilities - Groupings #application
SharableFacts2.sqlQuery Menu
SharableFacts2.sqlSQLite Queries #sqlitemanagers #sql
SharableFacts2.sqlSharable Events - Find and Convert to Shared #sharedevent
SortDateDecodeDev.sqlDates - SortDate Algorithm #date #sortdate
SortDateDecodeDev.sqlQuery Menu
SortDateDecodeDev.sqlSQLite Queries #sqlitemanagers #sql
SortDateEncodeDecode.sqlBundled Utilities - Groupings #application
SortDateEncodeDecode.sqlDates - SortDate Algorithm #date #sortdate
SortDateEncoderDev.sqlDates - SortDate Algorithm #date #sortdate
SortDateEncoderDev.sqlEarlier Queries by Date
SortDateEncoderDev2.sqlDates - SortDate Algorithm #date #sortdate
SortDateSameDayOrder.sqlBundled Utilities - Groupings #application
SortDateSameDayOrder.sqlDates - Same Day Sort Order #date #sortdate #update
SortDateSameDayOrder.sqlEvents - Add to all Children a Parent event shared with parents #facttypes #sharedevent #relationships
SortDateSameDayOrder.sqlQuery Menu
SortDateSameDayOrder.sqlQuery to Add Parents Events to RM Database #facttypes #events #sharedevent
SortDateSameDayOrder.sqlSQLite Queries #sqlitemanagers #sql
SortDateSameDayOrderCustom.sqlBundled Utilities - Groupings #application
SortDateSameDayOrderCustom.sqlDates - Same Day Sort Order #date #sortdate #update
SortDateSameDayOrderCustom.sqlEvents - Add to all Children a Parent event shared with parents #facttypes #sharedevent #relationships
SortDateSameDayOrderCustom.sqlQuery Menu
SortDateSameDayOrderCustom.sqlQuery to Add Parents Events to RM Database #facttypes #events #sharedevent
SortDateSameDayOrderCustom.sqlSQLite Queries #sqlitemanagers #sql
SortOrderProblems.sqlFacts - Sort Order Problems #events #date #sortdate
SortOrderProblems.sqlQuery Menu
SourceList.sqlSharable Events - Find and Convert to Shared #sharedevent
SourceList.sqlSource List Query #sources #sourcetemplates #citations #xml #date
sources_without_media.sqlList of Pages imported from Wikispaces Site
sources_without_media.sqlEarlier Queries by Date
sources_without_media.sqlQuery for Sources Without Media #sources #media
sources_without_media.sqlSources - Adventures in Extreme Splitting #sources #sourcetemplates #replace
Sources-AuthorUnreverse.sqlSources - Unreverse Author Names #sources #tmg
Sources-CopyRepositoryInfoTo.sqlSources - Copy Repository Name, Address from Repository List #sources #sourcetemplates #repositories
Sources-CreateExtremelySplitFromCitations.sqlSources - Adventures in Extreme Splitting #sources #sourcetemplates #replace
Sources-DeleteAfterSplit.sqlSources - Adventures in Extreme Splitting #sources #sourcetemplates #replace
Sources-HybridFF-SetFF-Export.sqlSource Templates - Versatile Free Form Hybrids #sourcetemplates #sources
Sources-HybridFF-UnSetFF.sqlSource Templates - Versatile Free Form Hybrids #sourcetemplates #sources
Sources-MergeDuplicates.sqlSources - Merge Duplicate Masters #merge #sources
Sources-UnifyAliases_RepositoryLoc.sqlSources - Copy Repository Name, Address from Repository List #sources #sourcetemplates #repositories
SourcesByDetailLength.sqlSource Template, A Better Free Form #sourcetemplates #sources #search #replace
SourcesSort.sqlSource Citation Sort #sources #citations
SourceTemplateExtremeSplitConvert.sqlSource Templates - Convert Builtins to Editable, Split, Import #sourcetemplates
SourceTemplateExtremeSplitConvert.sqlSources - Adventures in Extreme Splitting #sources #sourcetemplates #replace
SourceTemplateListWithCitationDetails.sqlBundled Utilities - Groupings #application
SourceTemplateListWithCitationDetails.sqlQuery Menu
SourceTemplateListWithCitationDetails.sqlSQLite Queries #sqlitemanagers #sql
SourceTemplateListWithCitationDetails.sqlSource Template List - Query #sources #sourcetemplates
SourceTemplateListWithCitationDetails2.sqlBundled Utilities - Groupings #application
SourceTemplateListWithCitationDetails2.sqlQuery Menu
SourceTemplateListWithCitationDetails2.sqlSQLite Queries #sqlitemanagers #sql
SourceTemplateListWithCitationDetails2.sqlSource Template List - Query #sources #sourcetemplates
SourceTemplateRevisionUtilities.sqlSource Templates - Revision Utilities #sourcetemplates
SourceTemplates_CopyBuiltin2Editable.sqlSource Templates - Convert Builtins to Editable, Split, Import #sourcetemplates
SourceTemplates-FieldCount.sql
SourceTemplates-MergeDuplicates.sqlSource Templates - Merge Duplicates #sourcetemplates #sources #merge
SourceTemplates-SetUKquotePunctuation.sqlSource Templates - Set Quotation Punctuation to 'UK' or 'Logical' Placement #sourcetemplates #update
SourceTemplatesHybridFreeFormConvert.sqlSource Templates - Versatile Free Form Hybrids #sourcetemplates #sources
SpouseID_Invalid-Check.sqlSpouseID Invalid #spouse #error #family
SpouseID_Invalid-Reset.sqlSpouseID Invalid #spouse #error #family
SpouseOrderQuestioned.sqlTools - Problem Search - Spouse Order Questioned #tools #spouse
SpouseSort.sqlSpouse Order - Global Sort by Marriage or First-Birth SortDate #spouse
SpouseSort2.sqlSpouse Order - Global Sort by Marriage or First-Birth SortDate #spouse
SrcTmpltsConvert.sqlBundled Utilities - Groupings #application
SrcTmpltsConvert.sqlQuery Menu
SrcTmpltsConvert.sqlSQLite Queries #sqlitemanagers #sql
SrcTmpltsConvert.sqlSource Templates #sources #sourcetemplates #rmnocase #conversion #editable
SrcTmpltsConvert.sqlhome - as exported
SrcTmpltsConvert2.sqlSource Templates #sources #sourcetemplates #rmnocase #conversion #editable
SrcTmpltsConvert2.sqlhome - as exported
SrcTmpltsRevert.sqlBundled Utilities - Groupings #application
SrcTmpltsRevert.sqlQuery Menu
SrcTmpltsRevert.sqlSQLite Queries #sqlitemanagers #sql
SrcTmpltsRevert.sqlSource Templates #sources #sourcetemplates #rmnocase #conversion #editable
SrcTmpltsRevert2.sqlSource Templates #sources #sourcetemplates #rmnocase #conversion #editable
Stats-MaxChildren.sql
TMG-RM_convertTMG_IDtoREF.sqlTMG-RM Convert TMG_ID to Reference Number #tmg #refno
TMG-RM_convertTMG_IDtoRIN.sqlTMG-RM Convert TMG_ID to Record Number #tmg #rin
TMG-RM_FalseSpousalEventSentences.sqlTMG-RM Check for False Spousal Event Sentences #tmg
TMG-RM_Sentence_Tweaks.sqlTMG-RM Fact Sentence Tweaks #tmg #facttypes #roles #events #sharedevent
To-Do.sqlBundled Utilities - Groupings #application
To-Do.sqlBundled Utilities - RMtrix #application #visualc
To-Do.sqlList of Pages imported from Wikispaces Site
To-Do.sqlDatabase Properties List - Query #databaseproperties
To-Do.sqlDelete Many #delete
To-Do.sqlMS Access Engine - EXCEL Pivot Tables #msaccess #msexcel #pivottable #events
To-Do.sqlMS Access Engine - Event Query #msaccess #marriage #sharedevent
To-Do.sqlMS Access Engine - The BLOB Fields #msaccess #blobfields #conversion
To-Do.sqlMS Access Engine - Using EXCEL #msaccess #msexcel #charts #filters
To-Do.sqlMS Access Engine #msaccess #msexcel #crystalreports #odbc
To-Do.sqlQuery Menu
To-Do.sqlRM4 To Do List #todolist #tasks #date
To-Do.sqlRM5 Table Summaries #datadefinitions
To-Do.sqlSQLite Queries #sqlitemanagers #sql
To-Do.sqlTo-Do List - filter by locale
To-Do.sqlhome - as exported
To-Do4Persons.sqlBundled Utilities - Groupings #application
To-Do4Persons.sqlQuery Menu
To-Do4Persons.sqlSQLite Queries #sqlitemanagers #sql
TraceHeadlessWitnesses.sqlBundled Utilities - Groupings #application
TraceHeadlessWitnesses.sqlQuery Menu
TraceHeadlessWitnesses.sqlSQLite Queries #sqlitemanagers #sql
TraceHeadlessWitnesses.sqlShared Events With Missing Witnesses #sharedevent
Tree-HourglassMembers.sqlQuery - All Names in Tree
TreeShare-DisconnectButNotCitations-1.sql
TreeShare-DisconnectButNotCitations.sqlAncestry TreeShare - Impact #ancestrycom #TreeShare
TreeShare-LinkPastedAncestrySources.sqlTreeShare - Link Pasted Ancestry Sources #ancestrycom #TreeShare #citations #sources
TreeShare-MediaRenameStep1.sqlTreeShare - Rename Cryptic Filenames for Citation Media #TreeShare #media #citations #batch
TreeShare-MediaRenameStep2.sqlTreeShare - Rename Cryptic Filenames for Citation Media #TreeShare #media #citations #batch
TreeShare-MediaRenameUNDO.sqlTreeShare - Rename Cryptic Filenames for Citation Media #TreeShare #media #citations #batch
UpdateBirthDeathYears.sqlQuery Menu
UpdateBirthDeathYears.sqlRebuild Indexes and Update Birth and Death Years #update #date #birth #death #index #speed #rmnocase
UpdateBirthDeathYears.sqlSQLite Queries #sqlitemanagers #sql
WebTags_to_Notes.sqlQuery Menu
WebTags_to_Notes.sqlWebTags - convert to Notes et al #webtags #gedcom
WebTags-Consolidate.sql
WebTags-DeleteDuplicates.sqlEarlier Queries by Date
WebTags-DeleteDuplicates.sqlQuery Menu
WebTags-DeleteDuplicates.sqlSQLite Queries #sqlitemanagers #sql
WebTags-DeleteDuplicates.sqlWebTags - Consolidate #webtags #delete #citations
WebTags-MakeFromAncestryComments.sqlQuery Menu
WebTags-MakeFromAncestryComments.sqlSQLite Queries #sqlitemanagers #sql
WebTags-MakeFromAncestryComments.sqlWebTags - from Ancestry.com and FTM #ancestrycom #webtags
WitnessOrderByRelationshipName.sql