Post reply

Rank duplicates, but only rows involved in duplicates

  • October 22, 2014 at 8:54 am

    #291193

    Hi,

    I have a table with 22 million Business records. I can see that there are duplicates when I group by BusinessName and Address and Phone. I'd like to place only the duplicates into a table, with a ranking, oldest business key gets a ranking of 1.

    As a bonus I'd like each group to have a distinct group name (although not necessary, just want to know how to do this)

    Later after I run more verifications to make sure these are not referenced elsewhere I'll delete everything with a matchRank > 1 out of the main Business table.

    DROP TABLE [dbo].[TestBusiness];

    GO

    CREATE TABLE [dbo].[TestBusiness](

    [Business_pk] INT IDENTITY(1,1) NOT NULL,

    [BusinessName] VARCHAR (200) NOT NULL,

    [Address] VARCHAR(MAX) NOT NULL,

    [Phone] VARCHAR(10) NOT NULL,

    [FirstName] VARCHAR(20) NULL,

    [LastName] VARCHAR(20) NULL,

    CONSTRAINT [PK_TestBusiness] PRIMARY KEY CLUSTERED

    (

    [Business_pk] ASC

    )

    );

    GO

    TRUNCATE TABLE [dbo].[TestBusiness];

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('BCTB DPTMS','4501 RM 228 KILLEEN TX 76544',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('DBA MARINE CARGO SERVICES INC','183 OSSIPEE TRL NULL LIMINGTON ME 4049',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Inc Arnold Investment Counsel','3960 HILLSIDE DR NULL DELAFIELD WI 53018',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('LLC BRUNSWICK PLAZA','720 HOOSICK RD NULL TROY NY 12180',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('LLC MULBERRY TEK','638 SE 4TH ST NULL LEES SUMMIT MO 64063',512577233);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('LLC STERLING INTERNATIONAL','88 MAIN ST NULL GREENWICH NY 12834',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('LLC WARREN E BAHR CPA','24 SOUTHMAYD RD STE 11 CAMPTON NH 3223',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('# 138 H E B GROCERY','101 N CROCKETT ELSA TX 78543',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('# 138 H E B GROCERY','101 N CROCKETT ELSA TX 78543',9562621501);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('&T AIRPORT HOSPITALITY LLC','32 HEATHERDOWN DR ROADRUNNER WESTERVILLE OH 43081',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('????','ROOSEVELT AVE WOODSIDE NY 11377',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('01 EMERGENCY A LOCKSMITH','2272 PINE WARBLER WAY MARIETTA GA 30062',7702500495);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('04 TRACY MAYFIELD','146 CHRISTY DR NULL CUYAHOGA FALLS OH 44223',330922523);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('1 24 Hour A Emerg Locksmith','4026 UNION ST FLUSHING NY 11354',3475424084);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('1 800 RADIATOR','1117 COBB PKWY S MARIETTA GA 30060',7704208600);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('1 STOP CD DVD DUPLICATION REP','428 8TH ST DEL MAR CA 92014',6267994696);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('1-800-Flowerscom Inc','1000 W ARKANSAS LN ARLINGTON TX 76013',8174613537);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('120 Cleaners','3125 ROSWELL RD MARIETTA GA 30062',7705650961);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('1294 Sterling Realty LLC','176 25 Union Tpke 216 Fresh Meadows NY 11366',7189690003);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('13 Holdings Inc','1110 South Ave Ste 403 New York NY 10001',9174182531);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('1508613 CS-PP FUNERAL HOME','331 S 4TH ST ROADRUNNER DANVILLE KY 40422',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('1625 S COBB DR LLC','1625 S COBB DR SE MARIETTA GA 30060',7707949333);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('1701 Cafe Inc','1707 BROADWAY NEW YORK NY 10019',2122455400);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('1784 Poinsettia Inc','1906 POINSETTA DR MARIETTA GA 30062',7709771178);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('1st AMERICAN ROADSIDE SERVICE','1610 RENEA CT NULL KEARNEY MO 64060',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('1st Choice On Line LLC','445 WINDY HILL RD SE MARIETTA GA 30060',7704310050);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('1st Nations Mortgage','2545 RAINTREE WAY NE MARIETTA GA 30068',7705796766);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('1st Superior Insurance Group I','1511 S COBB DR SE MARIETTA GA 30060',7705289088);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('2 Guys From Puna','17-4013 Kuaaina Rd Kurtistown HI 96760',8089666876);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('20/20 Eye Care Inc','4101 ROSWELL RD MARIETTA GA 30062',7705653970);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('2000 Concrete Structural','326 ROSWELL ST SE MARIETTA GA 30060',7704200733);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('2002 PERFORMANCE PARTS','3924 SENTRY WALK MARIETTA GA 30068',7709774923);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('21i Net Services AG','45 Rockefeller Plz 2071 New York NY 10111',2123322850);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('21ST CENTURY COMM LEARNING','PO BOX 440 JAMESTOWN KY 42629',2708663071);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('21st Century Realty','97 WINDY HILL RD SW MARIETTA GA 30060',6782137778);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('24 Hour 7 Day Emergency Locksm','1136 E COMMONS MARIETTA GA 30062',7704268848);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('24 Hour Emergency Locksmith','4880 LOWER ROSWELL RD MARIETTA GA 30068',6788040492);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('24 Hour Emergency Locksmith','903 ROSWELL ST NE MARIETTA GA 30060',7704222625);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('24 Hour Locksmith Service','1100 JOHNSON FERRY RD MARIETTA GA 30068',7705148989);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('24 HOURS PROFESSIONAL MOVERS','627 CHEROKEE ST NE MARIETTA GA 30060',7704207003);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('24 Hours Professional Movers','627 CHEROKEE ST NE MARIETTA GA 30060',7704207003);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('24 Hr 20 4 Locksmith Marietta','680 S MARIETTA PKWY SE MARIETTA GA 30060',7702500088);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('24 Hr Fast Locksmith','4101 ROSWELL RD MARIETTA GA 30062',6783030760);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('250 CLEANERS','4706 LOWER ROSWELL RD MARIETTA GA 30068',7705099600);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('2961 Assocs','Park Ave New York NY 10022',2127528656);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('2K TECHNOLOGIES','1165 ALLGOOD RD MARIETTA GA 30062',7703215603);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('3 BEARS MOVING CORP','14 WHALE SQ # B BROOKLYN NY 11232',7185871161);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('3 D MANAGEMENT SVC INC','PO BOX 186 MADISON WV 25130',3043699286);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('3 D Printing Services Inc','246 17 Jamaica Ave Bellerose NY 11426',7183470530);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('3 D Printing Services Inc','246 17 Jamaica Ave Bellerose NY 11426',7183470530);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('3 Tcm Construction Cleani','1348 WATERFORD GREEN CLOSE MARIETTA GA 30068',7707950234);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('3 VITAL SOLUTIONS','1083 PRINCETON WALK NE MARIETTA GA 30068',7703648472);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('3 Vital Solutions LLC','PO BOX 681553 MARIETTA GA 30068',6785287713);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('3-Rs Movers & Delivery Svc','1805 ROSWELL RD MARIETTA GA 30062',7705652299);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('321 BATALLION','S INTERSTATE 35 AUSTIN TX 78741',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('333 SOUTH FIRST AVE LLC','61 LENOX AVE 333 SOUTH 1ST AVE NEW YORK NY 10026',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('359 SALTWATER DISPOSAL SYSTEM','1805 CLARK BLVD LAREDO TX 78043',9567247295);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('360 Corp','3479 MILL BRIDGE DR MARIETTA GA 30062',7704209199);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('365 Nutrition Inc','1205 JOHNSON FERRY RD MARIETTA GA 30068',7705093644);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('3b Properties LLC','2100 ROSWELL RD MARIETTA GA 30062',7709776657);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('3KENMAR PEDIATRICS II','700 CHURCH ST NE MARIETTA GA 30060',6782906831);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('3p Delivery Inc','1851 W OAK PKWY STE 100 MARIETTA GA 30062',7704244555);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('3rd Custom Drapery','3292 HOLLY SPRINGS RD MARIETTA GA 30062',7705091197);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('4 DZINES','3225 SHALLOWFORD RD MARIETTA GA 30062',7709779996);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('4 Dzines LLC','3225 SHALLOWFORD RD MARIETTA GA 30062',7709779996);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('4 Luv of Pets','PO BOX 682431 MARIETTA GA 30068',7705659820);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('4 R SERVICING','1503 PARKAIRE XING MARIETTA GA 30068',7706272958);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('4 WHEEL PARTS PERFORMANCE CTR','911 COBB PKWY N MARIETTA GA 30062',7704279840);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('4dnexus Com Inc','9450 Mira Mesa Blvd 615 San Diego CA 92126',8585301964);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('4r Cleaning Svcs','3203 IVORY TRL SW MARIETTA GA 30060',7704325202);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('4u2c Detailing LLC','2425 SEWELL MILL RD MARIETTA GA 30062',6785084735);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('5000 Inc','Coldwater Ter N Hollywood CA 91604',8185066442);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('553 CSSB','39002 RM E34B KILLEEN TX 76544',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('553 CSSB','39002 RM E34B KILLEEN TX 76544',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('56 SOUTH STORAGE CTR','56 SIXTH ST DOVER NH 3820',6037424422);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('5th Generation Painting & Cont','1240 JOHNSON FERRY PL MARIETTA GA 30068',7709736995);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('5th Generation Roofing','1344 E COBB DR MARIETTA GA 30068',7705092525);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('64TH MP CO CQ DESK','16003 CQ EAST KILLEEN TX 76544',254287257);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('64TH MP CO CQ DESK','16003 CQ EAST KILLEEN TX 76544',254287257);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('7 DAY ALWAYS EMERGENCY LCKSMTH','24930 HORACE HARDING EXPY FLUSHING NY 11362',7185359142);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('7-ELEVEN','PO BOX 757 MINERAL WELLS WV 26150',3044891255);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('7-Eleven Inc','131st St N Largo FL 33774',7275967894);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('790 THE ZONE','4101 ROSWELL RD MARIETTA GA 30062',7709776674);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('790 Zone','4101 ROSWELL RD MARIETTA GA 30062',7709776844);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('800 FLOWERS','1000 W ARKANSAS LN ARLINGTON TX 76013',8174613537);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('808 Surf N Skate','75 5695 Alii Dr Kailua Kona HI 96740',8083291100);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('84 LUMBER CO','RR 2 BOX 100 WILLIAMSTOWN WV 26187',3043756514);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('96 TRANSPORTATION CO 1-80 BN','39036 DAYROOM NULL KILLEEN TX 76544',254553174);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('96 TRANSPORTATION CO 1/80 BN','39036 DAYROOM KILLEEN TX 76544',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('99 Cents Plus LLC','923 19 Jamaica Ave Jamaica NY 11421',7184413033);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & A ALFA DRIVING SCHOOL','675 ROSWELL ST NE MARIETTA GA 30060',7707924404);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & A Construction & Design','125 10 Queens Blvd Kew Gardens NY 11415',7185447878);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & A Landscaping','187 CRANFILL RD SE MARIETTA GA 30060',7704992199);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & A MEAT MARKET & GROCERY','PO BOX 75B MERCEDES TX 78570',9565659448);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & A MOBILE NOTARY SVC','2255 SEWELL MILL RD STE 110 MARIETTA GA 30062',4044033133);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & A Remodelers Inc','4270 STONEHAM TER MARIETTA GA 30068',7703216908);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & A Termite & Pest Control','PO BOX 6506 MARIETTA GA 30065',7705780443);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & B Flooring','45 934 Kam Hwy Kaneohe HI 96744',8082558090);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & B Sunshine Taxi Service','1606 LOWER ROSWELL RD MARIETTA GA 30068',7709713100);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & C Tropical Food Store Inc','316 S FAIRGROUND ST SE MARIETTA GA 30060',7704190025);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & D Painting Inc','PO BOX 500654 ATLANTA GA 31150',7705095412);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & E STAFFING','1165 ALLGOOD RD MARIETTA GA 30062',7709778144);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & G Consulting','4419 DUNMORE RD NE MARIETTA GA 30068',6785609255);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & G Friction','1830 AIRPORT IND PARK DR SE MARIETTA GA 30060',7709551987);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & G Heating and AC Svcs','2370 WILLEO RILL RD MARIETTA GA 30062',7706426426);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & I Petroleum Inc','22777 Main St Crown Point NY 12928',5185974242);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & M Enterprises Intl','2363 MONTE VILLA CTS MARIETTA GA 30062',7705780468);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & P Auto Service','1155 S COBB DR SE MARIETTA GA 30060',6782900990);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & R Valley Radiator','Van Nuys CA 91401 Sherman Oaks CA 91401',8187631369);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & S AUTO PARTS','PO BOX E MONTROSE PA 18801',5702784322);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & S Convenience Stores Inc','901 MILFORD CHURCH RD SW MARIETTA GA 30060',7704310517);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & S Glass & Metal Inc','310 S FAIRGROUND ST SE MARIETTA GA 30060',7704270664);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A & W Electrical Solutions','1805 ROSWELL RD APT 16E MARIETTA GA 30062',6783147525);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A 1 APPLIANCE','1710 HOWARD ST E LIVE OAK FL 32064',3863649305);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A 1 DRYWALL & ACOUSTICS','53 TATUM ST SW MARIETTA GA 30060',6787975599);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A 1 ENGINE PARTS CO','286 S FAIRGROUND ST SE MARIETTA GA 30060',7704274602);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A 1 People Count Inc','PO BOX 6384 MARIETTA GA 30065',6783547930);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A 1-American Plumbing','972 AZALEA CIR MARIETTA GA 30062',7704221450);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A A 24 Hour A A A Locksmith','1844 BISHOPS GREEN DR MARIETTA GA 30062',7702500916);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A A A Insurance Agency','4101 ROSWELL RD STE 301 MARIETTA GA 30062',7705655700);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A A ARROW MOVING & STORAGE INC','14 WHALE SQ BROOKLYN NY 11232',5168270347);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A A ARROW MOVING & STORAGE INC','14 WHALE SQ BROOKLYN NY 11232',7185576683);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A A Drain Cleaning Service','PO BOX 412 SHANNON GA 30172',7709732281);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A A Pet Kennel Inc','3910 WESLEY CHAPEL RD MARIETTA GA 30062',7709775542);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A A PET KENNELS INC','3910 WESLEY CHAPEL RD MARIETTA GA 30062',7709775542);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A A SCREEN PRINTING','1087 S MARIETTA PKWY SE MARIETTA GA 30060',6785815559);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A A TAXI CABS','2022 S COBB DR SE MARIETTA GA 30060',6782140888);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A A TAXI CABS','2022 S COBB DR SE MARIETTA GA 30060',6784372603);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A A Titan Stucco','1103 BAKER LN MARIETTA GA 30062',6787669563);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A A Waterproofing','130 MCLAREN GATES DR MARIETTA GA 30060',7704431155);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Action Auto Trim','863 ROSWELL ST NE MARIETTA GA 30060',7707940123);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A All County Lock & Key','2754 GEORGIAN TER MARIETTA GA 30068',7705781198);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A AMERICAN SECURITY ALARM','PO BOX 37060 CLEVELAND OH 44137',3305629329);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A AN CTR','414 RIGBY ST NE MARIETTA GA 30060',7704275111);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A and M Grocery','FM 2360 E Side 23 Grulla TX 78548',9564876555);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Approved Siding & Window Co','2343 PRINCE HOWARD WAY MARIETTA GA 30062',7709731835);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A ARNIES DEPENDABLE APPLIANCE','PO BOX 566 CRYSTAL BEACH FL 34681',7278489749);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Around Clock Locksmith Inc','3603 SADLERS WALK MARIETTA GA 30068',7709739208);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Assist Nurse','140 MARBLE MILL RD NW MARIETTA GA 30060',6783550043);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A AUTO INSURANCE WORLD','102 OHIO AVE N LIVE OAK FL 32064',3863627283);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Awsome Installation','4696 LOWER ROSWELL RD MARIETTA GA 30068',7705657612);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A B & A TOWING & WRECKER SVC','PO BOX 154995 IRVING TX 75015',8175576433);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A B C Taxi Inc','47 N FAIRGROUND ST NE MARIETTA GA 30060',7704222927);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A B Construction','3454 MEADOW CHASE DR MARIETTA GA 30062',7705090301);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A B Duplicating Equipment Co','431 COMMERCE PARK DR SE MARIETTA GA 30060',7709718915);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A B PAINTING','3006 FAVOR PINES CT SW MARIETTA GA 30060',7704339076);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Bacon Yacht Charter','55 BOAT BASIN NEW YORK NY 10024',2128737558);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A BAILEY FLOWERS','1000 W ARKANSAS LN ARLINGTON TX 76013',8178040038);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A BAILEY FLOWERS','1000 W ARKANSAS LN ARLINGTON TX 76013',8178040038);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Beautiful Backyard By C Pool','2265 ROSWELL RD STE 100 MARIETTA GA 30062',7709843249);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Blessed Event Dj & Karaoke','2200 ROSWELL RD MARIETTA GA 30062',7705655113);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A BOX OUTLET','349 COBB PKWY N MARIETTA GA 30062',6789840797);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A BRIGHTER ORLANDO PRESSURE','PO BOX 221 WINTER PARK FL 32790',3216953553);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Broadway Towing 24 Hrs','6469 Broadway New York NY 10001',7187323953);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A C BAER','4800 BELLINGHAM DR MARIETTA GA 30062',7706455911);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Champion Kennel','983 F M 20 Bastrop TX 78602',5123211633);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Charles Mellen & Associates','4076 CHARRWOOD TRCE MARIETTA GA 30062',7706440000);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A CHILDS PLACE OF COBB','57 MERRITT ST SE MARIETTA GA 30060',7704271368);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Classy Flea','PO BOX 850 MARIETTA GA 30061',7705792555);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A CONSUMERS CHOICE','1706 LOWER ROSWELL RD MARIETTA GA 30068',7709736076);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Custom Pest Service Inc','152 SOUTH AVE SE STE 3 MARIETTA GA 30060',7704246073);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Delghtful Bitefull Catrg LLC','2235 SEWELL MILL RD MARIETTA GA 30062',7705917370);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A DIACHISHIN & ASSOC','PO BOX 369 NAPANOCH NY 12458',8456476514);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A G EDWARDS & SONS INC','1 DEPOT ST NE STE 100 MARIETTA GA 30060',7704250104);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Glass Act','3266 MITSY FOREST WAY NE MARIETTA GA 30068',7705090047);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Grade Inc','1823 BALDWIN FARMS DR MARIETTA GA 30068',7705874833);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A J Consultants & Associates','3080 BROOKVIEW DR MARIETTA GA 30068',7709771337);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A J R Inc','1225 JOHNSON FERRY RD MARIETTA GA 30068',7705653753);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A J R Inc','3101 ROSWELL RD MARIETTA GA 30062',7705658663);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A J R Inc','4819 LOWER ROSWELL RD MARIETTA GA 30068',7709731125);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A K DESIGN','897 FAWN WAY MARIETTA GA 30068',7703569127);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A LA MODE','71 MAIN ST CHAGRIN FALLS OH 44022',4402476200);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A LADYS COMPUTER MECHANIC','6062 UNIVERSITY AVE SAN DIEGO CA 92115',6195837226);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Little Enterprise LLC','2972 MONTVIEW DR SW MARIETTA GA 30060',7708030607);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A LOCKSMITH ALWAYES 24 HR','2174 KINRIDGE RD MARIETTA GA 30062',7702500984);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A M F Supply Inc','814 PICKENS INDUSTRIAL DR MARIETTA GA 30062',7708744115);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Monarch Enterprise','PO BOX 1518 MABLETON GA 30126',7704387094);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A NEW LIFE','1584 ROSWELL RD MARIETTA GA 30062',7703664045);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A O Smith Corporation','4001 Frederick Rd El Paso TX 79905',9156291600);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A OCEAN BLUE','2825 WENDY LN MARIETTA GA 30062',6785609887);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Oyelere Dr','1486 SOARING POINTE MARIETTA GA 30062',7704995033);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A P BEAUREGARD HARDWOOD & TILE','PO BOX 655 GLEN NH 3838',6033560081);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Passion For Pets LLC','2900 CREEK PARK DR MARIETTA GA 30062',7709716259);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Peachy Keen Plumbing Company','2770 WENDY LN MARIETTA GA 30062',7705796689);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Perfect Party Inc','3101 ROSWELL RD STE H MARIETTA GA 30062',7705655558);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A PLACE OF REFUGE FOR WOMEN','PO BOX 240695 MILWAUKEE WI 53224',4144766333);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Plus Insurance Agency Inc','3020 ROSWELL RD MARIETTA GA 30062',7705092331);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A PLUS QUALITY REMODELING SVC','3151 BUNKER HILL CIR MARIETTA GA 30062',4042711918);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Precision Secretarial S','San Diego 92124 San Diego CA 92101',8582927661);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A PRESIDENTIAL LIMOUSINE SVC','4550 WENDEN LN MARIETTA GA 30062',6784097959);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Priori Solutions Inc','3338 WOODSFIELD DR NE MARIETTA GA 30062',7709730347);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Psychic Reading','1653 LOWER ROSWELL RD MARIETTA GA 30068',7709711605);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Quality Pool Products Inc','614 COBB PKWY N MARIETTA GA 30062',7704197119);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Rembrant Reproduction I','2843 EVA LEE CT NE MARIETTA GA 30062',7709717998);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A SHEAR EDGE','RR 1 BOX 300 INTERVALE NH 3845',6033567734);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A SHEAR THING','RR 3 BOX 16 PARKERSBURG WV 26101',3044288787);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A SOUTHERN SECURITY CO','3186 LASSITER RD MARIETTA GA 30062',7707898886);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Staffing Solution Inc','732 CHEROKEE ST NE STE A MARIETTA GA 30060',6788870784);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A SUPERIOR CONTRACTING','1523 ROSWELL RD APT 416 MARIETTA GA 30062',6789733825);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A T & T','2370 WAKITA DR SE MARIETTA GA 30060',7704344036);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A T & T','2885 SURREY LN SW MARIETTA GA 30060',7704389234);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A T & T','4250 ROSWELL RD STE 300 MARIETTA GA 30062',7703212220);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A T & T WIRELESS','1197 JOHNSON FERRY RD MARIETTA GA 30068',7703212220);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A T LAWN CARE','17 JUDY DR SW MARIETTA GA 30060',7704328128);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Team Landscaping','750 WOODMONT DR MARIETTA GA 30062',7709717327);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A THOUSAND THANK YOUS','3655 BRISBANE DR MARIETTA GA 30062',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Top Realty','901 MILL STONE DR MARIETTA GA 30062',7703214757);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A TOWING CO','253 E END AVE NEW YORK NY 10128',2126168675);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Unique Sleep Shop Inc','220 COBB PKWY N STE 100 MARIETTA GA 30062',7704273382);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A V X Corporation','PO BOX 867 CONWAY SC 29528',8433474627);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Wealth of Health','3286 HICKORY BLUFF DR MARIETTA GA 30062',7709775596);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Wise Solution Inc','4612 VILLA CHASE DR NE MARIETTA GA 30068',7705794635);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A Wright Construction','635 BIRCHWOOD LN SW MARIETTA GA 30060',7708018697);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A&J Flowers & Gifts','326 ROSWELL ST SE MARIETTA GA 30060',6783542117);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A&L CONSTRUCTION','3422 WOODRUN TRL MARIETTA GA 30062',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A&P Enterprises Inc','1794 JAMES RAY DR SE MARIETTA GA 30060',6785081005);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A&P Landscaping & Lawn Care','2977 KAREN LN MARIETTA GA 30062',7709717572);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A&W Automotive Svc','1710 S COBB DR SE MARIETTA GA 30060',7704248033);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A-1 DUI & DEFENSIVE DRIVING','607 ROSWELL ST NE MARIETTA GA 30060',7704271911);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A-1 KEY & LOCK','819 HOWARD ST W LIVE OAK FL 32064',3863621170);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A-1 Lawn Maintenance','2622 N Beckley Rd De Soto TX 75115',9722241969);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A-1 Tattooing','669 ROSWELL ST NE MARIETTA GA 30060',7704265794);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A-1 TIRE & TOWING','PO BOX 105 DIMOCK PA 18816',5702783111);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A-AMERICAN SECURITY','PO BOX 37060 CLEVELAND OH 44137',4404426161);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A-List Inc','1334 BISON AVE NEWPORT BEACH CA 92660',9497605017);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A-PLUS UPHOLSTERY','2822 FORSYTH RD # 90 WINTER PARK FL 32792',4076788832);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A-TEAM LANDSCAPING','750 WOODMONT DR MARIETTA GA 30062',7703784945);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A/R Lenders Inc','977 BRICKLEBERRY LN MARIETTA GA 30062',7705786504);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A1 Action Cash Inc','431 PAT MELL RD SE MARIETTA GA 30060',7704330990);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A1 Auto Parts & Salvage','US Hgwy 1 Bunnell FL 32110',3864373438);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A1 Drywall & Acoustics','53 TATUM ST SW MARIETTA GA 30060',6787975599);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A1 Japanese Auto','1587 LOWER ROSWELL RD MARIETTA GA 30068',7705780982);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A1 Mini Store Inc','1925 S COBB DR SE MARIETTA GA 30060',7704365545);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('A2z Remodeling LLC','701 CREEKWOOD DR MARIETTA GA 30068',7705787676);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AA Atlanta Emergency Locksmith','180 HOLT RD NE MARIETTA GA 30068',7709710348);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AA HOLISTIC HEALTH CARE','PO BOX 174 MABLETON GA 30126',7708817564);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AA Screen Printing Supplier','1087 S MARIETTA PKWY SE MARIETTA GA 30060',7708500110);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AA Taxi Cabs','901 ROSWELL ST NE MARIETTA GA 30060',6782131523);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AAA ACCOUNTING PROFESSIONALS','2095 HARTFORD CT MARIETTA GA 30068',7705792070);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AAA Aiea Pain Relief Chiroprac','99 128 Aiea Heights Dr Aiea HI 96701',8084868585);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AAA ANDERSON HEATING & AIR','2100 ROSWELL RD MARIETTA GA 30062',4044560598);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AAA AUTO ELECTRIC','1302 HOWARD ST E LIVE OAK FL 32064',3863641206);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AAA CONSTRUCTION','214 VALLADOLID AVE LAREDO TX 78046',9567253805);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AAA Digital Imaging Inc','1529 ROSWELL RD MARIETTA GA 30062',7705780331);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AAA Home Buyers Guide','2100 ROSWELL RD STE 200C MARIETTA GA 30062',4045242001);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AAA LANGLEY-ST CLAIR SIGNS','2752 BRIDGEGATE TRCE NE MARIETTA GA 30068',7708279113);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AAA MINI STORAGE','PO BOX 229 SPENCER IN 47460',8128762990);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AAA NON-PROFIT HIV/STD TESTING','140 LACY ST NW STE C MARIETTA GA 30060',7700001111);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AAA NON-PROFIT HIV/STD TESTING','790 CHURCH ST NE STE 200 MARIETTA GA 30060',7700001111);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AAA NORTHEAST PENN','RR 7 BOX 7132 MONTROSE PA 18801',5702781551);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AAA Rolands Coiffures Ltd','Park Rd Shop Ctr Charlotte NC 28209',7045230343);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AAA TRANSMISSIONS','PO BOX 1603 CRAB ORCHARD WV 25827',3042527184);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AAA Viva Moving Inc','5 53rd St B Brooklyn NY 11232',7188360407);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AAAA Automotive Repair Inc','476 COBB PKWY N MARIETTA GA 30062',6785818488);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AAAA Landscaping','201 CHEROKEE ST NE MARIETTA GA 30060',4042852818);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aaabco Lock & Key Inc','4350 CORNWALLIS CT NE MARIETTA GA 30068',7709719453);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AAFES - GAS STATION','P2140 NASH BLVD FORT DRUM NY 13602',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aagard & Associates Cnstr Co','2081 BISHOP CREEK DR MARIETTA GA 30062',7709926668);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AAMODT INC','PO BOX 1208 BONNERS FERRY ID 83805',2082673269);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aaron Brothers Inc','1197 JOHNSON FERRY RD MARIETTA GA 30068',6782850800);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AARON COMMUNICATIONS','4381 KARLS GATE DR MARIETTA GA 30068',7703218746);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AARON LAMP','483 SUMNER ST NULL AKRON OH 44304',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AARON MARKETING','1824 LOWER ROSWELL RD MARIETTA GA 30068',7709770550);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aaron Rents Inc','1710 COBB PKWY S MARIETTA GA 30060',7708189416);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aaron Rents Inc','1736 COBB PKWY S MARIETTA GA 30060',7709556923);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aaron Spelling Production','Van Nuys CA 91411 Sherman Oaks CA 91411',8187782330);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AARONS SALES & LEASE OWNERSHIP','180 COBB PKWY S MARIETTA GA 30060',7709197668);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AARONS SALES & LEASE OWNERSHIP','905 HIGHWAY 9 BYP E LANCASTER SC 29720',8033135988);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AB GALLERY','156 CHURCH ST NE MARIETTA GA 30060',6782908747);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AB Restaurant Corp','180a Main St Fort Lee NJ 7024',2014615151);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AB Sales Co Inc','PO BOX 6488 MARIETTA GA 30065',7709736243);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Abacus Employment Inc','1800 ROSWELL RD STE 3020 MARIETTA GA 30062',7705092490);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABBA TOWING','PO BOX 154995 IRVING TX 75015',9727171445);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Abba Towing','PO BOX 154995 IRVING TX 75015',9727171445);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABBACOR LIMITED','1953 RIVER FOREST DR MARIETTA GA 30068',7705873440);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Abbe General Contractor','San Diego 92117 San Diego CA 92117',6192768133);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Abbey David Design','5320 W BANK DR MARIETTA GA 30068',7706509782);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABBEY MINI STORAGE','607 GOLDKIST BLVD SW LIVE OAK FL 32064',3863645300);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Abbott C & I LP','605 OAKLEDGE DR NW MARIETTA GA 30060',7704277500);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABC','RR 6 BOX 6022 MONTROSE PA 18801',5702789824);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABC Mailing Systems','850 PICKENS INDUSTRIAL DR MARIETTA GA 30062',7704247743);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABC Recycling','595 COBB PKWY N MARIETTA GA 30062',6782909866);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABC Wood Products Inc','470 N SESSIONS ST NW MARIETTA GA 30060',7704265747);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABC-TAXI','47 N FAIRGROUND ST NE STE 4 MARIETTA GA 30060',7704222927);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Abcom Inc','2020 AIRPORT IND PARK DR SE MARIETTA GA 30060',7709569226);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABCOM INC','2050 AIRPORT INDUSTRIAL PARK D MARIETTA GA 30060',7709569226);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Abconcepts Inc','3020 ROSWELL RD STE 200 MARIETTA GA 30062',7704101191);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABDULRAHMA ALDOSSARI','142 ELIZABETH PKWY NULL AKRON OH 44304',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Abercrombie & Fitch Co','4479 ROSWELL RD RM 800 MARIETTA GA 30062',7709717124);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABERCROMBIE LAND SVC','3387 SEWELL MILL RD MARIETTA GA 30062',4048639190);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Abernathy Design','3313 EMORY DR MARIETTA GA 30062',7709775007);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABG CLEANING SVCS','1051 CLUBLAND CT MARIETTA GA 30068',7705793291);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABISON CO','148 TIMBER CREEK LN SW MARIETTA GA 30060',7704320301);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Abitibi Consolidated Sls Corp','1509 JOHNSON FERRY RD MARIETTA GA 30062',7709733358);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Abl Management','1100 S MARIETTA PKWY SE MARIETTA GA 30060',7704229121);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Able Asphalt & Paving Co','PO BOX 1270 HIRAM GA 30141',7704247937);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Able Construction Inc','15 N MAIN ST FRANKFORT OH 45628',7407755666);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABLE CONSTRUCTION INC','15 MAIN ST FRANKFORT OH 45628',7407755666);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABLE DISTRIBUTORS INC','96-1276 WAIHONA ST STE 118 PEARL CITY HI 96782',8084566600);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABLE FAST PRINTERS','1230 JOHNSON FERRY PL MARIETTA GA 30068',7709719032);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Able Fast Printers','1230 JOHNSON FERRY PL MARIETTA GA 30068',7709719032);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Able Heating Air','2930 LAKEMONT DR SW MARIETTA GA 30060',7704389628);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Able Investigations LLC','1401 JOHNSON FERRY RD MARIETTA GA 30062',7707899250);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Able Plastics Inc','3700 ROSWELL RD MARIETTA GA 30062',7705651522);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Able Real Estate Inc','2100 ROSWELL RD MARIETTA GA 30062',7709777017);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABPA','PO BOX 819015 DALLAS TX 75381',9724246269);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Abra Inc','1770 COBB PKWY S MARIETTA GA 30060',7709561134);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABRACADABRA','5184 TALL OAK DR MARIETTA GA 30068',7709929843);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Abracdbra Crses Fmly Vacations','1735 ROSWELL RD STE 100 MARIETTA GA 30062',7705098080);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Abrakadoodle','2663 JOHNSON FERRY RD MARIETTA GA 30062',7705799800);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABRAMS INDUSTRIES INC','PO BOX 724728 ATLANTA GA 31139',7709530304);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Abrasive Suppliers Company','PO BOX 70052 MARIETTA GA 30007',7709937258);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABREGO TRUCKING SVC & AUTO','PO BOX 3038 MCALLEN TX 78502',9563160736);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABREGO TRUCKING SVC & AUTO SLS','PO BOX 3038 MCALLEN TX 78502',9563164409);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABS PARTNERS REAL ESTATE','915 BROADWAY ABS PARTNERS REAL NEW YORK NY 10010',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Absolute Business Works Inc','4558 WENDEN LN MARIETTA GA 30062',7705871565);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Absolute Hair','612 SW 3RD ST STE C LEES SUMMIT MO 64063',8162467467);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABSTRACT & TITLE','111 HOWARD ST E LIVE OAK FL 32064',3863622717);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Abstract Electric Corp','111 N MARIETTA PKWY NE MARIETTA GA 30060',6784292080);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Abundant Harvst Hme Brewg/Wine','Vestal Plz Binghamton NY 13903',6077294798);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABUNDANT HEALTH & WELLNESS','2058 LOWER ROSWELL RD MARIETTA GA 30068',6784452746);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Abundant Health & Wellness Ctr','2058 LOWER ROSWELL RD MARIETTA GA 30068',6785608815);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ABUNDANT LIFE MASSAGE & CHIRO','2231 ROBINSON RD NE STE C MARIETTA GA 30068',7709735775);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Abundant Life Wellness Center','2231 ROBINSON RD NE STE C MARIETTA GA 30068',7709735775);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Abundnt Hlth Neuromusclr Thrpy','612 SW 3RD ST STE B LEES SUMMIT MO 64063',8165244230);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AC DC TAVERN','905 HELVENSTON ST SE LIVE OAK FL 32064',3863643291);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AC Help Care Services','445 WINDY HILL RD SE MARIETTA GA 30060',7704344643);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AC Miller Corporation','3251 RUNNING CEDAR DR MARIETTA GA 30062',7705095535);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACACIA ANALYTICS','3624 HIGH GREEN DR MARIETTA GA 30068',7705657630);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Acacia Jewelry','91 1401 Frt Wver Rd A10 Ewa Beach HI 96706',8086854714);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Academic Solutions Inc','4220 SHALLOWFORD RD MARIETTA GA 30062',7706497874);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACADEMY FINANCIAL SVC','551 JOHNSON FERRY RD MARIETTA GA 30068',6785600379);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Academy Locksmith','W Sunset Blvd N Los Angeles CA 90028',3234641117);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Academy Locksmith','W Sunset Blvd N Los Angeles CA 90028',3234641117);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACADEMY ROOFING INC','200 COBB PKWY N MARIETTA GA 30062',7704261131);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACADEMY SPORTS OUTDOORS','N LOOP 1604 W SAN ANTONIO TX 78258',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Acadia Coffee Service Inc','1165 ALLGOOD RD STE 17 MARIETTA GA 30062',7704218003);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACADIA COFFEE SVC INC','1165 ALLGOOD RD MARIETTA GA 30062',7709737207);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACADIA COFFEE SVC INC','819 PICKENS INDUSTRIAL DR STE 13 MARIETTA GA 30062',7704218003);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACC Auto Sales','1784 LOWER ROSWELL RD MARIETTA GA 30068',7709738933);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACCELERATED CLEANING SYSTEMS','1085 COBB PKWY S MARIETTA GA 30060',7705148448);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Accelerated Cleaning Systems I','1085 COBB PKWY S MARIETTA GA 30060',7705148448);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Accent Awnings Inc','508 COMMERCE PARK DR SE MARIETTA GA 30060',7709980222);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Accent Ceramics','712 LAWRENCE ST NE MARIETTA GA 30060',7704245500);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Accent On Health','1501 JOHNSON FERRY RD MARIETTA GA 30062',7703211569);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Accent On Pet Care Inc','1343 GRESHAM RD MARIETTA GA 30062',7709710476);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Accent Painting','2341 MONTEREY DR NE MARIETTA GA 30068',7709733742);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Accentum Tech Partners LLC','PO BOX 681443 MARIETTA GA 30068',6785768140);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACCESS JAPAN INC','360 WILLOW GLEN DR MARIETTA GA 30068',4042613317);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACCESS REHABILITATION','50 PLAZA WAY NW MARIETTA GA 30060',7707926562);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Accord Services LLC','127 CHURCH ST NE STE 200 MARIETTA GA 30060',7704210191);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Accounting Consultants Cobb','3901 ROSWELL RD STE 130 MARIETTA GA 30062',7704250518);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACCOUNTING CONSULTANTS-COBB','3901 ROSWELL RD STE 130 MARIETTA GA 30062',7709735500);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Accounting Management Inc','1744 ROSWELL RD MARIETTA GA 30062',7709731358);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Accumed Home Health','2809 LASSITER RD MARIETTA GA 30062',7705874505);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Accurate Business Service','228 PAT MELL RD SW MARIETTA GA 30060',7704368955);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Accurate Electronics Inc','PO BOX 12076 DURHAM NC 27709',9195582200);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Accurate Insurance Marketing','909 COBB PKWY N STE 106 MARIETTA GA 30062',7709719981);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Accutemp Heating-Cooling Inc','869 PICKENS INDUSTRIAL DR MARIETTA GA 30062',7707951061);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Acd Mine','Hgwy 17 A Moncks Corner SC 29461',8437616269);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Ace Auto Parts Towing & RPS','1550 W OAK DR MARIETTA GA 30062',7704193331);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Ace Commercial Ceaning Sv','2860 MEADOW DR MARIETTA GA 30062',7706420799);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Ace Draperies Company','4948 LOWER ROSWELL RD MARIETTA GA 30068',7703211312);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACE ELECTRICAL SVC INC','436 WALLACE RD MARIETTA GA 30062',7709718767);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Ace Health Care Training Inst','8 S MORRIS ST DOVER NJ 7801',9733667171);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACE INA HOLDINGS INC','1601 CHESTNUT ST PHILADELPHIA PA 19103',2156401000);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACE INSURANCE','903 ROSWELL ST NE MARIETTA GA 30060',6783547930);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACE MANAGEMENT SVC','1380 FAIR OAKS AVE SE MARIETTA GA 30060',7708423733);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACE MINI STORAGE','300 WADE ST SILSBEE TX 77656',4093857973);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACE ROOFING','10242 ARAPAHOE DR INDIANAPOLIS IN 46235',3176266741);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACE ROOFING','10242 ARAPAHOE DR INDIANAPOLIS IN 46235',3178952964);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Ace Signs Inc','93 BARBER RD SE MARIETTA GA 30060',7704197971);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Ace Special Tours','PO BOX 4982 MARIETTA GA 30061',7704242722);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aces Design & Build','615d E Abram St 500 Arlington TX 76010',8176897573);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACG','550 GRAMERCY DR NE MARIETTA GA 30068',7709713722);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Achieve Global Inc','3031 GANT QUARTERS CIR MARIETTA GA 30068',6785604798);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACKERMAN-JOHNSON SQUARE LLC','1509 JOHNSON FERRY RD MARIETTA GA 30062',6783849270);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACKUE INTERNATIONAL','1165 ALLGOOD RD MARIETTA GA 30062',7705658557);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACORDIA','PO BOX 1389 DANVILLE WV 25053',3043697239);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Acousti Interior Contractors','1420 WHITE CIR NW MARIETTA GA 30060',7704259028);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Acreide of Sicily','725 Rte 32 Tillson Rosendale NY 12472',8456583835);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACROSS ATLANTA INSURANCE','1800 ROSWELL RD MARIETTA GA 30062',6785604663);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Acrsnet Inc','1751 LOWER ROSWELL RD MARIETTA GA 30068',7705781312);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Acsi Web Hosting','28 WINTERS ST SE MARIETTA GA 30060',7704293995);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Act 3 Productions Inc','1810 SHELBURNE RDG MARIETTA GA 30068',7705526670);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACTION APPRAISALS','3162 JOHNSON FERRY RD MARIETTA GA 30062',7705921112);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACTION AUTO GLASS','4701 DISTRIBUTION CT STE 5 ORLANDO FL 32822',4075999234);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACTION CRITTER & BEE CONTROL','3365 CREEK HOLLOW DR MARIETTA GA 30062',7709734414);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Action International','4994 LOWER ROSWELL RD MARIETTA GA 30068',7706496730);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACTION REAL ESTATE MANAGEMENT','1650 BARNES MILL RD MARIETTA GA 30062',6782909174);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Action Shredding LLC','552 COBB PKWY S STE B MARIETTA GA 30060',7707928131);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACTION TRANSMISSION','4696 LOWER ROSWELL RD MARIETTA GA 30068',6785606615);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Action Transmission Inc','1603 OLD HUNTERS TRCE MARIETTA GA 30062',6785606615);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACTION WELDING & FABRICATING','PO BOX 100 PORT O CONNOR TX 77982',3619832984);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Actiontrax Inc','2729 TRITT SPRINGS DR NE MARIETTA GA 30062',7705790322);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACTIVE AUTO INTL INC','2832 COUNTY ROUTE 78 # 6 MIDDLETOWN NY 10940',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACTIVE XL','1704 BARRINGTON CIR MARIETTA GA 30062',7709735726);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Activecare Health Center','3055 JOHNSON FERRY RD MARIETTA GA 30062',7705527008);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Activelan Development LLC','2116 KINRIDGE RD MARIETTA GA 30062',7703106075);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ACTPENSEL INC','109 ANDERSON ST SE STE 103 MARIETTA GA 30060',7704197007);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Actpensel Inc','111 N MARIETTA PKWY NE MARIETTA GA 30060',7704197007);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Acupuncture & Wellness Ce','1000 JOHNSON FERRY RD MARIETTA GA 30068',6785607978);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Ad & D Consulting R & D Co','1153 COLONY DR MARIETTA GA 30068',7709927515);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Ad Nov Group','519 JOHNSON FERRY RD MARIETTA GA 30068',7703214747);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADA FRAMING & ART','2931 ROBINSON RD NE MARIETTA GA 30068',7705796744);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADAM BARDELANG','388 KLING ST NULL AKRON OH 44311',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADAMARK JEWELERS & SILVERSMITH','4400 ROSWELL RD MARIETTA GA 30062',7705656558);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Adamark Jewelers Inc','4400 ROSWELL RD STE 136 MARIETTA GA 30062',7705656558);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Adams Antonia','29 ASHTON WOODS DR MARIETTA GA 30068',7705656791);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Adams Construction Services','519 JOHNSON FERRY RD MARIETTA GA 30068',7703215340);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADAMS COUNTY SENIOR CITIZENS','210 N WILSON DR NULL WEST UNION OH 45693',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADAMS LAW FIRM','232 ALEXANDER ST SE MARIETTA GA 30060',6785815050);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Adams Painting Wallcove Inc','1195 MOUNT BETHEL DR MARIETTA GA 30068',7703210000);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADAMS ANTIQUARIAN BOOKS','PO BOX L HOBART NY 13788',6075389080);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Adaptive Learning Cntr Infnts','2509 POST OAK TRITT RD MARIETTA GA 30062',4048431893);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADAPTIVE LEARNING CTR','2509 POST OAK TRITT RD MARIETTA GA 30062',7705093909);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Adaptive Solutions Inc','3162 JOHNSON FERRY RD MARIETTA GA 30062',7705093206);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Adar Shalva','17 31 SEAGIRT BLVD INWOOD NY 11096',7184713700);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADB Services Inc','3162 JOHNSON FERRY RD MARIETTA GA 30062',6789905400);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Adco Holdings Inc','4343 SHALLOWFORD RD MARIETTA GA 30062',4048166813);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Add On Energy L L C','1165 ALLGOOD RD STE 6 MARIETTA GA 30062',7709774248);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADD ONE MARKETING','3207 TEABERRY WAY MARIETTA GA 30068',7703216372);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Add Treatment & Research Ctr','5400 L B Johnson Fwy 93 Dallas TX 75240',9729807488);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADD VANTAGE COACHING','3339 WOODSFIELD DR NE MARIETTA GA 30062',6785606512);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Added Touch Catering Inc','736 JOHNSON FERRY RD MARIETTA GA 30068',7703219592);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADDESS CHIROPRACTIC','1000 JOHNSON FERRY RD MARIETTA GA 30068',7703216300);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADDIAN INC','829 PICKENS INDUSTRIAL DR MARIETTA GA 30062',6783549001);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADDINGTONS BOAT & CAMPER SLS','PO BOX 340 RICHLANDS VA 24641',2769644927);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Addone Marketing Services LLC','3207 TEABERRY WAY MARIETTA GA 30068',7703219823);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADE BUILDERS INC','PO BOX 6415 MARIETTA GA 30065',7704223894);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADEBOYE & ASSOC','244 S FAIRGROUND ST SE MARIETTA GA 30060',6783543554);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Adept Landscaping & Maintance','240 CRANFILL RD SE MARIETTA GA 30060',7704241519);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Adeptmax Corporation','8111 L B Johnson Fwy 65 Dallas TX 75251',9729915000);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aderhold Properties Inc','111 N MARIETTA PKWY NE MARIETTA GA 30060',7704224344);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADI Performance Inc','PO BOX 70083 MARIETTA GA 30007',7706400840);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Adirondack Cab Co','Montcalm Rd Ticonderoga NY 12883',5185852222);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADIRONDACK COMMUNITY COLLEGE','640 BAY RD NULL QUEENSBURY NY 12804',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADIRONDACK CORRECTIONAL FCLTY','PO BOX 110 RAY BROOK NY 12977',5188911343);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADIRONDACK LIFE MAGAZINE','PO BOX 410 JAY NY 12941',5189462191);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADIRONDACK PARK AGENCY','PO BOX 99 RAY BROOK NY 12977',5188914050);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADIRONDACK ROCK & RIVER GUIDE','PO BOX 219 KEENE NY 12942',5185762041);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADKINS AUTO PART','PO BOX 444 CRAIGSVILLE WV 26205',3047425535);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADKINS TIRE CO','PO BOX 190 CRAIGSVILLE WV 26205',3047425830);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Adler & Associates','170 11 Beach Blvd Ste 900 Huntingtn Bch CA 92648',7145965632);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Adler Consulting Inc','1401 JOHNSON FERRY RD MARIETTA GA 30062',7706456508);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADM Group','1251 PARTRIDGE WAY MARIETTA GA 30062',7705651894);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADMIRALS INN','5651 CYPRESS GARDENS RD WINTER HAVEN FL 33884',8633245950);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Adonai Holdings Inc','1100 JOHNSON FERRY RD MARIETTA GA 30068',7703218928);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADORABLE KIDS','2100 ROSWELL RD STE 200C MARIETTA GA 30062',7709198775);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADP Statewide Insurance','10 N SUSSEX ST DOVER NJ 7801',9738911055);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Adr Window & Door Inc','748 LAWRENCE ST NE MARIETTA GA 30060',4042570909);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADS ROAD SIDE SVC','163 HAMILTON TRCE MARIETTA GA 30068',4044543623);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Adult & Adolescent Psychology','2000 Southbridge Pkwy A Birmingham AL 35209',2058713919);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADULT MEDICINE OF MARIETTA PC','790 CHURCH ST NE MARIETTA GA 30060',6787978201);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Adult Parole ADM Neb','Folsom & W Prospector Pl Lincoln NE 68509',4024795771);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Adult Probation Parole NC Div','132 RAFTERS LN WARRENTON NC 27589',2522575679);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aduro Lighting LLC','23 59 Borden Ave New York NY 10101',6465363495);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADVANCE AUTO PARTS','111 COBB PKWY N MARIETTA GA 30062',7709192480);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADVANCE AUTO PARTS INC','RR 4 BOX 320 PHILIPPI WV 26416',3044572040);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advance Digital Inc','4235 MERCHANTS WALK DR MARIETTA GA 30068',7709719005);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advance Realty Enterprises','109 14 Van Wick Expy S Ozone Park NY 11420',7183222074);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADVANCE REHAB','702 HIGHWAY 82 W NULL GREENWOOD MS 38930',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advance Srgical Group NW GA PC','800 CANTON RD NE MARIETTA GA 30060',7704244328);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advance Stores Company Inc','111 COBB PKWY N MARIETTA GA 30062',7702188632);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advance Stores Company Inc','2850 Sheirden Dr Buffalo NY 14201',7168362751);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advance Stores Company Inc','1420 S COBB DR SE MARIETTA GA 30060',7709192270);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advance Stores Company Inc','8270 FM 78 San Antonio TX 78244',2106627889);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADVANCED AESTHETIC SURGERY PC','711 CANTON RD NE STE 400 MARIETTA GA 30060',7704250118);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advanced Aesthetic Surgery PC','684 CANTON RD NE MARIETTA GA 30060',7707715151);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADVANCED BREAST CARE','790 CHURCH ST NE STE 410 MARIETTA GA 30060',7704221988);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advanced Building Systems','73 62 Remcom Cir El Paso TX 79912',9152252260);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADVANCED COUNSELING SVC','4343 SHALLOWFORD RD MARIETTA GA 30062',6785859260);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advanced Custom Cmpt Solutions','2976 SEWELL MILL RD MARIETTA GA 30062',7709714070);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advanced Digital Systems Inc','PO BOX 12076 DURHAM NC 27709',9194854819);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advanced Drmtlogy & Dermatlc S','41 61 Kssena Blvd Ste 5a Flushing NY 11355',7188869000);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADVANCED ENGNRING SOLUTIONS','1468 BRENTWOOD DR MARIETTA GA 30062',7705786490);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADVANCED FITNESS CTR','702 HIGHWAY 82 W GREENWOOD MS 38930',6624533706);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADVANCED HOME HEALTH CARE','9370 SW 72ND ST MIAMI FL 33173',3054125553);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advanced Inst For Analytic Psy','178 10 Wexford Ter Jamaica NY 11432',7186581137);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advanced Kitchens LLC','2986 JOHNSON FERRY RD MARIETTA GA 30062',7705875722);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advanced Leasing Bus Ofc','PO BOX 9007 MARIETTA GA 30065',7704200060);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advanced Logic Solutions Inc','1000 JOHNSON FERRY RD MARIETTA GA 30068',7705786771);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADVANCED MACHINING TECH CO','1400 HOWARD ST E LIVE OAK FL 32064',3869618441);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advanced Nurseries Inc','661 S COBB DR SE MARIETTA GA 30060',7708749003);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADVANCED NURSING SOLUTIONS','220 PINE AVE N OLDSMAR FL 34677',8133410730);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADVANCED OBESITY SURGERY CTR','780 CANTON RD NE STE 320 MARIETTA GA 30060',7709197050);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADVANCED PAIN MANAGEMENT','909 COBB PKWY N MARIETTA GA 30062',7707941955);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADVANCED POWER SOLUTIONS INC','5415 LAKE HOWELL RD WINTER PARK FL 32792',4076449889);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advanced Pressure & Gutter Clg','1954 ROSWELL RD MARIETTA GA 30062',7709776653);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advanced Rehab Services Inc','413 INDIAN HILLS TRL MARIETTA GA 30068',7709733466);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advanced Rehabilitation LLC','702 HIGHWAY 82 W GREENWOOD MS 38930',6624555010);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADVANCED SERVICES-MEAD ROYAL','1614 LOWER ROSWELL RD MARIETTA GA 30068',7709735152);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advanced Spt Physcl Therapy PC','176 60 Un Ste 195 Fresh Meadows NY 11366',7188209300);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advanced Stone Imports Inc','3762 BACCURATE WAY MARIETTA GA 30062',7705524836);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advanced Storage & Retrieval S','4840 FOX GLN MARIETTA GA 30068',7709739976);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADVANCED SURGICAL GROUP-NW GA','780 CANTON RD NE MARIETTA GA 30060',7707941995);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advanced Telephonics Inc','244 W 49th St 250 New York NY 10019',2127642248);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advanced Theater Solutions','2350 MONTEREY DR NE MARIETTA GA 30068',6783577164);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advaned Home Inspections','445 GUILFORD CIR MARIETTA GA 30068',7709777116);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advantage Dental Inc','123 MARBLE MILL RD NW MARIETTA GA 30060',7704997756);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADVANTAGE HOME MORTGAGE','1838 BISHOPS GREEN DR MARIETTA GA 30062',6782135626);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advantage Media Services','23250 Stonerdge Dr N 16 Waukesha WI 53188',2625226288);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advantage One Systems','1735 HOLCOMB LAKE RD MARIETTA GA 30062',7705788595);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advantage Pest Control Inc','4939 LOWER ROSWELL RD MARIETTA GA 30068',7705783882);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advantage Real Estate','612 SW 3RD ST STE D LEES SUMMIT MO 64063',8165546700);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advent Group Inc','2079 KINSMON DR MARIETTA GA 30062',7705872405);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Adventure West Media','5443 WOODBERRY CIR MARIETTA GA 30068',7706456709);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Adventures LP','62 Chelsea Piers 301 New York NY 10011',2123366450);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADVERTISING GIFT SPECIALTY INC','1698 LOWER ROSWELL RD MARIETTA GA 30068',7705656785);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADVERTISING IMPACT INC','5693 QUINCE RD MEMPHIS TN 38119',9016851966);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advertising Insights Inc','3712 BACCURATE WAY MARIETTA GA 30062',7705941466);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Advertising/Marketing Assoc','5280 MILL RUN DR MARIETTA GA 30068',7705940790);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ADVISORS TITLE SVC','9370 SW 72ND ST MIAMI FL 33173',3055967779);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aegis Holding LP','4103 AUDUBON DR MARIETTA GA 30068',7705653269);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aegis Partners Inc','332 GREENFIELD CT MARIETTA GA 30068',7705655923);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aemir Press','200 N FAIRGROUND ST NE MARIETTA GA 30060',7704278973);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aero Surveys of Georgia Inc','PO BOX 6036 MARIETTA GA 30065',7704221611);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aero Systems Engineering Inc','PO BOX 4426 MARIETTA GA 30061',7704234200);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AERONAUTICS DEPT','133 STATE ST STE 2 MONTPELIER VT 5633',8028282833);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AEROPOSTALE INC','87 MEDLEY CENTRE PKWY ROCHESTER NY 14622',5854677320);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aerosoles Shoes','4475 ROSWELL RD MARIETTA GA 30062',6785603311);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AERUS ELECTROLUX','595 ROSWELL ST NE MARIETTA GA 30060',7704246613);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AERUS ELECTROLUX','PO BOX 358 MALONE NY 12953',5184834060);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aesthetic Orthodontic Care','4939 LOWER ROSWELL RD MARIETTA GA 30068',7705096910);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aesthetics Atlanta','2155 POST OAK TRITT RD MARIETTA GA 30062',7705791850);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aet Advisors LLC','4875 OLDE TOWNE PKWY MARIETTA GA 30068',7705786967);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AETNA INSULATED WIRE','2265 ROSWELL RD MARIETTA GA 30062',7705092280);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AETNA LIFE INSURANCE COMPANY','1813 SPRING GARDEN ST DUAL 2 GREENSBORO NC 27403',336379200);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AETNA- PAMELA CARTER','2484 9TH ST NULL CUYAHOGA FALLS OH 44221',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Affek Locksmith','95 W 9TH ST NEW YORK NY 10011',9175912054);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Affiliated Marketing Inc','1232 WOODLAWN DR NE MARIETTA GA 30068',7709715191);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AFFINIA','2265 ROSWELL RD MARIETTA GA 30062',7705094874);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AFFINITY LOGISTICS CORP','533 JOHNSON FERRY RD STE 400 MARIETTA GA 30068',7705795652);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Affinity Logistics Corporation','533 JOHNSON FERRY RD MARIETTA GA 30068',7705795652);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Affordable Blinds and More','3760 RIVARIDGE DR MARIETTA GA 30062',4043768820);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Affordable Cnstr Fin LLC','2959 CHRISTOPHERS CT MARIETTA GA 30062',4044276290);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AFFORDABLE HOME FUNDING','533 JOHNSON FERRY RD MARIETTA GA 30068',7705651288);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AFFORDABLE LAWNS','396 CRANFILL RD SE MARIETTA GA 30060',7704364590);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Affordable Lawns','396 CRANFILL RD SE MARIETTA GA 30060',7704364590);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Affordable Medical Resources','1159 MONTE DR MARIETTA GA 30062',7703216142);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Affordable Office Solutions','1841 BISHOPS GREEN DR MARIETTA GA 30062',7709718095);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AFFORDABLE PIANOS','22 E MAIN ST MC GRAW NY 13101',6078368600);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Affordable Printing','Alapa St Ste 1 Kailua Kona HI 96740',8083298100);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AFGE','PO BOX 27077 NAS/JRB TX 76127',8173770447);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AFGE LOCAL 2367','667 RUGER RD AFGE LOCAL 2367 WEST POINT NY 10996',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AFI GY STUDIOS','4075 AUDUBON DR MARIETTA GA 30068',4045209232);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AFJ LANDSCAPE & MAINTENANCE','2105 WINDSTREAM TRCE SW MARIETTA GA 30060',7704345107);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Afk Enterprises Inc','86 N FAIRGROUND ST NE MARIETTA GA 30060',6782909455);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AFRICAN GRADE EXPRESS','N BECKLEY AVE DESOTO TX 75115',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AFRICAN IMPORTS','2309 JOMARC WAY MARIETTA GA 30062',4045368115);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Afrida Deli Grocery Inc','120 3 Jamaica Ave St Jamaica NY 11418',7188461020);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aftermarket Partners Inc','San Diego 92131 San Diego CA 92101',8585499808);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AFTON JEWELERS','PO BOX 8194 CORPUS CHRISTI TX 78468',3619928786);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AG Brown & Sons Inc','3289 CHESTNUT OAKS DR MARIETTA GA 30062',7709710582);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AGA VENTUE V','488 KENNESAW AVE NW MARIETTA GA 30060',7704206587);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Agape Home Health','520 W ATLANTA ST SE MARIETTA GA 30060',7704290088);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Agape Home Health','520 W ATLANTA ST SE MARIETTA GA 30060',7704290088);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Agape Mortgage Service','1531 ROSWELL RD MARIETTA GA 30062',7703218673);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AGENT INC','3606 43RD AVE LONG ISLAND CITY NY 11101',7183612072);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Agi Home Inspections LLC','5485 LOWER ROSWELL RD MARIETTA GA 30068',7709925455);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Agi Marketing Group','PO BOX 5329 ATLANTA GA 31107',6783618136);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AGI SCHUTZ MERCHANDISING','3823 SENTRY XING MARIETTA GA 30068',7705651252);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Agl 4 Enterprises','2679 TRITT SPRINGS TRCE NE MARIETTA GA 30062',6783628163);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AGM','2255 PINE WARBLER WAY MARIETTA GA 30062',7705095371);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Agnt Insurance & Fincl Svcs','347 N MARIETTA PKWY NE MARIETTA GA 30060',6782907777);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Agricultural Systems Co Inc','PO BOX 271 MESILLA NM 88046',5052334813);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Agrotain','11163 STONEWOOD DR GERMANTOWN WI 53022',2622570870);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AGUA DULCE BAPTIST CHURCH','PO BOX 296 AGUA DULCE TX 78330',3619982561);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Agudelo Alvaro Ins','2200 ROSWELL RD MARIETTA GA 30062',7705798868);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Agurkis Northington & Rains','1916 WICKS RIDGE LN MARIETTA GA 30062',7703950608);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AGWAY ENERGY PRODUCTS','E MAIN MALONE NY 12953',5184832710);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Ah Painting','570 FAVORWOOD DR SW MARIETTA GA 30060',7703199752);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Ahl Group Inc','37 SPRING DR SE MARIETTA GA 30060',7707951444);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Ahlberg Engineering Inc','525 WEBB INDUSTRIAL DR MARIETTA GA 30062',7709199968);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aho and Barbat Advg & Mktg','163 SOUTH AVE SE MARIETTA GA 30060',7704255598);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aiea Dental Associates','99 128 Aiea Hts 203 Aiea HI 96701',8084876451);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AIG FINANCIAL ADVISORS','3086 ABERDEEN CT MARIETTA GA 30062',4049440526);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aiken-Wilson & Co','PO BOX 13715 ATLANTA GA 30324',4046681138);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aikonhome Properties Group','3667 WYNTERING TRL MARIETTA GA 30068',6785602334);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aim Marble & Granite LLC','1819 LOWER ROSWELL RD MARIETTA GA 30068',7705792466);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aim Services Inc','Medical Dr San Antonio TX 78229',2105689721);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aimco Properties L P','1650 BARNES MILL RD MARIETTA GA 30062',7704230271);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AIMEE T CASSINELLI DDS','810 CANTON RD NE STE D MARIETTA GA 30060',7704228264);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Ainokea Hawaii LLC','98 1005 Mnalua Rd Ste 823 Aiea HI 96701',8084865214);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Air Conditioning Htg Appl Svcs','5415 Lake Howell Rd 200 Winter Park FL 32792',4075799734);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Air Conditioning Unlimite','98 2013 Kaahumanu St Honolulu HI 96819',8085909266);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Air Express Atlanta','1155 ALLGOOD RD STE 5 MARIETTA GA 30062',6785940014);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AIR NATIONAL GUARD-ATLANTA','1388 FIRST ST MARIETTA GA 30060',7709194766);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Air Serv Group','1155 ALLGOOD RD STE 6 MARIETTA GA 30062',6785603633);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Air Span Wireless LLC','PO BOX 70784 MARIETTA GA 30007',7709772593);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Air Specialists Inc','PO BOX 4185 MARIETTA GA 30061',7704261722);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AIR SPECIALISTS INC','598 KIRK RD NW MARIETTA GA 30060',7704261813);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Air Techniques Inc','2999 JOHNSON FERRY RD MARIETTA GA 30062',7705187200);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AIR TECHNIQUES INC SAMPLING','1724 NEKOMA ST MARIETTA GA 30068',7709777525);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AIR WELD INC','PO BOX 3095 LAREDO TX 78044',9567221960);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Airbrush Tans By Sun Spray','3000 JOHNSON FERRY RD MARIETTA GA 30062',7709264460);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aircraft Mint Lgstics Svcs LLC','3345 KEENLAND RD MARIETTA GA 30062',7709773085);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aircrew Taxes','58 S PARK SQ NE MARIETTA GA 30060',7707959799);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Airforce Air Conditioning Inc','Chelsea Pier 60 Ste 6013 New York NY 10011',2123367777);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AIRGAS SOUTH','1088 ATLANTA RD SE MARIETTA GA 30060',7704221544);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Airline Ticket Counter Inc','4005 CHADDS WALK MARIETTA GA 30062',7709738424);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Airline Ticket Counter Inc','1255 JOHNSON FERRY RD MARIETTA GA 30068',7709778788);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Airmax International Inc','PO BOX 300053 JAMAICA NY 11430',9172085137);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Airport Shuttle Inc','3608 DYER PARKE LN SW MARIETTA GA 30060',7704852733);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AIRPORT WEATHER INFO','07776 STATE ROUTE 219 NEW KNOXVILLE OH 45871',4197532821);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Airport Weather Infoo','07776 STATE ROUTE 219 NEW KNOXVILLE OH 45871',4197532821);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Airtime Resellers Group','5008 MEADOW LN MARIETTA GA 30068',7705091085);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Ais Contracting Inc','240 CRANFILL RD SE MARIETTA GA 30060',7704299036);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aisc Marketing Inc','1976 RIVER FOREST DR MARIETTA GA 30068',7706429707);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AJ Builders Inc','889 WATERFORD GRN MARIETTA GA 30068',7709988427);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aj Taxi Service','77 6425 Kuakini Hwy Keaau HI 96749',8086401804);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AJS Auto Inc','1511 S COBB DR SE MARIETTA GA 30060',7707949447);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AJW Services Inc','1540 HEATH LN MARIETTA GA 30062',7705657522);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Akamai Fincl Entrepreneur MGT','74 5565 Luhia St Ste CD Kailua Kona HI 96740',8083318681);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AKIMA CONSTRUCTION SERVICES','36044 KILLEEN TX 76544',9802972831);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AKRON AIRPORT-CHRISTIAN AIRMEN','PO BOX 126 AKRON NY 14001',7165424607);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AL JOHNSON ATTORNEYS AT LAW','261 WASHINGTON AVE NE MARIETTA GA 30060',7704225494);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Al Stark','4260 CREEK HAVEN DR MARIETTA GA 30062',6785609180);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Al Tacos Carbon','234 WINDY HILL RD SE MARIETTA GA 30060',7704330733);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Al Tilley Auto Sales','Pennsylvania Route 29 Montrose PA 18801',5702784129);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALS AIR CONDITIONING SVC','PO BOX 8103 MISSION TX 78572',9566301486);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alain Pressure Washing','1726 KINSMON CV MARIETTA GA 30062',7705875505);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALAMO AUTO CTR','RR 1 BOX 107CC ALAMO TX 78516',9567818552);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALAMO AUTO SALES','RR 3 BOX 26 LAREDO TX 78043',9567255944);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALAMO BARBER SHOP','1828 LOWER ROSWELL RD MARIETTA GA 30068',7709732865);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alamo Rotary','8275 FM 78 San Antonio TX 78244',2106627557);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alamo Tile','3539 CHESTATEE DR MARIETTA GA 30062',7705784359);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alamo Tile','3539 CHESTATEE DR MARIETTA GA 30062',7705784359);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALAN C POPE HIGH SCHOOL','3001 HEMBREE RD NE MARIETTA GA 30062',7705787900);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alan Davidson and Associates','4813 FERNIE CT NE MARIETTA GA 30068',7705180054);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alan F Herman','5033 LAKELAND DR MARIETTA GA 30068',7709736748);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALAN MALOON MD','780 CANTON RD NE STE 400 MARIETTA GA 30060',7704250483);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alan Manheim PC','25 ALEXANDER ST SE MARIETTA GA 30060',7704232222);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alan Podrid/Co Inc','3410 STILLBROOK WAY MARIETTA GA 30062',7709732315);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alaneo Appliance Parts','77-6425 Kuakini Hwy 102 Kailua Kona HI 96740',8083312252);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALANI PRODUCTIONS','HC 2 BOX 6435 KEAAU HI 96749',8089658655);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALANI PRODUCTIONS','PAHOA VILLAGE RD PAHOA HI 96778',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALARMING RESULTS','1577 GREYSON RDG MARIETTA GA 30062',7709775262);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alarming Results Inc','1050 E PIEDMONT RD MARIETTA GA 30062',7709775262);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alarming Solutions Inc','1401 JOHNSON FERRY RD MARIETTA GA 30062',7705658786);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALBAN ELECTRIC','PO BOX 6104 LIVE OAK FL 32064',3863624246);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Albanese Development Co','70 LITTLE WEST ST NEW YORK NY 10004',2129648944);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALBANOS ITALIAN MARKET INC','1950 ROSWELL RD MARIETTA GA 30068',7709776778);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Albany Crowne Plaza Hotel Inc','80 State and Lodge St Albany NY 12207',5184626611);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALBEMARLE DANCE CTR','425 N MCARTHUR ST STE D ELIZABETH CITY NC 27909',2523389838);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALBENS GROUP','3900 N 10TH ST STE ALGR MCALLEN TX 78501',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Albert Demaria Consult','3857 RUNNING FOX DR MARIETTA GA 30062',6785603279);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALBERT S MILLS TRACTOR SVC','540 20 MILE RD LOT H PONTE VEDRA BEACH FL 32081',9042198483);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALBION SCACCIA ENTERPRISE','4817 OLD TIMBER RIDGE RD MARIETTA GA 30068',6786794000);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Albion Scaccia Enterprises LLC','4817 OLD TIMBER RIDGE RD MARIETTA GA 30068',6783255900);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alchemy Solutions Group','1609 EXETER CT NE MARIETTA GA 30068',7706400075);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alcohol & DRG Trtmnt Ctr of 1s','2200 ROSWELL RD MARIETTA GA 30062',7705786862);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALCOHOLIC BEVERAGES','501 DEMOREST ST SE LIVE OAK FL 32064',3863622501);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALCOHOLIC BEVERAGES','813 OHIO AVE S LIVE OAK FL 32064',3863622501);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALCON BUILDERS','553 WATERMAN ST SE MARIETTA GA 30060',7704202340);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALDEBARAN ASSOCIATES INTL','1958 HITCHING POST LN MARIETTA GA 30068',7706407317);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alderman Hockaday & Assoc','809 MUIRFIELD TRL MARIETTA GA 30068',7705784376);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALDERSON MAINTENANCE SHOP','202 MONROE ST ALDERSON WV 24910',3044452996);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aldgia Arbardgi','5415 LAKE HOWELL RD WINTER PARK FL 32792',8135035055);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aldridge Grading & Trucki','512 DELTA PL MARIETTA GA 30062',7702186067);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aleah Morrow LPC','800 KENNESAW AVE NW MARIETTA GA 30060',7704999392);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALEC & COMPANY LLC','22-01 BROADWAY FAIR LAWN NJ 7410',2017970900);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALEKSA DESIGN','1255 JOHNSON FERRY RD MARIETTA GA 30068',7705797097);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALEKSA DESIGN','1255 JOHNSON FERRY RD MARIETTA GA 30068',7705797097);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALERT LOCK & KEY','PO BOX 791383 SAN ANTONIO TX 78279',2106964066);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALEX ENERGY INC','PO BOX 857 SUMMERSVILLE WV 26651',3048725898);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALEX HORMICK','RR 1 BOX 41P BRIDGEPORT WV 26330',3040000000);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALEX S MCARTHUR','282 1/2 E EXCHANGE ST APT 6 AKRON OH 44304',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALEX STAKLEFF','2552 BRICE RD NULL AKRON OH 44313',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alex Tires','1570 S COBB DR SE MARIETTA GA 30060',6783556682);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alex Web Design','1503 Albemarle Rd Charlotte NC 28227',7049419999);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALEXANDER CHIROPRACTIC','4343 SHALLOWFORD RD MARIETTA GA 30062',7705179993);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alexander Michael Group Inc','301 MILLBROOK FARM CT MARIETTA GA 30068',7703211600);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alexander Properties Group','2751 HAMMONDTON RD SE MARIETTA GA 30060',7704340980);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alexas Design','1255 JOHNSON FERRY RD MARIETTA GA 30068',7705797097);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alexdiamond','3310 CREEK HOLLOW DR MARIETTA GA 30062',7703214068);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alexis Boutique','461 WINDY HILL RD SE MARIETTA GA 30060',6783093833);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALFA AUTO CENTER','51 S FAIRGROUND ST SE MARIETTA GA 30060',7702181220);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALFRED SMITH MASONRY','426 JOHNSON AVE SW LIVE OAK FL 32064',3863622463);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALFRED WAINWRIGHT','834 MENTOR RD NULL AKRON OH 44303',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Algonquin Products Company','1165 ALLGOOD RD STE 13 MARIETTA GA 30062',7705784240);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALHAMBRA PON','5351 E AIRPORT DR CELL TOWER 5 ONTARIO CA 91761',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALHAMBRA STATION CAFE','255 ALHAMBRA CIR STE 170 CORAL GABLES FL 33134',3054412676);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Ali Baba Restaurants Inc','2259 HILL CREEK WAY MARIETTA GA 30062',7709987173);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALIS COOKIES','1255 JOHNSON FERRY RD MARIETTA GA 30068',7709718566);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alianza Latina Services','737 ROSWELL ST NE MARIETTA GA 30060',7704247979);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alibi Marketing','4470 SILVERSMITH CT MARIETTA GA 30062',7706452661);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALICE HUFFMAN','1 FOUNTAIN SQ CHATTANOOGA TN 37402',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alice Stgermain Succulent GL','4366 DUNMORE RD NE MARIETTA GA 30068',7705099998);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All 10 Inc','800 KENNESAW AVE NW MARIETTA GA 30060',7704209855);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL ABOUT EMMA','2372 CHESTNUT SPRINGS TRL MARIETTA GA 30062',6785606164);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All About Mailboxes Inc','4371 ROSWELL RD MARIETTA GA 30062',7709730081);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All About Padre','1004 Padre Blvd G1-114 S Padre Isle TX 78597',9563713339);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL ABOUT SIGNS INC','4371 ROSWELL RD MARIETTA GA 30062',7709770408);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All About Signs N Print Inc','4261 GREEN RIDGE DR MARIETTA GA 30062',7703216446);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All About You Design Center','76 INDIAN TRL MARIETTA GA 30068',7705795143);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All American Consulting','PO BOX 732 MARIETTA GA 30061',7704332396);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All American Exports Inc','819 FOX HOLLOW PKWY MARIETTA GA 30068',7706334123);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All American Exteriors Inc','2822 FORSYTH RD STE 106 WINTER PARK FL 32792',4078307004);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All American Exteriors Inc','2822 FORSYTH RD STE 106 WINTER PARK FL 32792',4078307004);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All American Quality Foods','681 S MARIETTA PKWY SE MARIETTA GA 30060',7704990919);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL ATLANTA REALTY','3225 SHALLOWFORD RD STE 100 MARIETTA GA 30062',7705657505);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Atlanta Realty LLC','3225 SHALLOWFORD RD MARIETTA GA 30062',7709714400);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL BETTER SPEECH LANGUAGE','N LOOP 1604 W SAN ANTONIO TX 78258',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Budget Mechanical Services','152 W W LEE CT NE MARIETTA GA 30060',7704219977);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL CHECKS CASHED','461 WINDY HILL RD SE MARIETTA GA 30060',7704388497);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Cities Construction Co','8306 Wilshire Blvd 1099 Los Angeles CA 90010',3237593588);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL COUNTY CONSTRUCTION CO','PONY FARM RD ONEONTA NY 13820',6074326822);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL DAY EMERGENCY LOCKSMITH','4026 UNION ST FLUSHING NY 11354',7188872125);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Day Emergency Locksmith','1913 E PIEDMONT RD MARIETTA GA 30062',6783030399);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Day Emergency Locksmith','4026 UNION ST FLUSHING NY 11354',7188872125);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Decked Out','3430 DEVOE CT MARIETTA GA 30062',7705970819);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All E-Scrap Recycling','4880 LOWER ROSWELL RD MARIETTA GA 30068',7706849555);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL ELECTRIC','PO BOX 1773 COPPERAS COVE TX 76522',2545428050);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Emergency Peachtree City L','2350 MITCHELL RD NE MARIETTA GA 30062',7705654490);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Green Landscape','1445 BROOKCLIFF PL MARIETTA GA 30062',7705651643);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL ISLAND AUTOMOTIVE','96-1272 WAIHONA ST UNIT 1 PEARL CITY HI 96782',8084559692);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Island Porter Service','Ke Ahole Airprt Kailua Kona HI 96739',8083267242);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All My Sons Moving & Storage','2862 CLEARBROOK DR MARIETTA GA 30068',7704331400);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Nations Design Studio','3034 COACH LN MARIETTA GA 30062',6784682825);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL OCCASIONS PARTY PLATTERS','PO BOX 397532 DALLAS TX 75339',2149239097);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Out Auto USA LLC','503 COMMERCE PARK DR SE MARIETTA GA 30060',7705903711);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Out Green','3630 CHERBOURG WAY MARIETTA GA 30062',7709717582);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Pro Flooring Inc','1000 COBB PKWY N STE A2 MARIETTA GA 30062',7704266776);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Pro Fncl Svc Merrietta LLC','797 ROSWELL ST NE MARIETTA GA 30060',7704269998);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Pro Landscaping','2458 TIMBERLY DR SE MARIETTA GA 30060',7703191918);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Pro Towing','San Diego 92111 San Diego CA 92111',8582775102);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Seasons Auto School','41 Bell Blvd Bayside NY 11361',7184458800);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Services Realty Corp','5959 Main St Hunter NY 12442',5182634286);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Shades Salon Air Brush','3000 JOHNSON FERRY RD MARIETTA GA 30062',7709929466);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL SKILL ELECTRIC','171 SUMMER LAKE DR SW MARIETTA GA 30060',7708639411);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL SKILL ELECTRIC','171 SUMMER LAKE DR SW MARIETTA GA 30060',7708639411);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Square Profession Remodel','3267 HICKORY BLUFF DR MARIETTA GA 30062',7705796797);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Star Communications Inc','4939 LOWER ROSWELL RD MARIETTA GA 30068',7705651415);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL STAR CONTRACTING','STATE HIGHWAY 3 WATERTOWN NY 13601',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Star Financial','280 COBB PKWY S MARIETTA GA 30060',7708992705);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL STAR GROCERY','PO BOX 212 REYNOLDSVILLE WV 26422',3046246364);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL STAR PEST CONTROL & SVC','PO BOX 163843 FORT WORTH TX 76161',8174983900);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Star Pizza & More Inc','2060 LOWER ROSWELL RD MARIETTA GA 30068',7709772220);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All Star Pizza & More Inc','2060 LOWER ROSWELL RD MARIETTA GA 30068',7709772220);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL STAR REMODELING','1754 ARROWHEAD CT MARIETTA GA 30062',4049256555);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL SURF GLASSING','PO BOX 1209 HALEIWA HI 96712',8086378787);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL THAT MATTERS','3100 ALLISON BONNETT MEMORIAL DR HUEYTOWN AL 35023',2054916775);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All That Matters Inc','3100 Allson Bnnett Mem Dr Bessemer AL 35023',2054916775);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL THROUGH THE HOUSE','4015 MANOR HOUSE DR MARIETTA GA 30062',7709927564);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL VALLEY PLUMBING','PO BOX 4142 MCALLEN TX 78502',9566866656);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALL-IN-ONE UPHOLSTERY','2822 FORSYTH RD # 2870 WINTER PARK FL 32792',4076788282);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('All-Tech Heating & Cooling','1461 WHITE CIR NW MARIETTA GA 30060',7704210081);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLBRITTONS PONTIAC-GMC INC','500 HOWARD ST W LIVE OAK FL 32064',3863624012);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLEGANY ALLEGANY JAIL','4484 STATE RT 19 N BELMONT NY 14813',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLEGANY ALLEGANY JAIL','4484 STATE RT 19 N BELMONT NY 14813',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Allegro Airlines','JFK Airport Jamaica NY 11411',7185657454);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLEN & SONS REFRIGERATION','556 S FAIR OAKS AVE PASADENA CA 91105',6267917157);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLEN BRYANT','PO BOX 913 MONCKS CORNER SC 29461',8438997822);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Allen David Cabinetry','157 HOUSTON RD TROUTMAN NC 28166',7045280424);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLEN FINANCIAL SVC','732 KENNESAW AVE NW MARIETTA GA 30060',7704203333);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Allen Investigative Services','PO BOX 723813 ATLANTA GA 31139',7709770404);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Allen Locksmith','2925 CAROLYN ST MARIETTA GA 30062',7705523656);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLERGEN RESPONSE RESEARCH CTR','1155 ALLGOOD RD MARIETTA GA 30062',7709719976);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLFAME INC','505 COMMERCE PARK DR SE STE F MARIETTA GA 30060',7704286589);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Allgood Food Mart','373 ALLGOOD RD NE MARIETTA GA 30060',6782905750);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Allgood Road Coin Laundry','788 ALLGOOD RD MARIETTA GA 30062',7704222720);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Allgood Services of Georgia','1095 MARIETTA INDUSTRIAL DR MARIETTA GA 30062',7709266280);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alliance Bank NA','120 Madison St 18th Syracuse NY 13202',3154757534);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alliance Bank NA','120 Madison St 18th Syracuse NY 13202',3154757534);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alliance Business Products','2501 E PIEDMONT RD MARIETTA GA 30062',7705755730);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLIANCE JANITORIAL SVCS','500 BIRCHWOOD RD SW MARIETTA GA 30060',7704342407);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alliance Systems Ltd','2265 ROSWELL RD MARIETTA GA 30062',7705094864);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Allied Aviation Fueling Inc','PO BOX 81686 SAN DIEGO CA 92138',6195747808);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Allied Business Group Inc','2640 HAMPTON PARK DR MARIETTA GA 30062',7704248083);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLIED COMMUNITY TRUST INC','406 DUVAL ST NE LIVE OAK FL 32064',3863300144);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Allied Electrical Contractors','PO BOX 647 MARIETTA GA 30061',7704241989);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Allied Health Consultants Inc','5123 SANDLEWOOD CT MARIETTA GA 30068',7706401110);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLIED HOME MORTGAGE CAPITAL','2265 ROSWELL RD MARIETTA GA 30062',7705917727);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Allied Waste Industries Inc','323 MARBLE MILL RD NW MARIETTA GA 30060',7705142910);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLIED WASTE SVC','PO BOX 668 DONNA TX 78537',9564647871);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLISON DOWLING','1 FOUNTAIN SQ CHATTANOOGA TN 37402',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLMERICA FINANCIAL','1875 WICKS VALLEY DR MARIETTA GA 30062',7703212750);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Allpro Parking','325 S WARREN ST SYRACUSE NY 13202',3154257275);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLSHADES SALON & AIRBRUSH','3000 JOHNSON FERRY RD MARIETTA GA 30062',7709929466);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Allsouth Pntg & Wallcovering','1059 TRIAD CT STE 12 MARIETTA GA 30062',7705289960);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLSTAR HAIR STUDIO','2800 JOHNSON FERRY RD MARIETTA GA 30062',7708170252);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLSTATE INSURANCE CO','180 COBB PKWY S MARIETTA GA 30060',7704998061);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLSTATE INSURANCE CO','3535 ROSWELL RD STE 34 MARIETTA GA 30062',7709734848);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLSTATE INSURANCE CO','4343 SHALLOWFORD RD MARIETTA GA 30062',6787959696);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLSTATE INSURANCE CO','4994 LOWER ROSWELL RD STE 26 MARIETTA GA 30068',7709719814);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Allstate Insurance Company','1011 S MARIETTA PKWY SE MARIETTA GA 30060',7704264582);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Allstate Insurance Company','950 COBB PKWY S MARIETTA GA 30060',7704229544);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLTEL FLORIDA','206 WHITE AVE SE LIVE OAK FL 32064',3863628000);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALLYSON RUSSELL-BLAIR PC','216 ALEXANDER ST SE MARIETTA GA 30060',6782901243);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALMIND CONSULTING INC','2020 BARAMORE OAKS DR MARIETTA GA 30062',7709738833);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Almo Auto Sales','591 LAWRENCE ST NE MARIETTA GA 30060',6783541926);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALMO AUTOSALES','591 LAWRENCE ST NE MARIETTA GA 30060',6783541926);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alno Group','8111 L B Johnson Fwy 65 Dallas TX 75251',2145803880);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALOETTE OF METRO ATLANTA','3214 TEABERRY WAY MARIETTA GA 30068',7704276777);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aloha Acupuncture & Sport','78 6831 Alii Dr Kailua Kona HI 96740',8083244545);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aloha Billiards','77 6425 Kuakini Hwy Kailua Kona HI 96740',8083274567);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aloha Ceramics','98 021 Kam Hwy Aiea HI 96701',8084889722);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aloha Home Health Care','94 547 Ukee St Ste 117 Waipahu HI 96797',8086772298);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aloha Sun Tanning Center','3101 ROSWELL RD STE E MARIETTA GA 30062',7703211300);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALP INDUSTRIES-WEB PRODUCTS','PO BOX 127 ABERDEEN NC 28315',9109447616);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alph Web Tech','2520 E PIEDMONT RD STE C MARIETTA GA 30062',6785602077);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALPHA GROOMING','290 YORK ST APT E YORK ME 3909',2073329929);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALPHA LIST MARKETING','PO BOX 921293 NORCROSS GA 30010',4049957049);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alpha Omega Project','201B STILLWATER STE 6 WIMBERLEY TX 78676',5128476970);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alpha PHI Omega - Rio PI Chptr','9500 GILMAN DR A21 LA JOLLA CA 92093',3105612620);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALPHA REMODELING INC','3356 HUNTERS LODGE RD MARIETTA GA 30062',7709733938);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alpine Communications','1125 PROMONTORY DR MARIETTA GA 30062',7703216386);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alpine Delivery Systems','Van Nuys CA 91411 Sherman Oaks CA 91411',8189012141);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alpine Granite & Marble','157 HOUSTON RD TROUTMAN NC 28166',7045289952);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alr Co Inc','98 20 Kamhemaha Hwy Aiea HI 96701',8084844508);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Als Graphics','4020 OAK FOREST CIR MARIETTA GA 30062',6785604122);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALTA FINANCIAL CORP','531 ROSELANE ST NW MARIETTA GA 30060',7704265626);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALTADONNA RESTAURANT','24930 HORACE HARDING EXPY FLUSHING NY 11362',7182245474);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Altai Corporation','1093 Cobb Pkwy SE Marietta GA 30062',7709198670);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Altamoda Technologies LLC','4084 TRITT HOMESTEAD DR MARIETTA GA 30062',6786122181);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Altamonte Mall Venture A Flor','451e Altamnte Dr 2165 Altamnte Spgs FL 32701',4078304422);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Altamonte Pet Center','451 E Altamonte Dr 475 Altamonte Spg FL 32701',4078315443);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Altec Systems Inc','200 COBB PKWY N STE 402 MARIETTA GA 30062',7704200055);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALTER','140 FRANKLIN ST ALTER BROOKLYN NY 11222',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alterations By Lee Inc','1205 JOHNSON FERRY RD MARIETTA GA 30068',7709735156);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Altered Imges Hair Styling Stn','567 ROSWELL ST NE MARIETTA GA 30060',7704242482);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALTERMAN & ASSOC','2039 DAYRON CT MARIETTA GA 30062',4046888400);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alternative Electronic Svcs','1436 BROOKCLIFF DR MARIETTA GA 30062',7705780268);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALTERNATIVE SENTENCING','PO BOX 218 WAYNE WV 25570',3042726377);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Althea Caces LLC','240 CHEROKEE ST NE MARIETTA GA 30060',7704249141);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Altoplex Import','329 COBB PKWY N MARIETTA GA 30062',7707921100);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Altria Client Services','1420 LAKESIDE PKWY FLOWER MOUND TX 75028',9727245406);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alvares Nasario','951 S MARIETTA PKWY SE MARIETTA GA 30060',7707959888);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alvin Fouts Cars Inc','1700 S COBB DR SE MARIETTA GA 30060',7704251475);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alvin L Atkins','27w72 Central Parkw New York NY 10023',2125951456);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('ALVINS FOOD STORE','PO BOX 97 PORT O CONNOR TX 77982',3619832397);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alvins Liquor Store Inc','PO BOX 97 PORT O CONNOR TX 77982',3619834733);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alvis Weatherly Inc','1362 SHEFFIELD PKWY MARIETTA GA 30062',7709712968);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Always 24 Hour Emrgncy Lsmith','1280 JOHNSON FERRY RD MARIETTA GA 30068',6783032439);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Always Superior Book','3940 CLUBLAND DR MARIETTA GA 30068',7709772378);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Alzafar Shrine Center','901 N 1604 W San Antonio TX 78232',2104961625);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Am S Enterprises','4880 LOWER ROSWELL RD MARIETTA GA 30068',7709518478);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AM SOUTH BANK','5679 QUINCE RD MEMPHIS TN 38119',9017625980);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMADEUS STRING ENSEMBLE INC','2968 GANT QUARTERS DR MARIETTA GA 30068',7709713176);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMANA','1765 W OAK PKWY MARIETTA GA 30062',7704256001);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMAVIS ENTERPRISES','291 PAT MELL RD SE MARIETTA GA 30060',7704449010);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Amavis Enterprises','122 LAROSE CIR SE MARIETTA GA 30060',6787688413);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMAZING CABINETS','189 COBB PKWY N MARIETTA GA 30062',7703548118);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMAZING CARS','468 COBB PKWY S MARIETTA GA 30060',7704253500);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Amazing Cars Inc','468 COBB PKWY S MARIETTA GA 30060',7707949008);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMAZONIA','1355 ROSWELL RD MARIETTA GA 30062',7705796773);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Amber Financial Group LLC','91 590 Farrington Hwy Kapolei HI 96707',8086744449);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMBERLY MASTER PROPERTY OWNERS','1075 RESIDENCE CLUB DR CARY NC 27519',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Ambiance Designs','PO BOX 6355 MARIETTA GA 30065',7705655543);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Amego Furniture','809 ROSWELL ST NE MARIETTA GA 30060',6787979001);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Amencon Construction Inc','1 New York Phizi New York NY 10001',2127429689);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Amenique Community Relations','275 TIMBER CREEK LN SW MARIETTA GA 30060',4046413786);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMER MUSEUM/NAT HISTORY','200 CENTRAL PARK W AMER MUSEUM NEW YORK NY 10024',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMER MUSEUM/NAT HISTORY','200 CENTRAL PARK W IT-NETWORK NEW YORK NY 10024',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMER MUSEUM/NAT HISTORY','200 CENTRAL PARK W SUPPORT SER NEW YORK NY 10024',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Amer Property Specialists','2265 ROSWELL RD MARIETTA GA 30062',7705094884);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERI GAS INC','PO BOX 367 CATSKILL NY 12414',5189433680);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('America On Wheels Inc','210 BLAIR VALLEY DR NE MARIETTA GA 30060',6787979994);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAS CLEANING & CONSTR','377 GLOVER ST SE MARIETTA GA 30060',7704229277);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Academy of Mind & Bdy','PO BOX 174 MABLETON GA 30126',6785817880);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN ANIMAL HOSPITAL ASSN','ARSENAL STREET RD WATERTOWN NY 13601',3157859505);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Association','51 GOODMAN DR CINCINNATI OH 45221',5135585103);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN BANK INSTITUTE','1046 S COBB DR SE MARIETTA GA 30060',7704269584);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN BANKERS INSURANCE CO','255 ALHAMBRA CIR CORAL GABLES FL 33134',3054429348);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Benefits Company','400 LOCKHEED AVE SE MARIETTA GA 30060',6785811114);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Boatbuilders Assn','127 CHURCH ST NE STE 210 MARIETTA GA 30060',7707923070);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN BODY SHOP','523 GLOVER ST SE MARIETTA GA 30060',7704229497);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Brake Services','1310 JOHNSON FERRY RD MARIETTA GA 30068',7709774117);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Broadband Inc./Broadb','821 INDUSTRIAL BLVD DEL RIO TX 78840',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Broadband Inc./Granit','5518 LIPES BLVD APT 218 CORPUS CHRISTI TX 78413',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Broadband Inc./USPS','124 N Maple Street XYZ WAVERLY KY 42462',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN BROAND USPS','18 E CLARK ST PINEWOOD SC 29125',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Builder Surplus LLC','1205 JOHNSON FERRY RD MARIETTA GA 30068',6782779335);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Capital Insur Assoc','367 PAT MELL RD SE MARIETTA GA 30060',7708018001);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Ceo LLC','Time Sq New York NY 10036',6467441386);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Cnsrvtion Asssciation','30 Rockefeller Plz 5600 New York NY 10112',2126495819);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Collection Systems','PO BOX 466 CLIFTON PARK NY 12065',5188776126);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Color Graphics Inc','3879 WINNERS CT MARIETTA GA 30062',7709713705);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Containment Svcs Inc','60 COVINGTON AVE NE MARIETTA GA 30060',7704279777);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Credit Financing','16310 Nthrn Blvd Ste 201 Flushing NY 11358',7184619444);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN DELI','180 COBB PKWY S MARIETTA GA 30060',7705901178);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN DELI','2100 ROSWELL RD MARIETTA GA 30062',7705093800);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Deli','2100 ROSWELL RD MARIETTA GA 30062',7705093800);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Direct Mortgage Inc','4019 BRAMBLE CT MARIETTA GA 30062',7709737899);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Drive Shaft Service','765 S COBB DR SE MARIETTA GA 30060',7704999804);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Eagle Outfitters Inc','4475 ROSWELL RD STE 310 MARIETTA GA 30062',7705654111);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Engine Installations','999 MARIETTA INDUSTRIAL DR MARIETTA GA 30062',7704286440);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN EXPRE AMEX TRAVEL','3131 W PARK BLVD APT COMM174 PLANO TX 75075',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Express Travel','901 SAWYER RD FL 3 MARIETTA GA 30062',7705785835);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN FILTECO MACHINERY','1165 ALLGOOD RD MARIETTA GA 30062',7705793811);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Financial Advisors','2551 ROSWELL RD STE 310 MARIETTA GA 30062',7709772434);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Friends of The Hebrew','1 Battery Park Plz 25 New York NY 10004',2128094430);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN FUNDING','1225 JOHNSON FERRY RD MARIETTA GA 30068',6785607171);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American General Finance Corp','2141 ROSWELL RD STE B MARIETTA GA 30062',7705099450);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN GENERAL SECURITIES','909 OHIO AVE N LIVE OAK FL 32064',3863627101);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN GLASS SOLUTIONS','35 PIONEER TRL MARIETTA GA 30068',4044252907);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American HM Surfaces Group Inc','4944 LOWER ROSWELL RD MARIETTA GA 30068',7709738284);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Home Inspection Inc','3313 ELLSMERE TRCE MARIETTA GA 30062',7709730655);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN HOME KEY','1000 JOHNSON FERRY RD MARIETTA GA 30068',7705656585);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN HOME SURFACES GROUP','4994 LOWER ROSWELL RD STE 16 MARIETTA GA 30068',7709738284);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN INTEGRATED ACCE','26 SAINT MARKS PL AMERICAN INT STATEN ISLAND NY 10301',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN INTERPRETER ASSOC','2721 SUDBURY TRCE MARIETTA GA 30062',7704192020);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Intl Resources','98 718 Mnlua Rd Ste A018 Pearl City HI 96782',8084884426);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN LASER CTR MARIETTA','1163 JOHNSON FERRY RD STE 120 MARIETTA GA 30068',7703218687);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Learning Foundation','355 BRIARWOOD CT MARIETTA GA 30068',7703219905);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN LEGION','STATE BETTSVILLE OH 44815',4199865926);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN LEGION POST 154','ELY LAKE RD MONTROSE PA 18801',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Legion Post 42','PO BOX 268 DAMARISCOTTA ME 4543',2075633738);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN LEGION PST154','ELY LAKE RD MONTROSE PA 18801',5702781649);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Liberty Mortgage','2475 E PIEDMONT RD MARIETTA GA 30062',7705790359);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Limousine','166182 San Pedro Ave San Antonio TX 78232',2108239088);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN LINES INC','120 S PARK SQ NE STE 201 MARIETTA GA 30060',6785811951);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN LOCATORS','1531 ROSWELL RD MARIETTA GA 30062',7705786400);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Maglev Technology','30 S PARK SQ NE STE 201 MARIETTA GA 30060',4043864036);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Management Svcs Inc','950 HUDSON RD SE MARIETTA GA 30060',7704258193);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN MEDICAL ACCOUNTING','2870 JOHNSON FERRY RD MARIETTA GA 30062',7705097750);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Medical Accounting &','PO BOX 72543 MARIETTA GA 30007',7706932622);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN MEDICAL ACCT/CONSLT','2864 JOHNSON FERRY RD STE 150 MARIETTA GA 30062',7706936022);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Medical Response Inc','595 ARMSTRONG ST SE MARIETTA GA 30060',7705131767);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN MORTGAGE SVC INC','3115 ROSWELL RD MARIETTA GA 30062',7706153931);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Mseum of Ntral Hstory','79th St At Central Pk St New York NY 10024',2127695656);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Mseum of Ntral Hstory','Central Park W 79th St New York NY 10024',2127695000);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN MUSEUM NATURAL','200 CENTRAL PARK W AMERICAN MU NEW YORK NY 10024',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Museum of Natural His','79th St Central Prk W New York NY 10024',2127695000);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN MUSEUM-NATRL HIST LIB','200 CENTRAL PARK W NEW YORK NY 10024',2127695400);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN NATIONAL INSURANCE CO','3162 JOHNSON FERRY RD STE 260 MARIETTA GA 30062',6785609180);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American National Insurance Co','1230 JOHNSON FERRY PL MARIETTA GA 30068',7709715002);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American National Insurance Co','2862 JOHNSON FERRY RD MARIETTA GA 30062',7706429552);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN PAWN & JEWELRY','1055 S COBB DR SE MARIETTA GA 30060',7705140356);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN PEDIATRIC CONSULTANTS','2215 ROSWELL RD MARIETTA GA 30062',7703211773);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Petroleum Institute','Toll 50 Broadway Ste 3701 New York NY 10001',2129476147);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Petuary Group Inc','240 TIMBER CREEK LN SW MARIETTA GA 30060',7703333332);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN POWER EQUIPMENT','1359 GRESHAM RD MARIETTA GA 30062',7709718118);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Power Equipment','1359 GRESHAM RD MARIETTA GA 30062',7709718118);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Prepaid Telephone Ser','2866 JOHNSON FERRY RD MARIETTA GA 30062',6788220550);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN PRINTING INK','1050 TRIAD CT MARIETTA GA 30062',6785947698);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Printing Ink','1050 TRIAD CT MARIETTA GA 30062',7705947698);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Pro Credit Inc','1240 JOHNSON FERRY PL MARIETTA GA 30068',7703211772);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN RED CROSS','2143 ROSWELL RD MARIETTA GA 30062',7703218461);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN RED CROSS','324 VICTORY DR SE MARIETTA GA 30060',7704282695);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Red Cross','2179 ROSWELL RD STE 251 MARIETTA GA 30062',7705781977);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN RED CROSS VALLEY CHAP','37 N CHEMUNG ST WAVERLY NY 14892',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Reserves LLC','1923 FIELDS POND GLN MARIETTA GA 30068',7708465490);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Roofing Sales Inc','3535 ROSWELL RD MARIETTA GA 30062',7705659575);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN SCREEN','319 CHURCH ST NE MARIETTA GA 30060',7704273229);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN SECURITY ALARM & LOCK','PO BOX 37060 CLEVELAND OH 44137',3305629329);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Specialty Systems Inc','1000 JOHNSON FERRY RD MARIETTA GA 30068',8002864254);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Sports Co Inc','3307 WOODSFIELD DR NE MARIETTA GA 30062',7705097000);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN STANDARD APPEARAL','BROADWAY NEW YORK NY 10018',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Stone and Tile Inc','1759 AIRCRAFT DR SE MARIETTA GA 30060',4045134519);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN SYMBOL','4343 SHALLOWFORD RD STE D2 MARIETTA GA 30062',6784615751);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Telephone Supply Inc','1968 FIELDS POND DR MARIETTA GA 30068',7706422252);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Thunder Cycles Inc','1608 S COBB DR SE MARIETTA GA 30060',7704299887);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Tower Corporation','1165 ALLGOOD RD STE 21 MARIETTA GA 30062',7703216657);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Tower Corporation','829 PICKENS INDUSTRIAL DR MARIETTA GA 30062',7709199003);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN TREE SVC','1949 MOZELLE DR MARIETTA GA 30062',7709719459);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN VAN RENTAL','614 COBB PKWY S MARIETTA GA 30060',7707959510);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Ventures Realty Corp','255 ALHAMBRA CIR STE 1100 CORAL GABLES FL 33134',3055699500);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('American Vigilance','201 PARKAIRE XING MARIETTA GA 30068',7709731493);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN WARRANTY GROUP','2820 LASSITER RD MARIETTA GA 30062',7705180063);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAN WOOD SPECIALISTS','1675 AIRCRAFT DR SE MARIETTA GA 30060',7706568020);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Americana Healthcare Corp GA','4360 JOHNSON FERRY PL MARIETTA GA 30068',7709715870);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Americas Best Contacts &','2200 ROSWELL RD MARIETTA GA 30062',7705656200);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Americas Finest LLC','121 HUNTING CREEK DR MARIETTA GA 30068',7705752388);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Americas First Home Mrtg Co','3939 ROSWELL RD STE 10 MARIETTA GA 30062',7709713882);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Americas Mattress','2135 ROSWELL RD MARIETTA GA 30062',7705653100);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICAS MORTGAGE BROKER','1380 MURDOCK RD MARIETTA GA 30062',7703213402);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Americas Mortgage Brokers Inc','533 JOHNSON FERRY RD MARIETTA GA 30068',7705656315);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICATANINA HOTEL','1701 BROADWAY NEW VDH # 2 NEW YORK NY 10019',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Americorp Financial Inc','4343 SHALLOWFORD RD MARIETTA GA 30062',7709987796);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICTANINA HOTEL','1701 BROADWAY NEW VDH # 4 NEW YORK NY 10019',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICU CREDIT UNION/ SPOKE AC','7785 N STATE ST APT SPOKE LOWVILLE NY 13367',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERICU CREDIT UNION/SPOKE ACC','219 GENESEE ST APT SPOKE ONEIDA NY 13421',0);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Amerifiber Incorporated','1962 WILLEO CREEK PT MARIETTA GA 30068',7705185858);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Amerilat Real Estate','9330 L B JOHNSON FWY 90 DALLAS TX 75243',9729512535);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Amerilimo','185 2 Union Tpke Flushing NY 11366',7184541551);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERIPRISE FINANCIAL','1000 JOHNSON FERRY RD STE D125 MARIETTA GA 30068',7705791466);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Ameritaliano Pizza Co','140 VANN ST NE MARIETTA GA 30060',7702182707);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Ameron International Corp','PO BOX 29968 HONOLULU HI 96820',8082662640);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMERSON ENGRAVING','PO BOX 3184 HUEYTOWN AL 35023',2054914901);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Ames Industrial Sales','3031 PATHVIEW LN MARIETTA GA 30062',7705653704);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMES TAPING TOOLS INC','1080 COBB PKWY N STE A MARIETTA GA 30062',7704273767);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMETA TEXTILES INC','4880 LOWER ROSWELL RD MARIETTA GA 30068',7706490363);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Amex','2439 N FOREST DR MARIETTA GA 30062',4043883820);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMEX INTERNATIONAL CO','PO BOX 1615 LAREDO TX 78044',9567231052);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Amie Hair Braiding','445 WINDY HILL RD SE MARIETTA GA 30060',7708639301);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Amigo','1977 S COBB DR SE MARIETTA GA 30060',6785569400);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMIGO AUTO SALES','1310 S COBB DR SE MARIETTA GA 30060',6785947613);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Amigo Auto Sales Inc','1941 S COBB DR SE MARIETTA GA 30060',7704361760);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMIGO CONCRETE CONTRACTOR','1746 OAK ST SE MARIETTA GA 30060',6785946588);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Amigo Wheels & Tires','727 ROSWELL ST NE MARIETTA GA 30060',4043791197);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMIGOS & FRIENDS USED CARS','1177 HAGOOD CIR MARIETTA GA 30062',6785811444);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMIGOS & FRIENDS USED CARS','980 ROSWELL ST SE MARIETTA GA 30060',7704247923);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Amigos & Friends Used Cars & T','980 ROSWELL ST SE MARIETTA GA 30060',7705147701);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Amigos Friends U Cars & Trcks','1177 HAGOOD CIR MARIETTA GA 30062',6785810470);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Amigos Painting','3020 ROSWELL RD STE 200 MARIETTA GA 30062',6785318292);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('AMIGOS Y MAS','343 PAT MELL RD SE MARIETTA GA 30060',7704326565);

    INSERT INTO [dbo].[TestBusiness] ([BusinessName], [Address], [Phone]) VALUES ('Aminpour & Assoc','SAN DIEGO 92124 SAN DIEGO CA 92101',6194357247);

    SELECT * FROM [dbo].[TestBusiness];

    SELECT

    bus.[Business_pk]

    ,[BusinessName], [Address], [Phone]

    ,ROW_NUMBER() OVER (PARTITION BY [BusinessName], [Address], [Phone] ORDER BY bus.[Business_pk] DESC) AS MatchRank

    INTO [dbo].[PossibleDuplicateBusinesses]

    FROM [dbo].[TestBusiness] bus

  • October 22, 2014 at 9:08 am

    #1754074

    Hello, How about something like:

    WITH Dups AS (

    SELECT

    bus.[Business_pk]

    ,[BusinessName], [Address], [Phone]

    ,ROW_NUMBER() OVER (PARTITION BY [BusinessName], [Address], [Phone] ORDER BY bus.[Business_pk] DESC) AS MatchRank

    FROM [dbo].[TestBusiness] bus

    )

    SELECT *

    INTO [dbo].[PossibleDuplicateBusinesses]

    FROM Dups

    WHERE MatchRank > 1;

    Or if you want all records for a duplicate then

    WITH Dups AS (

    SELECT

    bus.[Business_pk]

    ,[BusinessName], [Address], [Phone]

    ,ROW_NUMBER() OVER (PARTITION BY [BusinessName], [Address], [Phone] ORDER BY bus.[Business_pk] DESC) AS MatchRank

    FROM [dbo].[TestBusiness] bus

    )

    SELECT *

    INTO [dbo].[PossibleDuplicateBusinesses]

    FROM Dups

    INNER JOIN [dbo].[TestBusiness] bus ON Dups.BusinessName] = bus.BusinessName]

    AND Dups.[Address] = bus.[Address] AND Dups.[Phone] = bus.[Phone];

  • October 22, 2014 at 9:56 am

    #1754106

    In the PossibleDuplicateBusiness table I want MatchRank of 1,2,3,etc but only include the MatchRank of 1 if they are also in a duplicate group.

    Both suggestions seem to bring back all the data, just with a ranking, I want to filter out all the Businesses that the group of BusinessName, Address, Phone is 1.

  • October 22, 2014 at 3:32 pm

    #1754202

    SELECT

    [BusinessName], [Address], [Phone]

    ,MIN(Business_pk) AS Business_pk_min,

    ,MAX(Business_pk) AS Business_pk_max

    FROM [dbo].[TestBusiness] bus

    INTO [dbo].[DuplicateBusinesses]

    GROUP BY

    [BusinessName], [Address], [Phone]

    HAVING COUNT(*) > 1

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.

  • October 22, 2014 at 3:40 pm

    #1754205

    The solution with the min and max would work if there were only duplicates, but Businesses have been known to be duplicated 100s of times due to previous incorrectly coded merging and matching of data.

    But I'm still hoping for something that simple!

  • October 22, 2014 at 3:49 pm

    #1754209

    jeff.born (10/22/2014)

    The solution with the min and max would work if there were only duplicates, but Businesses have been known to be duplicated 100s of times due to previous incorrectly coded merging and matching of data.

    But I'm still hoping for something that simple!

    Sorry, my intent wasn't to limit to just the max, but to have that value available to use in a key range when deleting the dups, to reduce how many of the 22M rows you had to search.

    I.e.:

    DELETE FROM mt

    FROM <main_table> mt

    INNER JOIN <dups_table> dt ON

    dt.name = mt.name and

    dt.phone = mt.phone and ...

    WHERE

    mt.pk > dt.min_pk AND

    mt.pk <= dt.max_pk

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.

  • October 23, 2014 at 8:54 am

    #1754370

    ah, understood, but the business key duplicates are almost never sequential, so a range would not work.

  • October 23, 2014 at 9:10 am

    #1754376

    It looks like Scott almost had what you wanted. You're wanting all records where there is a duplicate, which can be restated as "All records where a duplicate exists." So, we use an EXISTS clause:

    WITH Dups AS (

    SELECT

    bus.[Business_pk]

    ,[BusinessName], [Address], [Phone]

    ,ROW_NUMBER() OVER (PARTITION BY [BusinessName], [Address], [Phone] ORDER BY bus.[Business_pk] DESC) AS MatchRank

    FROM [dbo].[TestBusiness] bus

    )

    SELECT *

    INTO [dbo].[PossibleDuplicateBusinesses]

    FROM Dups a

    WHERE EXISTS (

    SELECT 1

    FROM Dups b

    WHERE a.BusinessName = b.BusinessName

    AND a.Address = b.Address

    AND a.Phone = b.Phone

    AND b.MatchRank > 1

    );

  • October 23, 2014 at 9:26 am

    #1754383

    That worked, I knew there had to be a better way and that is it.

  • October 24, 2014 at 2:14 am

    #1754547

    jeff.born (10/23/2014)

    That worked, I knew there had to be a better way and that is it.

    Not so fast...ROW_NUMBER() over a whole table is expensive. Scott's method is usually far more efficient. Here's how to implement it in sqlslacker's code:

    WITH Dups AS (

    SELECT BusinessName, [Address], Phone

    FROM #TestBusiness

    GROUP BY BusinessName, [Address], Phone

    HAVING COUNT(*) > 1

    )

    SELECT a.Business_pk, a.BusinessName, a.[Address], a.Phone,

    ROW_NUMBER() OVER (PARTITION BY a.BusinessName, a.Phone, a.[Address] ORDER BY a.Business_pk DESC) AS MatchRank

    FROM Dups b

    INNER JOIN #TestBusiness a

    ON a.BusinessName = b.BusinessName

    AND a.Address = b.Address

    AND a.Phone = b.Phone;

    [Address] VARCHAR(MAX): You don't want an address so big that it won't fit in the entire Encyclopedia Britannica. The front of an envelope is all you get, so use something sensible.

    SELECT MAX(LEN(ADDRESS)) FROM #TestBusiness -- 53

    ALTER TABLE #TestBusiness ALTER COLUMN [Address] VARCHAR(60) NOT NULL

    -- Now you can create an index using address:

    CREATE INDEX ix_Helper ON #TestBusiness ([BusinessName], [Phone], [Address]) INCLUDE ([Business_pk])

    This mod of the above query might be promising too:

    WITH Dups AS (

    SELECT BusinessName, [Address], Phone

    FROM #TestBusiness

    GROUP BY BusinessName, [Address], Phone

    HAVING COUNT(*) > 1

    )

    SELECT a.Business_pk, a.BusinessName, a.[Address], a.Phone,

    ROW_NUMBER() OVER (PARTITION BY a.BusinessName, a.Phone, a.[Address] ORDER BY a.Business_pk DESC) AS MatchRank

    FROM Dups b

    INNER JOIN #TestBusiness a WITH (FORCESEEK) -- Changes MERGE JOIN to NESTED LOOPS, loses sort required for ROW_NUMBER()

    ON a.BusinessName = b.BusinessName

    AND a.[Address] = b.[Address]

    AND a.Phone = b.Phone;

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • October 24, 2014 at 11:34 am

    #1754718

    ChrisM@Work (10/24/2014)

    -- Changes MERGE JOIN to NESTED LOOPS, loses sort required for ROW_NUMBER()

    Would you mind explaining some more about this part?

    Thanks

  • October 24, 2014 at 1:40 pm

    #1754732

    sqldriver (10/24/2014)

    ChrisM@Work (10/24/2014)

    -- Changes MERGE JOIN to NESTED LOOPS, loses sort required for ROW_NUMBER()

    Would you mind explaining some more about this part?

    Thanks

    Sure. Have a good look at the actual execution plans first, I'll get back to you tomorrow.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

  • October 24, 2014 at 8:36 pm

    #1754756

    ChrisM@home (10/24/2014)

    sqldriver (10/24/2014)

    ChrisM@Work (10/24/2014)

    -- Changes MERGE JOIN to NESTED LOOPS, loses sort required for ROW_NUMBER()

    Would you mind explaining some more about this part?

    Thanks

    Sure. Have a good look at the actual execution plans first, I'll get back to you tomorrow.

    Oh, neat. I like that.

    What do you think about this? Borrowing a little Itzik Magik.

    WITH dupe1

    AS ( SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS RN ,

    a.BusinessName, a.[Address], a.Phone

    FROM TestBusiness a

    ),

    dupe2

    AS ( SELECT d.BusinessName, d.[Address], d.Phone

    FROM dupe1 d

    GROUP BY d.BusinessName, d.[Address], d.Phone

    HAVING COUNT(*) > 1

    )

    SELECT *

    FROM dupe1 d1

    INNER JOIN dupe2 d2

    ON d1.BusinessName = d2.BusinessName

    AND d1.[Address] = d2.[Address]

    AND d1.Phone = d2.Phone

    WHERE d1.RN > 1;

    The QE hates forcing a seek here, and forcing a hash join (was thinking if the actual tables are much larger, though it may use one anyway if they are) seems to result in 1 more ms CPU time, and one extra logical read.

    Compared with your examples, the IO and time output seem roughly the same, though I'd be interested to hear what you think about the far different execution plan.

    My tests include your suggested index.

    Anyway, looking forward to your response.

    Thanks

  • October 25, 2014 at 12:13 am

    #1754759

    An alternative solution which doesn't require any joining. It scales well for large sets but has a weakness of returning false positives although fairly unlikely with this type of data. As a bonus, the B_CHS (binary_checksum) column is a "distinct group name".

    😎

    ;WITH BASE_DATA AS

    (

    SELECT

    BINARY_CHECKSUM(B.Phone,CHAR(124), B.Address) AS B_CHS

    ,B.Business_pk

    FROM dbo.TestBusiness B

    )

    SELECT

    BD.B_CHS

    ,BD.Business_pk

    INTO #BD_SORT

    FROM BASE_DATA BD;

    CREATE UNIQUE NONCLUSTERED INDEX TMP_BD_SORT_DD ON #BD_SORT ( B_CHS ASC, Business_pk ASC);

    ;WITH BS_SORT AS

    (

    SELECT

    BS.Business_pk

    ,ROW_NUMBER() OVER (PARTITION BY BS.B_CHS ORDER BY BS.Business_pk ) AS BS_RID

    FROM #BD_SORT BS

    )

    SELECT * FROM BS_SORT WHERE BS_RID > 1;

    DROP TABLE #BD_SORT;

  • October 25, 2014 at 7:31 am

    #1754769

    Eirikur Eiriksson (10/25/2014)

    An alternative solution which doesn't require any joining. It scales well for large sets but has a weakness of returning false positives although fairly unlikely with this type of data. As a bonus, the B_CHS (binary_checksum) column is a "distinct group name".

    😎

    ;WITH BASE_DATA AS

    (

    SELECT

    BINARY_CHECKSUM(B.Phone,CHAR(124), B.Address) AS B_CHS

    ,B.Business_pk

    FROM dbo.TestBusiness B

    )

    SELECT

    BD.B_CHS

    ,BD.Business_pk

    INTO #BD_SORT

    FROM BASE_DATA BD;

    CREATE UNIQUE NONCLUSTERED INDEX TMP_BD_SORT_DD ON #BD_SORT ( B_CHS ASC, Business_pk ASC);

    ;WITH BS_SORT AS

    (

    SELECT

    BS.Business_pk

    ,ROW_NUMBER() OVER (PARTITION BY BS.B_CHS ORDER BY BS.Business_pk ) AS BS_RID

    FROM #BD_SORT BS

    )

    SELECT * FROM BS_SORT WHERE BS_RID > 1;

    DROP TABLE #BD_SORT;

    I was trying a similar approach, but couldn't get the results right. :blush:

    Upper/lowercase is throwing things off, I think.

    100 Musk Ox for you, sir.

    SET STATISTICS IO ON

    SET STATISTICS TIME ON;

    WITH dupe1

    AS ( SELECT --ROW_NUMBER() OVER (PARTITION BY ORDER BY ) AS RN ,

    a.Business_pk ,

    a.BusinessName ,

    a.[Address] ,

    a.Phone ,

    HASHBYTES('MD5',

    a.BusinessName + a.[Address] + a.Phone) AS [HashPit]

    FROM TestBusiness a

    ),

    dupe2

    AS ( SELECT * ,

    ROW_NUMBER() OVER ( PARTITION BY [HashPit] ORDER BY ( SELECT

    NULL

    ) ) AS RN

    FROM dupe1

    )

    SELECT d2.Business_pk ,

    d2.BusinessName ,

    d2.[Address] ,

    d2.Phone

    FROM dupe2 d2

    WHERE d2.RN > 1

Viewing 15 posts - 1 through 15 (of 30 total)

You must be logged in to reply to this topic. Login to reply