SSIS, trouble making fuzzy comparison

moondaddy 911 Reputation points
2020-12-18T06:56:26.18+00:00

Using SQL Server 2019 I have 2 lists of companies and I need to determine which companies exists in both lists.

aaFuzzy_BBB are companies already in the database.

aaFuzzy_YP is a table of new companies I would like to import into aaFuzzy_BBB, but first I want to know which ones are already exist (or might exist) in aaFuzzy_BBB.

So what I really want is a list of possible matches so I can figure out which ones to import, however, when I run the SSIS package it combines everything into a destination table.

I created scripts to create the 3 tables and load data into them, renamed the files using a txt file extension, but was not able to attach them. all are less than 1 mb in size. I will try to attach those scripts and the package file later.

Can someone kindly take a look at these and give me some advice?

Thank you.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,449 questions
{count} votes

7 answers

Sort by: Most helpful
  1. moondaddy 911 Reputation points
    2020-12-18T07:01:01.933+00:00

    Hmm. must be a bug here. I tried a different browser and still can't upload this file and its only 106k in size.
    49343-image.png

    0 comments No comments

  2. moondaddy 911 Reputation points
    2020-12-18T19:20:22.98+00:00

    OK, since I can't upload script files, here are the scrips which I will submit if 4 posts:

    To create the 3 tables:

    USE [FuzzyComparison]  --my db name  
    GO  
      
    BEGIN TRAN  
    GO  
      
    SET ANSI_NULLS ON  
    SET QUOTED_IDENTIFIER ON  
      
    GO  
      
    IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END  
    GO  
    -- Create table [dbo].[aaFuzzy_BBB]  
    Print 'Create table [dbo].[aaFuzzy_BBB]'  
    GO  
    CREATE TABLE [dbo].[aaFuzzy_BBB] (  
    		[Excel_Id]         [int] NULL,  
    		[Page_URL]         [varchar](400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,  
    		[BusinessName]     [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,  
    		[ZipCode]          [int] NULL  
    ) ON [PRIMARY]  
    GO  
      
    IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END  
    GO  
    ALTER TABLE [dbo].[aaFuzzy_BBB] SET (LOCK_ESCALATION = TABLE)  
    GO  
      
    IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END  
    GO  
    SET ANSI_NULLS ON  
    SET QUOTED_IDENTIFIER ON  
      
    GO  
      
    IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END  
    GO  
    -- Create table [dbo].[aaFuzzy_Destination]  
    Print 'Create table [dbo].[aaFuzzy_Destination]'  
    GO  
    CREATE TABLE [dbo].[aaFuzzy_Destination] (  
    		[Excel_Id]         [int] NULL,  
    		[Page_URL]         [varchar](400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,  
    		[Company_Name]     [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,  
    		[ZipCode]          [int] NULL  
    ) ON [PRIMARY]  
    GO  
      
    IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END  
    GO  
    ALTER TABLE [dbo].[aaFuzzy_Destination] SET (LOCK_ESCALATION = TABLE)  
    GO  
      
    IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END  
    GO  
    SET ANSI_NULLS ON  
    SET QUOTED_IDENTIFIER ON  
      
    GO  
      
    IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END  
    GO  
    -- Create table [dbo].[aaFuzzy_YP]  
    Print 'Create table [dbo].[aaFuzzy_YP]'  
    GO  
    CREATE TABLE [dbo].[aaFuzzy_YP] (  
    		[Excel_Id]         [int] NULL,  
    		[Page_URL]         [varchar](400) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,  
    		[Company_Name]     [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,  
    		[ZipCode]          [int] NULL  
    ) ON [PRIMARY]  
    GO  
      
    IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END  
    GO  
    ALTER TABLE [dbo].[aaFuzzy_YP] SET (LOCK_ESCALATION = TABLE)  
    GO  
      
    IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END  
    GO  
      
    IF @@TRANCOUNT>0  
    	COMMIT  
      
    SET NOEXEC OFF  
    GO  
    
    
      
      
    
    0 comments No comments

  3. moondaddy 911 Reputation points
    2020-12-18T19:22:12.093+00:00

    the package:

    <?xml version="1.0"?>
    <DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"
    DTS:refId="Package"
    DTS:CreationDate="12/17/2020 10:15:21 PM"
    DTS:CreationName="Microsoft.Package"
    DTS:CreatorComputerName="VOYAGER3"
    DTS:CreatorName="VOYAGER3\gpadv"
    DTS:DTSID="{02E2CA30-A651-4592-B977-C6C7957EDEBC}"
    DTS:ExecutableType="Microsoft.Package"
    DTS:LastModifiedProductVersion="15.0.2000.132"
    DTS:LocaleID="1033"
    DTS:ObjectName="Package1"
    DTS:PackageType="5"
    DTS:VersionBuild="8"
    DTS:VersionGUID="{C47B180E-A446-455A-BD74-366F56DAFE42}">
    <DTS:Property
    DTS:Name="PackageFormatVersion">8</DTS:Property>
    <DTS:ConnectionManagers>
    <DTS:ConnectionManager
    DTS:refId="Package.ConnectionManagers[VOYAGER3\MSSQL19.Shipping]"
    DTS:CreationName="OLEDB"
    DTS:DTSID="{7D9FAE82-9FB3-4310-9934-D460673DD491}"
    DTS:ObjectName="VOYAGER3\MSSQL19.Shipping">
    <DTS:ObjectData>
    <DTS:ConnectionManager
    DTS:ConnectionString="Data Source=VOYAGER3\MSSQL19;Initial Catalog=Shipping;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;" />
    </DTS:ObjectData>
    </DTS:ConnectionManager>
    </DTS:ConnectionManagers>
    <DTS:Variables />
    <DTS:Executables>
    <DTS:Executable
    DTS:refId="Package\Fuzzy Lookup Transformation in SSIS"
    DTS:CreationName="Microsoft.Pipeline"
    DTS:Description="Data Flow Task"
    DTS:DTSID="{8ABD254C-FFA7-432D-A433-827B053E8BD4}"
    DTS:ExecutableType="Microsoft.Pipeline"
    DTS:LocaleID="-1"
    DTS:ObjectName="Fuzzy Lookup Transformation in SSIS"
    DTS:TaskContact="Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1">
    <DTS:Variables />
    <DTS:ObjectData>
    <pipeline
    version="1">
    <components>
    <component
    refId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup"
    componentClassID="Microsoft.FuzzyLookup"
    contactInfo="Fuzzy Lookup;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;5"
    description="Performs data cleaning tasks such as standardizing data, correcting data, and providing missing values. Uses fuzzy matching to return one or more close matches from a reference table. For example, lookup customer data by address, even if your input address data does not exactly match your reference address data."
    name="Fuzzy Lookup"
    version="5">
    <properties>
    <property
    dataType="System.Int32"
    description="Indicates whether to reuse an existing fuzzy-match index table or build a new one. The new index table can be temporary, persisted, or persisted and maintained."
    name="MatchIndexOptions"
    typeConverter="tcMatchIndexOptions">1</property>
    <property
    dataType="System.Null"
    description="Specifies the maximum amount of memory (MB) that this instance of the Fuzzy Lookup transformation can use. If 0 is given, then the transform will dynamically adjust it's memory usage based upon it's requirements and available system memory."
    expressionType="Notify"
    name="MaxMemoryUsage" />
    <property
    dataType="System.Null"
    description="Specifies the name of the fuzzy-match index table to be reused or the table name in which a newly generated fuzzy-match index table will be written."
    name="MatchIndexName"
    state="escaped" />
    <property
    dataType="System.String"
    description="Specifies the name of the reference table or view against which to match incoming records."
    name="ReferenceTableName"
    state="escaped">_x005B_dbo_x005D_._x005B_aaFuzzy_YP_x005D_</property>
    <property
    dataType="System.Int32"
    description="Indicates whether to drop an existing fuzzy-match index table if transformation is configured to generate a new table and a table with the same name already exists."
    name="DropExistingMatchIndex">1</property>
    <property
    dataType="System.Int32"
    description="Whether a copy of the reference table should be made for fuzzy match index construction and subsequent matching. It is strongly recommended that a copy always be made, otherwise unpredictable output may result if the contents of the reference table change during package execution (or between executions if reusing a fuzzy match index). If this property is set to false, the reference table must additionally have a clustered index built upon an integer identity column."
    name="CopyReferenceTable">1</property>
    <property
    dataType="System.String"
    description="Specifies the maximum number of fuzzy matches to return for an input record."
    name="MaxOutputMatchesPerInput">20</property>
    <property
    dataType="System.Single"
    description="Specifies the minimum similarity score required for the match results that the transformation returns."
    name="MinSimilarity">0.2</property>
    <property
    dataType="System.String"
    description="Specifies the set of white-space and punctuation characters used to separate fuzzy match fields into the words used for matching and scoring a fuzzy lookup."
    name="Delimiters"
    state="escaped">_x0020__x0009__x000D__x000A__x002C_.x003B:-_x0022__x0027__x0026__x002F__x005C__x0040__x0021__x003F__x0028__x0029__x003C__x003E__x005B__x005D__x007B__x007D__x007C__x0023__x002A__x005E__x0025_</property>
    <property
    dataType="System.String"
    description="Specifies the metadata of the reference table in XML format."
    name="ReferenceMetadataXml"
    state="escaped">_x003C_referenceMetadata_x003E__x003C_referenceColumns_x003E__x003C_referenceColumn_x0020_name_x003D__x0022_Excel_Id_x0022__x0020_dataType_x003D__x0022_DT_I4_x0022__x0020_length_x003D__x0022_0_x0022__x0020_precision_x003D__x0022_0_x0022__x0020_scale_x003D__x0022_0_x0022__x0020_codePage_x003D__x0022_0_x0022__x002F__x003E__x003C_referenceColumn_x0020_name_x003D__x0022_Page_URL_x0022__x0020_dataType_x003D__x0022_DT_STR_x0022__x0020_length_x003D__x0022_400_x0022__x0020_precision_x003D__x0022_0_x0022__x0020_scale_x003D__x0022_0_x0022__x0020_codePage_x003D__x0022_1252_x0022__x002F__x003E__x003C_referenceColumn_x0020_name_x003D__x0022_Company_Name_x0022__x0020_dataType_x003D__x0022_DT_STR_x0022__x0020_length_x003D__x0022_100_x0022__x0020_precision_x003D__x0022_0_x0022__x0020_scale_x003D__x0022_0_x0022__x0020_codePage_x003D__x0022_1252_x0022__x002F__x003E__x003C_referenceColumn_x0020_name_x003D__x0022_ZipCode_x0022__x0020_dataType_x003D__x0022_DT_I4_x0022__x0020_length_x003D__x0022_0_x0022__x0020_precision_x003D__x0022_0_x0022__x0020_scale_x003D__x0022_0_x0022__x0020_codePage_x003D__x0022_0_x0022__x002F__x003E__x003C__x002F_referenceColumns_x003E__x003C__x002F_referenceMetadata_x003E__x000D__x000A_</property>
    <property
    dataType="System.Boolean"
    description="If true, each input record will be directly compared against EVERY record in the reference table. This may produce slightly better results, but will be extremely slow unless the number of records in the reference table is very small. Note that the entire reference table will be loaded into main memory if this option is enabled. This option is primarily intended for debugging purposes and should be used with care."
    name="Exhaustive">false</property>
    <property
    dataType="System.Boolean"
    description="If true, Fuzzy Lookup will partially load the error-tolerant index and the reference table into main memory before execution begins. This can greatly enhance performance if many input rows are to be processed."
    name="WarmCaches">true</property>
    </properties>
    <connections>
    <connection
    refId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Connections[OleDbConnection]"
    connectionManagerID="{CEB65BFB-1A9C-477E-BB7F-B262A6C66A91}:external"
    connectionManagerRefId="Project.ConnectionManagers[voyager3_mssql19.FuzzyComparison]"
    description="Microsoft SQL Server connection and database in which the fuzzy lookup reference table is located and where the fuzzy match index table will be stored and accessed."
    name="OleDbConnection" />
    </connections>
    <inputs>
    <input
    refId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Inputs[Fuzzy Lookup Input]"
    name="Fuzzy Lookup Input">
    <inputColumns>
    <inputColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Inputs[Fuzzy Lookup Input].Columns[Excel_Id]"
    cachedDataType="r8"
    cachedName="Excel_Id"
    lineageId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Source.Outputs[OLE DB Source Output].Columns[Excel_Id]">
    <properties>
    <property
    dataType="System.Null"
    description="Name of the reference table column with which the input column should be matched."
    name="JoinToReferenceColumn"
    state="escaped" />
    <property
    dataType="System.Int32"
    description="Specifies whether the match is a fuzzy or an exact match."
    name="JoinType"
    typeConverter="tcJoinType">2</property>
    <property
    dataType="System.Single"
    description="Specifies the minimum textual similarity required between input and fuzzy matched records on values in this particular join column. Must be a floating point value between 0.0 and 1.0."
    name="MinSimilarity">0</property>
    <property
    dataType="System.UInt32"
    description="Specifies the comparison options for character data. The options are those supported by the FoldString function."
    name="FuzzyComparisonFlags"
    typeConverter="tcComparisonFlags">1</property>
    <property
    dataType="System.UInt32"
    description="Flags to FoldString that should be used when comparing whether two strings are equivalent."
    name="FuzzyComparisonFlagsEx"
    typeConverter="tcComparisonFlagsEx">0</property>
    </properties>
    </inputColumn>
    <inputColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Inputs[Fuzzy Lookup Input].Columns[BusinessName]"
    cachedCodepage="1252"
    cachedDataType="str"
    cachedLength="100"
    cachedName="BusinessName"
    lineageId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Source.Outputs[OLE DB Source Output].Columns[BusinessName]">
    <properties>
    <property
    dataType="System.String"
    description="Name of the reference table column with which the input column should be matched."
    name="JoinToReferenceColumn"
    state="escaped">Company_Name</property>
    <property
    dataType="System.Int32"
    description="Specifies whether the match is a fuzzy or an exact match."
    name="JoinType"
    typeConverter="tcJoinType">2</property>
    <property
    dataType="System.Single"
    description="Specifies the minimum textual similarity required between input and fuzzy matched records on values in this particular join column. Must be a floating point value between 0.0 and 1.0."
    name="MinSimilarity">0</property>
    <property
    dataType="System.Int32"
    description="Specifies the comparison options for character data. The options are those supported by the FoldString function."
    name="FuzzyComparisonFlags"
    typeConverter="tcComparisonFlags">1</property>
    <property
    dataType="System.UInt32"
    description="Flags to FoldString that should be used when comparing whether two strings are equivalent."
    name="FuzzyComparisonFlagsEx"
    typeConverter="tcComparisonFlagsEx">0</property>
    </properties>
    </inputColumn>
    <inputColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Inputs[Fuzzy Lookup Input].Columns[ZipCode]"
    cachedDataType="i4"
    cachedName="ZipCode"
    lineageId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Source.Outputs[OLE DB Source Output].Columns[ZipCode]">
    <properties>
    <property
    dataType="System.String"
    description="Name of the reference table column with which the input column should be matched."
    name="JoinToReferenceColumn"
    state="escaped">ZipCode</property>
    <property
    dataType="System.Int32"
    description="Specifies whether the match is a fuzzy or an exact match."
    name="JoinType"
    typeConverter="tcJoinType">1</property>
    <property
    dataType="System.Single"
    description="Specifies the minimum textual similarity required between input and fuzzy matched records on values in this particular join column. Must be a floating point value between 0.0 and 1.0."
    name="MinSimilarity">1</property>
    <property
    dataType="System.Int32"
    description="Specifies the comparison options for character data. The options are those supported by the FoldString function."
    name="FuzzyComparisonFlags"
    typeConverter="tcComparisonFlags">1</property>
    <property
    dataType="System.UInt32"
    description="Flags to FoldString that should be used when comparing whether two strings are equivalent."
    name="FuzzyComparisonFlagsEx"
    typeConverter="tcComparisonFlagsEx">0</property>
    </properties>
    </inputColumn>
    </inputColumns>
    <externalMetadataColumns />
    </input>
    </inputs>
    <outputs>
    <output
    refId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Outputs[Fuzzy Lookup Output]"
    name="Fuzzy Lookup Output">
    <outputColumns>
    <outputColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Outputs[Fuzzy Lookup Output].Columns[Excel_Id]"
    dataType="r8"
    lineageId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Outputs[Fuzzy Lookup Output].Columns[Excel_Id]"
    name="Excel_Id">
    <properties>
    <property
    dataType="System.Null"
    description="Specifies the reference table column that is copied to the output for each match result."
    name="CopyFromReferenceColumn"
    state="escaped" />
    <property
    containsID="true"
    dataType="System.Int32"
    description="Specifies the lineage identifier of the input column from which to copy to this output column for each match."
    name="SourceInputColumnLineageID">#{Package\Fuzzy Lookup Transformation in SSIS\OLE DB Source.Outputs[OLE DB Source Output].Columns[Excel_Id]}</property>
    <property
    dataType="System.Int32"
    description="Specifies whether the column is used to indicate confidence or similarity."
    name="ColumnType"
    typeConverter="tcColumnType">0</property>
    </properties>
    </outputColumn>
    <outputColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Outputs[Fuzzy Lookup Output].Columns[BusinessName]"
    codePage="1252"
    dataType="str"
    length="100"
    lineageId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Outputs[Fuzzy Lookup Output].Columns[BusinessName]"
    name="BusinessName">
    <properties>
    <property
    dataType="System.Null"
    description="Specifies the reference table column that is copied to the output for each match result."
    name="CopyFromReferenceColumn"
    state="escaped" />
    <property
    containsID="true"
    dataType="System.Int32"
    description="Specifies the lineage identifier of the input column from which to copy to this output column for each match."
    name="SourceInputColumnLineageID">#{Package\Fuzzy Lookup Transformation in SSIS\OLE DB Source.Outputs[OLE DB Source Output].Columns[BusinessName]}</property>
    <property
    dataType="System.Int32"
    description="Specifies whether the column is used to indicate confidence or similarity."
    name="ColumnType"
    typeConverter="tcColumnType">0</property>
    </properties>
    </outputColumn>
    <outputColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Outputs[Fuzzy Lookup Output].Columns[ZipCode]"
    dataType="i4"
    lineageId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Outputs[Fuzzy Lookup Output].Columns[ZipCode]"
    name="ZipCode">
    <properties>
    <property
    dataType="System.Null"
    description="Specifies the reference table column that is copied to the output for each match result."
    name="CopyFromReferenceColumn"
    state="escaped" />
    <property
    containsID="true"
    dataType="System.Int32"
    description="Specifies the lineage identifier of the input column from which to copy to this output column for each match."
    name="SourceInputColumnLineageID">#{Package\Fuzzy Lookup Transformation in SSIS\OLE DB Source.Outputs[OLE DB Source Output].Columns[ZipCode]}</property>
    <property
    dataType="System.Int32"
    description="Specifies whether the column is used to indicate confidence or similarity."
    name="ColumnType"
    typeConverter="tcColumnType">0</property>
    </properties>
    </outputColumn>
    <outputColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Outputs[Fuzzy Lookup Output].Columns[Excel_Id_output]"
    dataType="i4"
    lineageId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Outputs[Fuzzy Lookup Output].Columns[Excel_Id_output]"
    name="Excel_Id_output">
    <properties>
    <property
    dataType="System.String"
    description="Specifies the reference table column that is copied to the output for each match result."
    name="CopyFromReferenceColumn"
    state="escaped">Excel_Id</property>
    <property
    containsID="true"
    dataType="System.Null"
    description="Specifies the lineage identifier of the input column from which to copy to this output column for each match."
    name="SourceInputColumnLineageID" />
    <property
    dataType="System.Int32"
    description="Specifies whether the column is used to indicate confidence or similarity."
    name="ColumnType"
    typeConverter="tcColumnType">0</property>
    </properties>
    </outputColumn>
    <outputColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Outputs[Fuzzy Lookup Output].Columns[Company_Name_output]"
    codePage="1252"
    dataType="str"
    length="100"
    lineageId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Outputs[Fuzzy Lookup Output].Columns[Company_Name_output]"
    name="Company_Name_output">
    <properties>
    <property
    dataType="System.String"
    description="Specifies the reference table column that is copied to the output for each match result."
    name="CopyFromReferenceColumn"
    state="escaped">Company_Name</property>
    <property
    containsID="true"
    dataType="System.Null"
    description="Specifies the lineage identifier of the input column from which to copy to this output column for each match."
    name="SourceInputColumnLineageID" />
    <property
    dataType="System.Int32"
    description="Specifies whether the column is used to indicate confidence or similarity."
    name="ColumnType"
    typeConverter="tcColumnType">0</property>
    </properties>
    </outputColumn>
    <outputColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Outputs[Fuzzy Lookup Output].Columns[_Similarity]"
    dataType="r4"
    lineageId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Outputs[Fuzzy Lookup Output].Columns[_Similarity]"
    name="_Similarity">
    <properties>
    <property
    dataType="System.Int32"
    description="Specifies whether the column is used to indicate confidence or similarity."
    name="ColumnType"
    typeConverter="tcColumnType">1</property>
    </properties>
    </outputColumn>
    <outputColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Outputs[Fuzzy Lookup Output].Columns[_Confidence]"
    dataType="r4"
    lineageId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Outputs[Fuzzy Lookup Output].Columns[_Confidence]"
    name="_Confidence">
    <properties>
    <property
    dataType="System.Int32"
    description="Specifies whether the column is used to indicate confidence or similarity."
    name="ColumnType"
    typeConverter="tcColumnType">2</property>
    </properties>
    </outputColumn>
    <outputColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Outputs[Fuzzy Lookup Output].Columns[_Similarity_BusinessName]"
    dataType="r4"
    description="Column-level similarity score for fuzzy join on column "BusinessName"."
    lineageId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Outputs[Fuzzy Lookup Output].Columns[_Similarity_BusinessName]"
    name="_Similarity_BusinessName">
    <properties>
    <property
    dataType="System.Null"
    description="Specifies the reference table column that is copied to the output for each match result."
    name="CopyFromReferenceColumn"
    state="escaped" />
    <property
    containsID="true"
    dataType="System.Int32"
    description="Specifies the lineage identifier of the input column from which to copy to this output column for each match."
    name="SourceInputColumnLineageID">#{Package\Fuzzy Lookup Transformation in SSIS\OLE DB Source.Outputs[OLE DB Source Output].Columns[BusinessName]}</property>
    <property
    dataType="System.Int32"
    description="Specifies whether the column is used to indicate confidence or similarity."
    name="ColumnType"
    typeConverter="tcColumnType">3</property>
    </properties>
    </outputColumn>
    </outputColumns>
    <externalMetadataColumns />
    </output>
    </outputs>
    </component>
    <component
    refId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Destination"
    componentClassID="Microsoft.OLEDBDestination"
    contactInfo="OLE DB Destination;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;4"
    description="OLE DB Destination"
    name="OLE DB Destination"
    usesDispositions="true"
    version="4">
    <properties>
    <property
    dataType="System.Int32"
    description="The number of seconds before a command times out. A value of 0 indicates an infinite time-out."
    name="CommandTimeout">0</property>
    <property
    dataType="System.String"
    description="Specifies the name of the database object used to open a rowset."
    name="OpenRowset">[dbo].[aaFuzzy_Destination]</property>
    <property
    dataType="System.String"
    description="Specifies the variable that contains the name of the database object used to open a rowset."
    name="OpenRowsetVariable"></property>
    <property
    dataType="System.String"
    description="The SQL command to be executed."
    name="SqlCommand"
    UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor"></property>
    <property
    dataType="System.Int32"
    description="Specifies the column code page to use when code page information is unavailable from the data source."
    name="DefaultCodePage">1252</property>
    <property
    dataType="System.Boolean"
    description="Forces the use of the DefaultCodePage property value when describing character data."
    name="AlwaysUseDefaultCodePage">false</property>
    <property
    dataType="System.Int32"
    description="Specifies the mode used to access the database."
    name="AccessMode"
    typeConverter="AccessMode">3</property>
    <property
    dataType="System.Boolean"
    description="Indicates whether the values supplied for identity columns will be copied to the destination. If false, values for identity columns will be auto-generated at the destination. Applies only if fast load is turned on."
    name="FastLoadKeepIdentity">false</property>
    <property
    dataType="System.Boolean"
    description="Indicates whether the columns containing null will have null inserted in the destination. If false, columns containing null will have their default values inserted at the destination. Applies only if fast load is turned on."
    name="FastLoadKeepNulls">false</property>
    <property
    dataType="System.String"
    description="Specifies options to be used with fast load. Applies only if fast load is turned on."
    name="FastLoadOptions">TABLOCK,CHECK_CONSTRAINTS</property>
    <property
    dataType="System.Int32"
    description="Specifies when commits are issued during data insertion. A value of 0 specifies that one commit will be issued at the end of data insertion. Applies only if fast load is turned on."
    name="FastLoadMaxInsertCommitSize">2147483647</property>
    </properties>
    <connections>
    <connection
    refId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Destination.Connections[OleDbConnection]"
    connectionManagerID="{CEB65BFB-1A9C-477E-BB7F-B262A6C66A91}:external"
    connectionManagerRefId="Project.ConnectionManagers[voyager3_mssql19.FuzzyComparison]"
    description="The OLE DB runtime connection used to access the database."
    name="OleDbConnection" />
    </connections>
    <inputs>
    <input
    refId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Destination.Inputs[OLE DB Destination Input]"
    errorOrTruncationOperation="Insert"
    errorRowDisposition="FailComponent"
    hasSideEffects="true"
    name="OLE DB Destination Input">
    <inputColumns>
    <inputColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[ZipCode]"
    cachedDataType="i4"
    cachedName="ZipCode"
    externalMetadataColumnId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ZipCode]"
    lineageId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Outputs[Fuzzy Lookup Output].Columns[ZipCode]" />
    <inputColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Destination.Inputs[OLE DB Destination Input].Columns[BusinessName]"
    cachedCodepage="1252"
    cachedDataType="str"
    cachedLength="100"
    cachedName="BusinessName"
    externalMetadataColumnId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[Company_Name]"
    lineageId="Package\Fuzzy Lookup Transformation in SSIS\Fuzzy Lookup.Outputs[Fuzzy Lookup Output].Columns[BusinessName]" />
    </inputColumns>
    <externalMetadataColumns
    isUsed="True">
    <externalMetadataColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[Excel_Id]"
    dataType="i4"
    name="Excel_Id" />
    <externalMetadataColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[Page_URL]"
    codePage="1252"
    dataType="str"
    length="400"
    name="Page_URL" />
    <externalMetadataColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[Company_Name]"
    codePage="1252"
    dataType="str"
    length="100"
    name="Company_Name" />
    <externalMetadataColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Destination.Inputs[OLE DB Destination Input].ExternalColumns[ZipCode]"
    dataType="i4"
    name="ZipCode" />
    </externalMetadataColumns>
    </input>
    </inputs>
    <outputs>
    <output
    refId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Destination.Outputs[OLE DB Destination Error Output]"
    exclusionGroup="1"
    isErrorOut="true"
    name="OLE DB Destination Error Output"
    synchronousInputId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Destination.Inputs[OLE DB Destination Input]">
    <outputColumns>
    <outputColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorCode]"
    dataType="i4"
    lineageId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorCode]"
    name="ErrorCode"
    specialFlags="1" />
    <outputColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorColumn]"
    dataType="i4"
    lineageId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Destination.Outputs[OLE DB Destination Error Output].Columns[ErrorColumn]"
    name="ErrorColumn"
    specialFlags="2" />
    </outputColumns>
    <externalMetadataColumns />
    </output>
    </outputs>
    </component>
    <component
    refId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Source"
    componentClassID="Microsoft.OLEDBSource"
    contactInfo="OLE DB Source;Microsoft Corporation; Microsoft SQL Server; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;7"
    description="OLE DB Source"
    name="OLE DB Source"
    usesDispositions="true"
    version="7">
    <properties>
    <property
    dataType="System.Int32"
    description="The number of seconds before a command times out. A value of 0 indicates an infinite time-out."
    name="CommandTimeout">0</property>
    <property
    dataType="System.String"
    description="Specifies the name of the database object used to open a rowset."
    name="OpenRowset">[dbo].[aaFuzzy_BBB]</property>
    <property
    dataType="System.String"
    description="Specifies the variable that contains the name of the database object used to open a rowset."
    name="OpenRowsetVariable"></property>
    <property
    dataType="System.String"
    description="The SQL command to be executed."
    name="SqlCommand"
    UITypeEditor="Microsoft.DataTransformationServices.Controls.ModalMultilineStringEditor"></property>
    <property
    dataType="System.String"
    description="The variable that contains the SQL command to be executed."
    name="SqlCommandVariable"></property>
    <property
    dataType="System.Int32"
    description="Specifies the column code page to use when code page information is unavailable from the data source."
    name="DefaultCodePage">1252</property>
    <property
    dataType="System.Boolean"
    description="Forces the use of the DefaultCodePage property value when describing character data."
    name="AlwaysUseDefaultCodePage">false</property>
    <property
    dataType="System.Int32"
    description="Specifies the mode used to access the database."
    name="AccessMode"
    typeConverter="AccessMode">0</property>
    <property
    dataType="System.String"
    description="The mappings between the parameters in the SQL command and variables."
    name="ParameterMapping"></property>
    </properties>
    <connections>
    <connection
    refId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Source.Connections[OleDbConnection]"
    connectionManagerID="{CEB65BFB-1A9C-477E-BB7F-B262A6C66A91}:external"
    connectionManagerRefId="Project.ConnectionManagers[voyager3_mssql19.FuzzyComparison]"
    description="The OLE DB runtime connection used to access the database."
    name="OleDbConnection" />
    </connections>
    <outputs>
    <output
    refId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Source.Outputs[OLE DB Source Output]"
    name="OLE DB Source Output">
    <outputColumns>
    <outputColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Source.Outputs[OLE DB Source Output].Columns[Excel_Id]"
    dataType="r8"
    errorOrTruncationOperation="Conversion"
    errorRowDisposition="FailComponent"
    externalMetadataColumnId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[Excel_Id]"
    lineageId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Source.Outputs[OLE DB Source Output].Columns[Excel_Id]"
    name="Excel_Id"
    truncationRowDisposition="FailComponent" />
    <outputColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Source.Outputs[OLE DB Source Output].Columns[BusinessName]"
    codePage="1252"
    dataType="str"
    errorOrTruncationOperation="Conversion"
    errorRowDisposition="FailComponent"
    externalMetadataColumnId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[BusinessName]"
    length="100"
    lineageId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Source.Outputs[OLE DB Source Output].Columns[BusinessName]"
    name="BusinessName"
    truncationRowDisposition="FailComponent" />
    <outputColumn
    refId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Source.Outputs[OLE DB Source Output].Columns[ZipCode]"
    dataType="i4"
    errorOrTruncationOperation="Conversion"
    errorRowDisposition="FailComponent"
    externalMetadataColumnId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[ZipCode]"
    lineageId="Package\Fuzzy Lookup Transformation in SSIS\OLE DB Source.Out

    0 comments No comments

  4. moondaddy 911 Reputation points
    2020-12-18T19:29:17.98+00:00

    insert script for the table (aaFuzzy_BBB) in the database representing per-exiting data (the other table will be data I would like to import to aaFuzzy_BBB, but for now "only" want to identify which rows "might" be duplicates).

    SET NOEXEC OFF  
    SET ANSI_WARNINGS ON  
    SET XACT_ABORT ON  
    SET IMPLICIT_TRANSACTIONS OFF  
    SET ARITHABORT ON  
    SET NOCOUNT ON  
    SET QUOTED_IDENTIFIER ON  
    SET NUMERIC_ROUNDABORT OFF  
    SET CONCAT_NULL_YIELDS_NULL ON  
    SET ANSI_NULLS ON  
    SET ANSI_PADDING ON  
    GO  
      
    USE [FuzzyComparison]  
    GO  
      
    BEGIN TRAN  
      
    -- =======================================================  
    -- Inserting 457 row(s) for table [dbo].[aaFuzzy_BBB]  
    -- =======================================================  
    Print 'Inserting 457 row(s) for table [dbo].[aaFuzzy_BBB]'  
      
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (5, 'https://www.bbb.org/us/nj/new-providence/profile/delivery-service/spirit-delivery-distribution-0221-22000741', 'Spirit Delivery & Distribution', 7974)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (55, 'https://www.bbb.org/us/nj/califon/profile/caterer/bex-eatery-catering-co-0221-90179577', 'BEX eatery & catering co.', 7830)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (404, 'https://www.bbb.org/us/nj/elizabeth/profile/air-cargo/cinco-estrellas-cargo-0221-90139594', 'Cinco Estrellas Cargo', 7201)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (426, 'https://www.bbb.org/us/nj/elizabeth/profile/air-cargo/the-ups-store-5866-0221-90169493', 'The UPS Store (#5866)', 7201)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (538, 'https://www.bbb.org/us/nj/elizabeth/profile/cargo-container/d2-logistics-inc-0221-90178731', 'D2 Logistics Inc.', 7206)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (554, 'https://www.bbb.org/us/nj/englishtown/profile/logistics/global-forwarding-enterprises-llc-0221-90083023', 'Global Forwarding Enterprises, LLC', 7726)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (900, 'https://www.bbb.org/us/nj/ramsey/profile/moving-and-storage-companies/a-fazio-moving-storage-inc-0221-90169514', 'A. Fazio Moving & Storage, Inc.', 7446)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (907, 'https://www.bbb.org/us/nj/linden/profile/containerized-freight-service/continental-transport-corp-0221-22001112', 'Continental Transport Corp', 7036)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (933, 'https://www.bbb.org/us/nj/warren/profile/trucking-transportation-brokers/costa-transports-inc-0221-27002593', 'Costa Transports, Inc.', 7059)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (943, 'https://www.bbb.org/us/nj/newark/profile/freight-forwarding/pacific-atlantic-lines-inc-1236-92005025', 'Pacific Atlantic Lines, Inc.', 7102)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (972, 'https://www.bbb.org/us/nj/wyckoff/profile/moving-services/premier-movers-llc-0221-90077880', 'Premier Movers LLC', 7481)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (1429, 'https://www.bbb.org/us/nj/franklin/profile/moving-and-storage-companies/tri-state-moving-and-storage-llc-0221-90162300', 'Tri-State Moving and Storage, LLC', 7416)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (1443, 'https://www.bbb.org/us/nj/sandyston/profile/moving-and-storage-companies/jim-mahons-moving-trucking-inc-0221-28002257', 'Jim Mahon''s Moving & Trucking, Inc.', 7826)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (1577, 'https://www.bbb.org/us/nj/closter/profile/moving-and-storage-companies/last-minute-relocation-0221-90164202', 'Last Minute Relocation', 7624)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (1843, 'https://www.bbb.org/us/nj/englewood/profile/freight-forwarding/magellan-shipping-inc-0221-90105596', 'Magellan Shipping, Inc.', 7631)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (1995, 'https://www.bbb.org/us/nj/hackettstown/profile/moving-and-storage-companies/fast-moving-company-0221-29005463', 'Fast Moving Company', 7840)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (2288, 'https://www.bbb.org/us/nj/red-bank/profile/containerized-freight-service/troy-container-line-ltd-0221-90169553', 'Troy Container Line LTD', 7701)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (2547, 'https://www.bbb.org/us/nj/montclair/profile/air-cargo/the-ups-store-0221-24002678', 'The UPS Store', 7042)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (2720, 'https://www.bbb.org/us/nj/belleville/profile/air-cargo/umac-express-cargo-0221-90086971', 'UMAC Express Cargo', 7109)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (2749, 'https://www.bbb.org/us/nj/jersey-city/profile/air-cargo/makati-express-cargo-0221-90170380', 'Makati Express Cargo', 7306)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (2810, 'https://www.bbb.org/us/nj/teaneck/profile/air-cargo/the-ups-store-0221-90180901', 'The UPS Store', 7666)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (3204, 'https://www.bbb.org/us/nj/kearny/profile/transportation/zil-express-0221-90164885', 'Zil Express', 7032)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (3216, 'https://www.bbb.org/us/nj/maplewood/profile/moving-companies/general-moving-carriers-llc-0221-27000568', 'General Moving Carriers, LLC', 7040)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (3217, 'https://www.bbb.org/us/nj/franklin/profile/transportation/erie-trucking-company-0221-27004160', 'Erie Trucking Company', 7416)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (3228, 'https://www.bbb.org/us/nj/chester/profile/delivery-service/ups-store-5497-0221-90064377', 'UPS Store 5497', 7930)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (3274, 'https://www.bbb.org/us/nj/dover/profile/delivery-service/lms-latino-envios-0221-90087946', 'LMS Latino Envios', 7801)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (3284, 'https://www.bbb.org/us/nj/parsippany/profile/couriers/econo-courier-0221-90153081', 'Econo Courier', 7054)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (3295, 'https://www.bbb.org/ca/on/east-york/profile/transportation/international-shipping-lines-inc-0107-1132668', 'International Shipping Lines Inc', NULL)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (3321, 'https://www.bbb.org/us/nj/morris-plains/profile/delivery-service/genco-services-llc-0221-90152936', 'Genco Services LLC', 7950)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (3424, 'https://www.bbb.org/us/nj/maplewood/profile/moving-companies/harrington-moving-storage-inc-0221-24003512', 'Harrington Moving & Storage, Inc.', 7040)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (3634, 'https://www.bbb.org/us/nj/carlstadt/profile/freight-traffic-service/yrc-freight-0221-90157383', 'YRC FREIGHT', 7072)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (3836, 'https://www.bbb.org/us/nj/oakland/profile/delivery-service/xogistix-0221-90030632', 'Xogistix', 7436)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (3852, 'https://www.bbb.org/us/nj/oakland/profile/delivery-service/xss-corporation-0221-90009629', 'XSS Corporation', 7436)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (3889, 'https://www.bbb.org/us/nj/montvale/profile/containerized-freight-service/wings-worldwide-llc-0221-27002115', 'Wings Worldwide, LLC', 7645)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (3922, 'https://www.bbb.org/us/nj/paterson/profile/international-movers/embarque-apollo-shipping-0221-90074995', 'Embarque Apollo Shipping', 7501)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (3949, 'https://www.bbb.org/us/nj/bernardsville/profile/fuel-oil/mj-neill-inc-0221-24004836', 'M.J. Neill, Inc.', 7924)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (4536, 'https://www.bbb.org/us/nj/secaucus/profile/logistics/yusen-air-sea-service-usa-inc-0885-59000915', 'Yusen Air & Sea Service (U.S.A.) Inc.', 7094)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (4938, 'https://www.bbb.org/us/nj/union/profile/moving-companies/ariel-moving-co-0221-27004293', 'Ariel Moving Co.', 7083)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (4979, 'https://www.bbb.org/us/nj/jersey-city/profile/moving-companies/alpha-moving-storage-0221-10001969', 'Alpha Moving & Storage', 7310)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (5019, 'https://www.bbb.org/us/nj/belleville/profile/crating-service/preferred-plastic-packaging-company-inc-0221-90151605', 'Preferred Plastic & Packaging Company, Inc', 7109)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (5090, 'https://www.bbb.org/us/nj/nutley/profile/moving-and-storage-companies/armstrong-van-lines-inc-0221-90153172', 'Armstrong Van Lines Inc.', 7110)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (5098, 'https://www.bbb.org/us/nj/ridgefield/profile/moving-companies/us-express-moving-systems-inc-0221-22001227', 'US Express Moving Systems, Inc.', 7657)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (5130, 'https://www.bbb.org/us/nj/hackensack/profile/moving-companies/relocation-express-0221-90180920', 'Relocation Express', 7601)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (5140, 'https://www.bbb.org/us/nj/lodi/profile/crating-service/abc-packing-services-inc-0221-90058327', 'ABC Packing Services, Inc.', 7410)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (5158, 'https://www.bbb.org/us/nj/ridgefield/profile/moving-services/enterprise-relocation-systems-inc-0221-29005070', 'Enterprise Relocation Systems, Inc.', 7657)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (5357, 'https://www.bbb.org/us/nj/englishtown/profile/moving-companies/active-movers-llc-0221-28000932', 'Active Movers, LLC', 7726)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (5367, 'https://www.bbb.org/us/nj/elizabeth/profile/motor-freight-trucking/port-warehousing-distribution-corp-0221-90054906', 'Port Warehousing & Distribution Corp.', 7201)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (5414, 'https://www.bbb.org/us/nj/long-branch/profile/moving-companies/nj-coast-transfer-co-0221-11000081', 'N.J. Coast Transfer, Co.', 7740)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (5442, 'https://www.bbb.org/us/nj/dover/profile/moving-and-storage-companies/peers-moving-company-inc-0221-17001364', 'Peers Moving Company, Inc.', 7801)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (5575, 'https://www.bbb.org/us/nj/east-hanover/profile/logistics/velox-0221-90154171', 'Velox', 7936)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (6346, 'https://www.bbb.org/us/nj/west-orange/profile/air-cargo/transit-express-0221-90175776', 'Transit Express', 7052)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (6760, 'https://www.bbb.org/us/nj/bergenfield/profile/delivery-service/united-cargo-forwarders-inc-0221-90059868', 'United Cargo Forwarders Inc.', 7621)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (6886, 'https://www.bbb.org/us/nj/carteret/profile/delivery-service/ukay-trucking-and-delivery-service-inc-0221-12000974', 'Ukay Trucking and Delivery Service, Inc.', 7008)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (6913, 'https://www.bbb.org/us/nj/linden/profile/delivery-service/elite-delivery-systems-llc-0221-90152924', 'Elite Delivery Systems LLC', 7036)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (6936, 'https://www.bbb.org/us/nj/park-ridge/profile/logistics/american-auto-logistics-0221-90166099', 'American Auto Logistics', 7656)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (6963, 'https://www.bbb.org/us/nj/ramsey/profile/logistics/transmodal-corporation-0221-90171793', 'Transmodal Corporation', 7446)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (6968, 'https://www.bbb.org/us/nj/roselle/profile/delivery-service/dnipro-llc-0221-90054222', 'Dnipro LLC', 7203)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (6977, 'https://www.bbb.org/us/nj/kenilworth/profile/organic-food/greater-living-foods-llc-0221-30000402', 'Greater Living Foods, LLC', 7033)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7111, 'https://www.bbb.org/us/nj/union/profile/delivery-service/ricca-transport-inc-0221-90034347', 'Ricca Transport, Inc.', 7083)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7238, 'https://www.bbb.org/us/nj/union/profile/delivery-service/competitive-courier-0221-90033976', 'Competitive Courier', 7083)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7250, 'https://www.bbb.org/us/nj/irvington/profile/delivery-service/continental-shipping-group-inc-0221-90025671', 'Continental Shipping Group Inc.', 7111)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7264, 'https://www.bbb.org/us/nj/warren/profile/delivery-service/poland-parcel-llc-0221-90074659', 'Poland Parcel, LLC', 7059)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7287, 'https://www.bbb.org/us/nj/south-orange/profile/delivery-service/the-ups-store-6091-0221-90091391', 'The UPS Store #6091', 7079)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7304, 'https://www.bbb.org/us/nj/passaic/profile/transportation-consultants/ecuatainer-corporation-0221-90173318', 'Ecuatainer Corporation', 7055)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7318, 'https://www.bbb.org/us/nj/jersey-city/profile/delivery-service/favexglobal-enterprises-0221-90155739', 'FavexGlobal Enterprises', 7305)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7349, 'https://www.bbb.org/us/nj/kearny/profile/delivery-service/roadway-express-inc-0221-90018522', 'Roadway Express, Inc.', 7032)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7353, 'https://www.bbb.org/us/nj/paramus/profile/logistics/india-maritime-agency-llc-0221-90175580', 'India Maritime Agency LLC', 7652)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7371, 'https://www.bbb.org/us/nj/secaucus/profile/electric-equipment-repair/apex-xpress-inc-0221-90047231', 'Apex Xpress, Inc.', 7094)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7384, 'https://www.bbb.org/us/nj/jersey-city/profile/delivery-service/delivery-xpresscomllc-0221-90179381', 'Delivery-XPress.comLLC', 7302)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7458, 'https://www.bbb.org/us/nj/north-bergen/profile/logistics/corzo-logistics-llc-0221-90152204', 'Corzo Logistics LLC', 7047)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7483, 'https://www.bbb.org/us/nj/carlstadt/profile/freight-forwarding/best-shipping-ever-inc-0221-90062742', 'Best Shipping Ever Inc.', 7072)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7546, 'https://www.bbb.org/us/nj/moonachie/profile/logistics/pum-yang-logistics-inc-0221-90159682', 'Pum Yang Logistics, Inc.', 7074)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7555, 'https://www.bbb.org/us/nj/jersey-city/profile/delivery-service/jr-burgos-0221-20000118', 'J.R. Burgos', 7306)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7577, 'https://www.bbb.org/us/nj/newark/profile/air-cargo/cargo-airport-services-0221-90049010', 'Cargo Airport Services', 7114)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7605, 'https://www.bbb.org/us/nj/east-orange/profile/exporter/trans-caribe-express-shippers-0221-90013313', 'Trans Caribe Express Shippers', 7018)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7608, 'https://www.bbb.org/us/nj/belleville/profile/delivery-service/bromli-0221-90056393', 'Bromli', 7109)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7621, 'https://www.bbb.org/us/nj/clifton/profile/delivery-service/the-ups-store-2608-0221-90070350', 'The UPS Store - #2608', 7012)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7633, 'https://www.bbb.org/us/nj/carlstadt/profile/air-courier-service/on-the-go-cargo-inc-0221-90006747', 'On the Go Cargo, Inc.', 7072)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7660, 'https://www.bbb.org/us/nj/lodi/profile/food-delivery/grateful-bread-inc-0221-90178825', 'Grateful Bread, Inc.', 7644)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7712, 'https://www.bbb.org/us/nj/carlstadt/profile/warehouse-services/mvn-warehousing-inc-0221-90154250', 'MVN Warehousing Inc.', 7072)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7742, 'https://www.bbb.org/us/nj/little-ferry/profile/delivery-service/kd-express-llc-0221-90165493', 'K&D Express LLC', 7643)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7757, 'https://www.bbb.org/us/nj/rochelle-park/profile/delivery-service/info-proservices-llc-0221-90094257', 'Info Proservices LLC', 7662)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7776, 'https://www.bbb.org/us/nj/edgewater/profile/delivery-service/the-ups-store-4614-ste-32-0221-90154549', 'The UPS Store #4614 Ste 32', 7020)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (7854, 'https://www.bbb.org/us/nj/teterboro/profile/delivery-service/velocity-express-0221-90155315', 'Velocity Express', 7608)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8135, 'https://www.bbb.org/us/nj/woodbridge/profile/logistics/world-cargo-transport-inc-0221-90086681', 'World Cargo Transport, Inc.', 7095)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8156, 'https://www.bbb.org/us/nj/cranford/profile/logistics/oceanus-procurement-and-logistics-opal-llc-0221-90154745', 'Oceanus Procurement and Logistics (O.P.A.L.), LLC', 7016)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8205, 'https://www.bbb.org/us/nj/hillside/profile/custom-broker/jet-air-service-incorporated-0221-90163498', 'Jet Air Service Incorporated', 7205)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8218, 'https://www.bbb.org/us/nj/elizabeth/profile/logistics/phoenix-international-business-logistics-inc-0221-90159692', 'Phoenix International Business Logistics, Inc.', 7201)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8358, 'https://www.bbb.org/us/nj/newark/profile/transportation/trt-international-ltd-0221-90027370', 'TRT International Ltd.', 7114)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8376, 'https://www.bbb.org/us/nj/newark/profile/logistics/npd-logistics-inc-0221-90170301', 'NPD Logistics Inc.', 7114)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8386, 'https://www.bbb.org/us/nj/newark/profile/logistics/salson-0221-90102908', 'Salson', 7114)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8393, 'https://www.bbb.org/us/nj/hazlet/profile/trucking-transportation-brokers/kinetic-supply-chain-services-llc-0221-90164715', 'Kinetic Supply - Chain Services, LLC', 7730)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8396, 'https://www.bbb.org/us/nj/tinton-falls/profile/moving-and-storage-companies/woodbridge-moving-storage-0221-90163784', 'Woodbridge Moving & Storage', 7724)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8431, 'https://www.bbb.org/us/nj/manalapan/profile/moving-and-storage-companies/van-with-a-man-llc-0221-90169540', 'Van with a Man, LLC', 7726)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8434, 'https://www.bbb.org/us/nj/orange/profile/logistics/aegis-logistics-services-llc-0221-90056612', 'Aegis Logistics Services LLC', 7050)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8477, 'https://www.bbb.org/us/nj/northvale/profile/moving-companies/b-kilpatrick-moving-storage-inc-0221-4001876', 'B. Kilpatrick Moving & Storage, Inc.', 7647)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8482, 'https://www.bbb.org/us/nj/secaucus/profile/information-technology-services/efashion-solutions-llc-0221-28000311', 'eFashion Solutions, LLC', 7094)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8610, 'https://www.bbb.org/us/nj/morris-plains/profile/logistics/transamerica-logistics-inc-0221-90143209', 'TransAmerica Logistics, Inc.', 7950)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8611, 'https://www.bbb.org/us/nj/hawthorne/profile/packing-service/supernova-moving-0221-90166103', 'Supernova Moving', 7506)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8705, 'https://www.bbb.org/us/nj/shrewsbury/profile/moving-companies/coast-to-coast-moving-lines-llc-0221-90100790', 'Coast to Coast Moving Lines, LLC', 7702)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8739, 'https://www.bbb.org/us/nj/ocean/profile/moving-companies/teachers-moving-0221-11000764', 'Teacher''s Moving', 7712)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8761, 'https://www.bbb.org/us/nj/neptune/profile/moving-companies/lowys-moving-service-0221-1000336', 'Lowy''s Moving Service', 7753)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8802, 'https://www.bbb.org/us/nj/keansburg/profile/moving-companies/we-haul-moving-storage-company-0221-10001511', 'We Haul Moving & Storage Company', 7734)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8829, 'https://www.bbb.org/us/nj/marlboro/profile/moving-companies/tlc-movers-0221-4003840', 'TLC Movers', 7746)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8861, 'https://www.bbb.org/us/nj/wall-township/profile/moving-companies/econo-line-movers-inc-0221-17000400', 'Econo-Line Movers, Inc.', 7719)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8899, 'https://www.bbb.org/us/nj/englewood/profile/moving-services/tcc-enterprise-inc-0221-90063522', 'TCC Enterprise, Inc.', 7631)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8931, 'https://www.bbb.org/us/nj/saddle-brook/profile/moving-companies/best-guy-moving-0221-90164110', 'Best Guy Moving', 7763)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (8942, 'https://www.bbb.org/us/nj/south-plainfield/profile/motor-freight-trucking/new-england-motor-freight-0221-90165747', 'New England Motor Freight', 7080)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (9037, 'https://www.bbb.org/us/nj/bayonne/profile/motor-freight-trucking/strong-wheels-trucking-0221-90168769', 'Strong Wheels Trucking', 7002)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (9084, 'https://www.bbb.org/us/nj/woodbridge/profile/moving-services/green-line-moving-corp-0221-90039955', 'Green Line Moving Corp.', 7095)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (9098, 'https://www.bbb.org/us/nj/fairfield/profile/motor-freight-trucking/greenway-transport-llc-0221-90182680', 'Greenway Transport Llc', 7004)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (9213, 'https://www.bbb.org/us/nj/woodbridge/profile/moving-companies/josephs-movers-0221-10000263', 'Joseph''s Movers', 7095)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (9246, 'https://www.bbb.org/us/nj/rahway/profile/moving-companies/blue-line-van-lines-0654-88645779', 'Blue Line Van Lines', 7065)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (9274, 'https://www.bbb.org/us/nj/newton/profile/moving-companies/cant-quit-moving-llc-0221-90185132', 'Can''t Quit Moving, LLC', 7860)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (9289, 'https://www.bbb.org/us/nj/linden/profile/auto-transportation/autolog-corporation-0221-9003247', 'Autolog Corporation', 7036)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (9308, 'https://www.bbb.org/us/nj/scotch-plains/profile/moving-companies/rittenhouse-movers-0221-4004140', 'Rittenhouse Movers', 7076)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (9443, 'https://www.bbb.org/us/nj/s-plainfield/profile/moving-companies/big-g-movers-inc-0221-90157738', 'Big G Movers Inc', 7080)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (9508, 'https://www.bbb.org/us/nj/bayone/profile/moving-companies/aa-mr-move-inc-0221-29002576', 'AA MR Move Inc.', 7002)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (9536, 'https://www.bbb.org/us/nj/bayonne/profile/moving-companies/the-whole-nine-yards-0221-90069326', 'The Whole Nine Yards', 7002)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (9564, 'https://www.bbb.org/us/nj/bayonne/profile/moving-companies/white-glove-moving-storage-inc-0221-12001605', 'White Glove Moving & Storage, Inc.', 7002)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (9820, 'https://www.bbb.org/us/nj/elizabeth/profile/moving-companies/reliable-van-storage-co-inc-0221-28000878', 'Reliable Van & Storage Co. Inc.', 7201)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (9854, 'https://www.bbb.org/us/nj/randolph/profile/moving-services/graebel-northeastern-movers-inc-0221-17003101', 'Graebel Northeastern Movers, Inc.', 7869)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (9858, 'https://www.bbb.org/us/nj/jersey-city/profile/moving-companies/lbc-mabuhay-east-coast-corporation-0221-3000676', 'LBC Mabuhay East Coast Corporation', 7304)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (9872, 'https://www.bbb.org/us/nj/kearny/profile/moving-companies/lyndhurst-movers-inc-0221-7000262', 'Lyndhurst Movers, Inc.', 7032)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (9914, 'https://www.bbb.org/us/nj/rochelle-park/profile/moving-and-storage-companies/certified-van-lines-inc-0221-90063818', 'Certified Van Lines Inc', 7662)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (9996, 'https://www.bbb.org/us/nj/newark/profile/moving-companies/beltmann-relocation-group-0221-90127574', 'Beltmann Relocation Group', 7114)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (10017, 'https://www.bbb.org/us/nj/jersey-city/profile/moving-companies/best-movers-nj-moving-storage-0221-90119845', 'Best Movers NJ Moving & Storage', 7306)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (10079, 'https://www.bbb.org/us/nj/bloomfield/profile/moving-companies/van-express-llc-0221-90161470', 'Van Express, LLC', 7003)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (10088, 'https://www.bbb.org/us/nj/bloomfield/profile/moving-companies/flash-moving-solutions-llc-0221-90144054', 'Flash Moving Solutions, LLC', 7003)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (10119, 'https://www.bbb.org/us/nj/verona/profile/moving-companies/man-with-a-van-moving-co-inc-0221-90011996', 'Man with a Van Moving Co. Inc.', 7044)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (10159, 'https://www.bbb.org/us/nj/east-orange/profile/moving-companies/stevensons-moving-llc-0221-90153991', 'Stevenson''s Moving, LLC', 7017)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (10174, 'https://www.bbb.org/us/nj/orange/profile/moving-companies/lincoln-storage-warehouses-inc-0221-11006157', 'Lincoln Storage Warehouses, Inc.', 7050)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (10202, 'https://www.bbb.org/us/nj/clifton/profile/moving-companies/us-1-van-lines-of-new-jersey-inc-0221-17001628', 'US-1 Van Lines of New Jersey Inc.', 7013)  
    INSERT INTO [dbo].[aaFuzzy_BBB] ([Excel_Id], [Page_URL], [BusinessName], [ZipCode]) VALUES (10229, 'https://www.bbb.org/us/nj/passaic/profile/moving-companies/xtreme-movers-0221-90165958', 'Xtreme Movers', 7055)  
    INSERT INTO [dbo].[aaFuz
    
    0 comments No comments

  5. moondaddy 911 Reputation points
    2020-12-18T20:49:57.583+00:00

    Insert script for the table aaFuzzy_YP, the new data I want to import into the db, but first I want to identify which rows "Might" be duplicates.

    SET NOEXEC OFF
    SET ANSI_WARNINGS ON
    SET XACT_ABORT ON
    SET IMPLICIT_TRANSACTIONS OFF
    SET ARITHABORT ON
    SET NOCOUNT ON
    SET QUOTED_IDENTIFIER ON
    SET NUMERIC_ROUNDABORT OFF
    SET CONCAT_NULL_YIELDS_NULL ON
    SET ANSI_NULLS ON
    SET ANSI_PADDING ON
    GO
    
    USE [FuzzyComparison2]
    GO
    
    BEGIN TRAN
    
    -- =======================================================
    -- Inserting 1005 row(s) for table [dbo].[aaFuzzy_YP]
    -- =======================================================
    Print 'Inserting 1005 row(s) for table [dbo].[aaFuzzy_YP]'
    
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (1, 'https://www.yellowpages.com/houston-tx/mip/marvins-moving-and-delivery-503147463?lid=1001632207735', 'Marvin''s Moving and Delivery', 77071)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (1, 'https://www.yellowpages.com/houston-tx/mip/morris-export-service-19345047?lid=1001657193416', 'Morris Export Service', 77029)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (2, 'https://www.yellowpages.com/houston-tx/mip/tosie-462568413', 'Tosie', 77081)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (2, 'https://www.yellowpages.com/houston-tx/mip/westar-moving-storage-inc-2596638?lid=1002054403058', 'Westar Moving & Storage, Inc.', 77041)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (3, 'https://www.yellowpages.com/houston-tx/mip/a-1-allstate-movers-450764116?lid=1001191608192', 'A-1 Allstate Movers', 77063)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (3, 'https://www.yellowpages.com/houston-tx/mip/universal-freight-464667652', 'Universal Freight', 77092)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (4, 'https://www.yellowpages.com/houston-tx/mip/rapi-clinica-533335620', 'Rapi Clinica', 77011)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (4, 'https://www.yellowpages.com/houston-tx/mip/southland-movers-505743906?lid=1000489806598', 'Southland Movers', 77043)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (5, 'https://www.yellowpages.com/houston-tx/mip/andy-mo-moving-513071016?lid=1001211635104', 'Andy & Mo Moving', 77043)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (5, 'https://www.yellowpages.com/houston-tx/mip/fts-international-express-10298835', 'FTS International Express', 77060)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (6, 'https://www.yellowpages.com/houston-tx/mip/asap-freight-systems-1691277', 'ASAP Freight Systems', 77093)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (6, 'https://www.yellowpages.com/houston-tx/mip/huckster-packaging-supply-12402852?lid=1001854561026', 'Huckster Packaging & Supply', 77023)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (7, 'https://www.yellowpages.com/houston-tx/mip/huckster-packaging-supply-12402852?lid=1001854561026', 'Huckster Packaging & Supply', 77023)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (7, 'https://www.yellowpages.com/houston-tx/mip/tg-international-freight-467571645', 'Tg International Freight', 77060)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (8, 'https://www.yellowpages.com/houston-tx/mip/marine-trans-usa-4106680', 'Marine Trans USA', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (8, 'https://www.yellowpages.com/houston-tx/mip/my-mover-475970305?lid=1000437162281', 'My Mover', 77007)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (9, 'https://www.yellowpages.com/houston-tx/mip/kuehne-nagal-inc-1003078', 'Kuehne & Nagal Inc', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (9, 'https://www.yellowpages.com/tomball-tx/mip/tomball-moving-storage-inc-541908461?lid=1000437085282', 'Tomball Moving & Storage, Inc', 77375)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (10, 'https://www.yellowpages.com/houston-tx/mip/space-saver-8-self-storage-6689534?lid=1001866844263', 'Space Saver 8 Self Storage', 77087)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (10, 'https://www.yellowpages.com/houston-tx/mip/weiss-rohlig-u-s-a-460669773', 'Weiss-Rohlig U S A', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (11, 'https://www.yellowpages.com/houston-tx/mip/petrasco-services-inc-4243505', 'Petrasco Services Inc', 77060)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (11, 'https://www.yellowpages.com/houston-tx/mip/space-city-moving-companies-464650525', 'Space City Moving Companies', 77007)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (12, 'https://www.yellowpages.com/houston-tx/mip/bellaire-hillcroft-self-storage-468129296?lid=1001866844261', 'Bellaire-Hillcroft Self Storage', 77081)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (12, 'https://www.yellowpages.com/houston-tx/mip/d-t-s-world-cargo-13548431', 'D T S World Cargo', 77017)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (13, 'https://www.yellowpages.com/houston-tx/mip/primar-international-1126143', 'Primar International', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (14, 'https://www.yellowpages.com/houston-tx/mip/morrison-express-corp-466143975', 'Morrison Express Corp', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (14, 'https://www.yellowpages.com/houston-tx/mip/per-the-mile-llc-555669704?lid=1002048668071', 'Per The Mile, LLC.', 77023)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (15, 'https://www.yellowpages.com/houston-tx/mip/anderson-international-transport-473521687', 'Anderson International Transport', 77045)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (15, 'https://www.yellowpages.com/houston-tx/mip/lafayette-west-corporate-housing-531492884?lid=1002004270250', 'LaFayette  West Corporate Housing', 77079)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (16, 'https://www.yellowpages.com/houston-tx/mip/transera-international-1218913', 'Transera International', 77064)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (16, 'https://www.yellowpages.com/pompano-beach-fl/mip/we-will-transport-it-482880155?lid=1002044024892', 'We Will Transport It', 33073)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (17, 'https://www.yellowpages.com/houston-tx/mip/dsv-475893522', 'Dsv', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (17, 'https://www.yellowpages.com/houston-tx/mip/marvins-moving-and-delivery-503147463?lid=1001632207735', 'Marvin''s Moving and Delivery', 77071)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (18, 'https://www.yellowpages.com/houston-tx/mip/freight-forwarders-inc-458036489', 'Freight Forwarders Inc', 77039)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (18, 'https://www.yellowpages.com/houston-tx/mip/texans-movers-482417707?lid=1000437172159', 'Texans Movers', 77449)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (19, 'https://www.yellowpages.com/houston-tx/mip/marvins-moving-and-delivery-503147463?lid=1001632207735', 'Marvin''s Moving and Delivery', 77071)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (19, 'https://www.yellowpages.com/houston-tx/mip/transcore-13958036', 'TransCore', 77041)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (20, 'https://www.yellowpages.com/houston-tx/mip/american-knights-moving-storage-inc-470201275', 'American Knights Moving & Storage, Inc.', 77087)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (20, 'https://www.yellowpages.com/houston-tx/mip/crane-freight-services-470231101', 'Crane Freight Services', 77073)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (21, 'https://www.yellowpages.com/houston-tx/mip/rmi-cargo-503116065', 'RMI Cargo', 77072)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (21, 'https://www.yellowpages.com/houston-tx/mip/two-men-and-a-truck-2997991?lid=1000439646719', 'Two Men and A Truck', 77041)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (22, 'https://www.yellowpages.com/houston-tx/mip/minute-movers-469947535', 'Minute Movers', 77048)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (22, 'https://www.yellowpages.com/houston-tx/mip/yusen-logistics-470231029', 'Yusen Logistics', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (23, 'https://www.yellowpages.com/houston-tx/mip/deugro-projects-usa-10475874', 'Deugro Projects USA', 77041)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (23, 'https://www.yellowpages.com/houston-tx/mip/nationwide-movers-470056287', 'Nationwide Movers', 77008)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (24, 'https://www.yellowpages.com/houston-tx/mip/geodis-wilson-7114076', 'Geodis Wilson', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (24, 'https://www.yellowpages.com/houston-tx/mip/norberg-office-services-503310446?lid=1001387158247', 'Norberg Office Services', 77055)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (25, 'https://www.yellowpages.com/houston-tx/mip/pv-rentals-475112424?lid=1001609105389', 'PV Rentals', 77081)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (25, 'https://www.yellowpages.com/houston-tx/mip/transpotrade-international-13427499', 'Transpotrade International', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (26, 'https://www.yellowpages.com/houston-tx/mip/512-moving-military-piano-apartment-full-service-movers-479802185', '512 Moving Military, Piano, Apartment, Full Service Movers', 77009)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (26, 'https://www.yellowpages.com/houston-tx/mip/tuvalex-corp-inc-476111766', 'Tuvalex Corp Inc', 77057)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (27, 'https://www.yellowpages.com/houston-tx/mip/new-beginning-movers-22903546', 'New Beginning Movers', 77082)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (27, 'https://www.yellowpages.com/houston-tx/mip/spartan-global-services-group-470279805', 'Spartan Global Services Group', 77092)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (28, 'https://www.yellowpages.com/houston-tx/mip/new-reliable-movers-532652329', 'New Reliable Movers', 77099)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (28, 'https://www.yellowpages.com/houston-tx/mip/nippon-express-usa-503089217', 'Nippon Express USA', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (29, 'https://www.yellowpages.com/houston-tx/mip/international-frontier-455239171', 'International Frontier', 77068)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (29, 'https://www.yellowpages.com/houston-tx/mip/moving-help-464626319', 'Moving Help', 77054)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (30, 'https://www.yellowpages.com/houston-tx/mip/niche-international-shipping-527892957', 'Niche International Shipping', 77028)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (31, 'https://www.yellowpages.com/houston-tx/mip/muches-global-industries-17228486', 'Muches Global Industries', 77099)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (31, 'https://www.yellowpages.com/houston-tx/mip/smooth-moves-moving-company-525077157', 'Smooth Moves Moving Company', 77024)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (32, 'https://www.yellowpages.com/houston-tx/mip/rhdc-international-7789557', 'RHDC International', 77007)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (33, 'https://www.yellowpages.com/houston-tx/mip/bargain-houston-movers-472656752', 'Bargain Houston Movers', 77002)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (33, 'https://www.yellowpages.com/houston-tx/mip/dimerco-express-usa-corp-7825390', 'Dimerco Express USA Corp', 77060)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (34, 'https://www.yellowpages.com/houston-tx/mip/houston-top-moving-452313891', 'HOUSTON TOP MOVING', 77058)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (34, 'https://www.yellowpages.com/houston-tx/mip/servitrans-inc-458344813', 'Servitrans INC', 77040)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (35, 'https://www.yellowpages.com/houston-tx/mip/allstates-worldcargo-467661619', 'Allstates WorldCargo', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (35, 'https://www.yellowpages.com/houston-tx/mip/student-movers-inc-538967996', 'Student Movers Inc', 77063)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (36, 'https://www.yellowpages.com/houston-tx/mip/lognet-worldwide-inc-473824698', 'Lognet Worldwide Inc', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (36, 'https://www.yellowpages.com/houston-tx/mip/prestigious-movers-480147929', 'Prestigious Movers', 77060)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (37, 'https://www.yellowpages.com/houston-tx/mip/matson-integrated-logistics-inc-455220248', 'Matson Integrated Logistics Inc', 77070)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (37, 'https://www.yellowpages.com/houston-tx/mip/the-mooovers-479996317', 'The Mooovers', 77015)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (38, 'https://www.yellowpages.com/houston-tx/mip/major-van-lines-482441053', 'Major Van Lines', 77013)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (38, 'https://www.yellowpages.com/houston-tx/mip/winston-logistics-transportation-534458982', 'Winston Logistics & Transportation', 77026)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (39, 'https://www.yellowpages.com/houston-tx/mip/skipping-stone-inc-466124208', 'Skipping Stone Inc', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (39, 'https://www.yellowpages.com/houston-tx/mip/southwest-moving-and-delivery-8040182', 'Southwest Moving and Delivery', 77099)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (40, 'https://www.yellowpages.com/houston-tx/mip/moving-help-464622695', 'Moving Help', 77080)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (40, 'https://www.yellowpages.com/houston-tx/mip/unit-cargo-container-line-inc-464988415', 'Unit Cargo Container Line, Inc.', 77027)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (41, 'https://www.yellowpages.com/houston-tx/mip/daniel-f-young-inc-1420623', 'Daniel F Young Inc', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (41, 'https://www.yellowpages.com/houston-tx/mip/electronic-data-carriers-inc-455199960', 'Electronic Data Carriers Inc', 77055)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (42, 'https://www.yellowpages.com/houston-tx/mip/bestrate-moving-storage-co-474358256', 'BestRate Moving & Storage Co.', 77007)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (42, 'https://www.yellowpages.com/houston-tx/mip/safeway-shipping-482254890', 'Safeway Shipping', 77045)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (43, 'https://www.yellowpages.com/houston-tx/mip/baycor-international-9978511', 'Baycor International', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (43, 'https://www.yellowpages.com/houston-tx/mip/edc-moving-systems-53331', 'EDC Moving Systems', 77055)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (44, 'https://www.yellowpages.com/houston-tx/mip/cantu-moving-inc-459016306', 'Cantu Moving, Inc.', 77020)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (44, 'https://www.yellowpages.com/houston-tx/mip/tropic-brokers-7706878', 'Tropic Brokers', 77098)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (45, 'https://www.yellowpages.com/houston-tx/mip/hont-global-services-503136385', 'Hont Global Services', 77054)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (46, 'https://www.yellowpages.com/houston-tx/mip/a-low-cost-movers-co-469820172', 'A-Low Cost Movers Co.', 77036)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (46, 'https://www.yellowpages.com/houston-tx/mip/t-g-intl-inc-455247101', 'T G Intl Inc', 77079)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (47, 'https://www.yellowpages.com/houston-tx/mip/aquaocean-transport-inc-530853709', 'Aquaocean Transport Inc', 77008)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (47, 'https://www.yellowpages.com/houston-tx/mip/flores-moving-company-480910464', 'FLORES MOVING COMPANY', 77081)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (48, 'https://www.yellowpages.com/houston-tx/mip/maxwell-movers-529464793', 'Maxwell Movers', 77007)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (48, 'https://www.yellowpages.com/houston-tx/mip/tejas-freight-forwarding-inc-30216038', 'Tejas Freight Forwarding Inc', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (49, 'https://www.yellowpages.com/houston-tx/mip/christian-movers-463711196', 'Christian Movers', 77083)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (49, 'https://www.yellowpages.com/houston-tx/mip/linear-shipping-11841404', 'Linear Shipping', 77017)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (50, 'https://www.yellowpages.com/houston-tx/mip/alliance-apartment-movers-22240339', 'Alliance Apartment Movers', 77096)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (50, 'https://www.yellowpages.com/houston-tx/mip/lonestar-freight-systems-523917876', 'Lonestar Freight Systems', 77049)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (51, 'https://www.yellowpages.com/houston-tx/mip/axis-global-systems-496505431', 'Axis Global Systems', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (51, 'https://www.yellowpages.com/houston-tx/mip/jesses-24-hr-moving-service-474075656', 'Jesses 24 HR Moving Service', 77066)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (52, 'https://www.yellowpages.com/houston-tx/mip/di-co-moving-inc-13083287', 'Di-Co Moving, Inc.', 77259)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (52, 'https://www.yellowpages.com/houston-tx/mip/stinson-logistics-llc-531924759', 'Stinson Logistics, LLC', 77060)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (53, 'https://www.yellowpages.com/houston-tx/mip/air-ocean-463749888', 'Air & Ocean', 77018)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (53, 'https://www.yellowpages.com/houston-tx/mip/swift-budget-moving-services-512960618', 'swift budget moving services', 77062)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (54, 'https://www.yellowpages.com/houston-tx/mip/nh-logistics-503936619', 'Nh Logistics', 77044)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (54, 'https://www.yellowpages.com/houston-tx/mip/secured-moving-and-packing-co-502584917', 'Secured Moving and Packing Co', 77099)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (55, 'https://www.yellowpages.com/houston-tx/mip/frachy-fwo-inc-548341656', 'Frachy Fwo Inc', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (55, 'https://www.yellowpages.com/houston-tx/mip/garretts-moving-storage-531189026', 'Garrett''s Moving & Storage', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (56, 'https://www.yellowpages.com/houston-tx/mip/hm-cargo-525045662', 'Hm Cargo', 77087)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (56, 'https://www.yellowpages.com/houston-tx/mip/indivisible-van-lines-550969733', 'INDIVISIBLE VAN LINES', 77092)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (57, 'https://www.yellowpages.com/houston-tx/mip/moving-help-465140739', 'Moving Help', 77057)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (57, 'https://www.yellowpages.com/houston-tx/mip/productos-los-andes-19698912', 'Productos Los Andes', 77008)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (58, 'https://www.yellowpages.com/houston-tx/mip/armstrong-relocation-466123760', 'Armstrong Relocation', 77041)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (58, 'https://www.yellowpages.com/houston-tx/mip/baycor-international-9189633', 'Baycor International', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (59, 'https://www.yellowpages.com/houston-tx/mip/a-rocket-moving-storage-inc-2489791', 'A Rocket Moving & Storage Inc', 77021)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (59, 'https://www.yellowpages.com/houston-tx/mip/spi-marine-houston-inc-503466450', 'SPI Marine Houston Inc', 77027)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (60, 'https://www.yellowpages.com/houston-tx/mip/expedited-logistics-463741843', 'Expedited Logistics', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (60, 'https://www.yellowpages.com/houston-tx/mip/laminate-paint-and-moving-services-522000363', 'Laminate, Paint, and Moving Services', 77083)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (61, 'https://www.yellowpages.com/houston-tx/mip/my-mover-475970305?lid=1000437162281', 'My Mover', 77007)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (61, 'https://www.yellowpages.com/houston-tx/mip/ranahan-solutions-496075430', 'Ranahan Solutions', 77012)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (62, 'https://www.yellowpages.com/houston-tx/mip/daikon-enterprise-524375954', 'Daikon Enterprise', 77071)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (62, 'https://www.yellowpages.com/houston-tx/mip/great-american-moving-storage-480256991', 'Great American Moving & Storage', 77087)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (63, 'https://www.yellowpages.com/houston-tx/mip/da-freight-503020980', 'Da Freight', 77036)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (63, 'https://www.yellowpages.com/houston-tx/mip/moving-help-464638911', 'Moving Help', 77073)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (64, 'https://www.yellowpages.com/houston-tx/mip/bekins-van-lines-468302958', 'Bekins Van Lines', 77074)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (64, 'https://www.yellowpages.com/houston-tx/mip/linear-shipping-497796078', 'Linear Shipping', 77074)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (65, 'https://www.yellowpages.com/houston-tx/mip/emanuel-movers-551444213', 'Emanuel movers', 77074)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (65, 'https://www.yellowpages.com/houston-tx/mip/teekay-shipping-usa-inc-475738394', 'Teekay Shipping USA Inc', 77002)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (66, 'https://www.yellowpages.com/houston-tx/mip/moving-help-464639282', 'Moving Help', 77081)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (66, 'https://www.yellowpages.com/houston-tx/mip/pegasus-transportation-18807625', 'Pegasus Transportation', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (67, 'https://www.yellowpages.com/houston-tx/mip/moving-help-464625297', 'Moving Help', 77088)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (67, 'https://www.yellowpages.com/houston-tx/mip/pacer-global-logistics-18452816', 'Pacer Global Logistics', 77029)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (68, 'https://www.yellowpages.com/houston-tx/mip/texas-move-it-houston-professional-movers-535137294', 'Texas Move-It - Houston Professional Movers', 77036)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (68, 'https://www.yellowpages.com/houston-tx/mip/total-logistics-481129884', 'Total Logistics', 77008)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (69, 'https://www.yellowpages.com/houston-tx/mip/bdp-international-533162651', 'BDP International', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (69, 'https://www.yellowpages.com/houston-tx/mip/moving-help-464639757', 'Moving Help', 77081)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (70, 'https://www.yellowpages.com/houston-tx/mip/mayflower-agency-wald-relocatn-453666565', 'Mayflower Agency Wald Relocatn', 77081)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (70, 'https://www.yellowpages.com/houston-tx/mip/weston-467857051', 'Weston', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (71, 'https://www.yellowpages.com/houston-tx/mip/cargo-unlimited-459220693', 'Cargo Unlimited', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (71, 'https://www.yellowpages.com/houston-tx/mip/rent-a-dude-movers-556126902', 'Rent-A-Dude Movers', 77092)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (72, 'https://www.yellowpages.com/houston-tx/mip/cheap-houston-movers-us-moving-548393741', 'Cheap Houston Movers Us Moving', 77006)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (72, 'https://www.yellowpages.com/houston-tx/mip/datin-supply-company-inc-458146272', 'Datin Supply Company Inc', 77058)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (73, 'https://www.yellowpages.com/houston-tx/mip/boxx-it-up-547000700', 'Boxx It Up', 77208)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (73, 'https://www.yellowpages.com/houston-tx/mip/china-shipping-north-amer-agency-29879428', 'China Shipping North Amer Agency', 77060)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (74, 'https://www.yellowpages.com/houston-tx/mip/suntrans-international-inc-9344229', 'Suntrans International Inc', 77060)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (74, 'https://www.yellowpages.com/houston-tx/mip/transitions-group-503290680', 'Transitions Group', 77003)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (75, 'https://www.yellowpages.com/houston-tx/mip/advanced-international-services-480916442', 'Advanced International Services', 77060)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (75, 'https://www.yellowpages.com/houston-tx/mip/g-g-movers-545594103', 'G&G Movers', 77072)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (76, 'https://www.yellowpages.com/houston-tx/mip/sterling-relocations-468955205', 'Sterling Relocations', 77007)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (76, 'https://www.yellowpages.com/houston-tx/mip/zimmer-worldwide-logistics-inc-505000879', 'Zimmer Worldwide Logistics, Inc.', 77032)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (77, 'https://www.yellowpages.com/houston-tx/mip/aprile-usa-inc-465209474', 'Aprile USA Inc', 77042)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (77, 'https://www.yellowpages.com/houston-tx/mip/greenway-express-texas-543211929', 'Greenway Express Texas', 77081)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (78, 'https://www.yellowpages.com/houston-tx/mip/atlantic-relocation-systems-1190846', 'Atlantic Relocation Systems', 77041)
    INSERT INTO [dbo].[aaFuzzy_YP] ([Excel_Id], [Page_URL], [Company_Name], [ZipCode]) VALUES (78, 'https://www.yellowpages.com/houston-tx/mip/livingston-international-524875444', 'Livingston Interna
    
    0 comments No comments