Rank duplicates, but only rows involved in duplicates

Question

Rank duplicates, but only rows involved in duplicates

Viewing 15 posts - 16 through 30 (of 30 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 1

sqldriver (10/25/2014)
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

You are on the right track there, a simple solution would be to "UPPER" the values before hashing. SHA1 is quite a lot cheaper computationally than MD5 and should be more than fit for purpose, gives a better distribution (less collisions) than binary_checksum but the latter is at least in the order of one magnitude faster, a little bit of a juggle there.

😎

sqldriver SSChampion Points: 10440 More actions · Answer 2

Eirikur Eiriksson (10/25/2014)

You are on the right track there, a simple solution would be to "UPPER" the values before hashing. SHA1 is quite a lot cheaper computationally than MD5 and should be more than fit for purpose, gives a better distribution (less collisions) than binary_checksum but the latter is at least in the order of one magnitude faster, a little bit of a juggle there.
😎

Oh, yeah, let me start nesting functions in a test harness with code from you and Chris. That'll go well :hehe:

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 3

sqldriver (10/25/2014)

Eirikur Eiriksson (10/25/2014)
You are on the right track there, a simple solution would be to "UPPER" the values before hashing. SHA1 is quite a lot cheaper computationally than MD5 and should be more than fit for purpose, gives a better distribution (less collisions) than binary_checksum but the latter is at least in the order of one magnitude faster, a little bit of a juggle there.
😎
Oh, yeah, let me start nesting functions in a test harness with code from you and Chris. That'll go well :hehe:

Keep in mind, there's no such thing as a bad code (if it works), your efforts are as worthy as mine any given day, keep up the good work!

😎

Jeff Moden SSC Guru Points: 1003869 More actions · Answer 4

Eirikur Eiriksson (10/25/2014)
Keep in mind, there's no such thing as a bad code (if it works), your efforts are as worthy as mine any given day, keep up the good work!
😎

I guess I'll have to take strong exception to that. I fix code that works everyday. Why does it need fixing? Many of the questions on this forum contain the answer to that very question. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

sqldriver SSChampion Points: 10440 More actions · Answer 5

Eirikur Eiriksson (10/25/2014)

sqldriver (10/25/2014)
Eirikur Eiriksson (10/25/2014)
You are on the right track there, a simple solution would be to "UPPER" the values before hashing. SHA1 is quite a lot cheaper computationally than MD5 and should be more than fit for purpose, gives a better distribution (less collisions) than binary_checksum but the latter is at least in the order of one magnitude faster, a little bit of a juggle there.
😎
Oh, yeah, let me start nesting functions in a test harness with code from you and Chris. That'll go well :hehe:
Keep in mind, there's no such thing as a bad code (if it works), your efforts are as worthy as mine any given day, keep up the good work!
😎

You have a much better attitude about it, and I appreciate that. There are bad questions (I've asked a lot of them), and bad code (I've written a lot of it). I'd define a bad question as one you didn't try to answer yourself, and bad code as anything you only tried to write one way. Or anything you write before you start visiting SSC 😀

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 6

Jeff Moden (10/25/2014)
Eirikur Eiriksson (10/25/2014)
Keep in mind, there's no such thing as a bad code (if it works), your efforts are as worthy as mine any given day, keep up the good work!
😎
I guess I'll have to take strong exception to that. I fix code that works everyday. Why does it need fixing? Many of the questions on this forum contain the answer to that very question. 😉

Guess another way putting it would be "there is code and then there is better code"

😎

Jeff Moden SSC Guru Points: 1003869 More actions · Answer 7

Eirikur Eiriksson (10/26/2014)
Jeff Moden (10/25/2014)
Eirikur Eiriksson (10/25/2014)
Keep in mind, there's no such thing as a bad code (if it works), your efforts are as worthy as mine any given day, keep up the good work!
😎
I guess I'll have to take strong exception to that. I fix code that works everyday. Why does it need fixing? Many of the questions on this forum contain the answer to that very question. 😉
Guess another way putting it would be "there is code and then there is better code"
😎

The way that I've had to come to look at it is "although it may "work", there is code that will cripple the server, disappoint the customer, and will get worse as scale increases... and then there is code written the right way".

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1003869 More actions · Answer 8

I usually go for a simple million row test but data is getting larger and larger so I thought I'd give everyone the opportunity to play with a table the size that the OP has. Hopefully, someone will come up with something better although finding 48 duplicate rows out of 22+ million isn't bad. As Chris pointed out, ROW_NUMBER() is awfully expensive here and some basis of Scott's code is the current winner Chris and I both used code similar to Scott's but the not original "range" method he used.

The following code will create a 22 million row table, which contains the original data submitted by the OP (along with some extra rows to make sure no cross-joins appear by having one set of dupes with 10 rows) and an addition 22 million rows virtually guaranteed to be unique across the 3 key columns.

Note that having an Address column of VARCHAR(MAX) is a bit impractical for many reasons. The first is that I've never seen an address longer than about 150 characters, the second being that you cannot index such a blob column, and the third being that (up until 2014 came out) you cannot rebuild the clustered index in an online fashion if the table contains a blob. With that in mind, I've limited the size of the Address column to VARCHAR(200).

Another not-so-obvious lesson here is that it's MUCH faster to insert 1007 rows as a single query that than to use 1007 separate inserts. It takes a lot less "volume" of code, as well. I did use (VALUES) because I wanted this to all work for someone that might still be stuck with 2005 (like I currently am at work).

Here's the code to build the 22+ million row table as previously described. Depending on what else your machine might be doing, it takes between 8 and 9 minutes to execute on my 4 core I5 laptop using SQL Server 2008 (non-R2). I STRONGLY recommend that you are NOT connected to the internet while running any of this code for the same reasons why you wouldn't on a real server.

--===== If you don't have a test database, uncomment this code to make one.

-- Otherwise, do this in your favorite test database.

-- Note that the test table will be ~4.4GB and the logfile will be ~4.0GB so I set both to 5GB.

-- The logfile is that big because of the index build and the index is nearly as large

-- as the data itself. 52 Seconds without IFI.

-- CREATE DATABASE Test;

-- ALTER DATABASE Test MODIFY FILE (NAME = Test , SIZE = 5000MB, FILEGROWTH = 100MB);

-- ALTER DATABASE Test MODIFY FILE (NAME = Test_log, SIZE = 5000MB, FILEGROWTH = 100MB);

-- ALTER DATABASE Test SET RECOVERY SIMPLE;

--GO

-- USE Test;

--GO

SELECT 'Switch to Messages Tab to view progress...' AS [Switch to Messages Tab to view progress...]

;

PRINT 'This run takes between 8 and 9 minutes to execute on my 4 core i5 laptop with 5GB of RAM for SQL Server.'

RAISERROR('

--============================================================================================================

-- Create the original test data (a bit more quickly) and add 10 million unique rows to the data to

-- provide a realistic test table more closely resembling the size of the real table.

--============================================================================================================

',0,0) WITH NOWAIT

;

RAISERROR('--===== Conditionally dropping the test table to make reruns in SSMS easier...',0,0) WITH NOWAIT;

IF OBJECT_ID('dbo.TestBusiness','U') IS NOT NULL

DROP TABLE dbo.TestBusiness

;

GO

--=====================================================================================================================

RAISERROR('--===== Building the test table. Note that the VARCHAR(MAX) has been changed to something more reasonable.',0,0) WITH NOWAIT

;

CREATE TABLE dbo.TestBusiness

(

Business_pk INT IDENTITY(1,1) NOT NULL,

BusinessName VARCHAR(200) NOT NULL,

Address VARCHAR(200) 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

--=====================================================================================================================

RAISERROR('--===== Populating the test table with the original test data...',0,0) WITH NOWAIT

;

DECLARE @StartTime DATETIME;

SELECT @StartTime = GETDATE()

;

INSERT INTO dbo.TestBusiness

(BusinessName, Address, Phone)

SELECT 'BCTB DPTMS','4501 RM 228 KILLEEN TX 76544',0 UNION ALL

SELECT 'DBA MARINE CARGO SERVICES INC','183 OSSIPEE TRL NULL LIMINGTON ME 4049',0 UNION ALL

SELECT 'Inc Arnold Investment Counsel','3960 HILLSIDE DR NULL DELAFIELD WI 53018',0 UNION ALL

SELECT 'LLC BRUNSWICK PLAZA','720 HOOSICK RD NULL TROY NY 12180',0 UNION ALL

SELECT 'LLC MULBERRY TEK','638 SE 4TH ST NULL LEES SUMMIT MO 64063',512577233 UNION ALL

SELECT 'LLC STERLING INTERNATIONAL','88 MAIN ST NULL GREENWICH NY 12834',0 UNION ALL

SELECT 'LLC WARREN E BAHR CPA','24 SOUTHMAYD RD STE 11 CAMPTON NH 3223',0 UNION ALL

SELECT 'dbo. 138 H E B GROCERY','101 N CROCKETT ELSA TX 78543',0 UNION ALL

SELECT 'dbo. 138 H E B GROCERY','101 N CROCKETT ELSA TX 78543',9562621501 UNION ALL

SELECT '&T AIRPORT HOSPITALITY LLC','32 HEATHERDOWN DR ROADRUNNER WESTERVILLE OH 43081',0 UNION ALL

SELECT '????','ROOSEVELT AVE WOODSIDE NY 11377',0 UNION ALL

SELECT '01 EMERGENCY A LOCKSMITH','2272 PINE WARBLER WAY MARIETTA GA 30062',7702500495 UNION ALL

SELECT '04 TRACY MAYFIELD','146 CHRISTY DR NULL CUYAHOGA FALLS OH 44223',330922523 UNION ALL

SELECT '1 24 Hour A Emerg Locksmith','4026 UNION ST FLUSHING NY 11354',3475424084 UNION ALL

SELECT '1 800 RADIATOR','1117 COBB PKWY S MARIETTA GA 30060',7704208600 UNION ALL

SELECT '1 STOP CD DVD DUPLICATION REP','428 8TH ST DEL MAR CA 92014',6267994696 UNION ALL

SELECT '1-800-Flowerscom Inc','1000 W ARKANSAS LN ARLINGTON TX 76013',8174613537 UNION ALL

SELECT '120 Cleaners','3125 ROSWELL RD MARIETTA GA 30062',7705650961 UNION ALL

SELECT '1294 Sterling Realty LLC','176 25 Union Tpke 216 Fresh Meadows NY 11366',7189690003 UNION ALL

SELECT '13 Holdings Inc','1110 South Ave Ste 403 New York NY 10001',9174182531 UNION ALL

SELECT '1508613 CS-PP FUNERAL HOME','331 S 4TH ST ROADRUNNER DANVILLE KY 40422',0 UNION ALL

SELECT '1625 S COBB DR LLC','1625 S COBB DR SE MARIETTA GA 30060',7707949333 UNION ALL

SELECT '1701 Cafe Inc','1707 BROADWAY NEW YORK NY 10019',2122455400 UNION ALL

SELECT '1784 Poinsettia Inc','1906 POINSETTA DR MARIETTA GA 30062',7709771178 UNION ALL

SELECT '1st AMERICAN ROADSIDE SERVICE','1610 RENEA CT NULL KEARNEY MO 64060',0 UNION ALL

SELECT '1st Choice On Line LLC','445 WINDY HILL RD SE MARIETTA GA 30060',7704310050 UNION ALL

SELECT '1st Nations Mortgage','2545 RAINTREE WAY NE MARIETTA GA 30068',7705796766 UNION ALL

SELECT '1st Superior Insurance Group I','1511 S COBB DR SE MARIETTA GA 30060',7705289088 UNION ALL

SELECT '2 Guys From Puna','17-4013 Kuaaina Rd Kurtistown HI 96760',8089666876 UNION ALL

SELECT '20/20 Eye Care Inc','4101 ROSWELL RD MARIETTA GA 30062',7705653970 UNION ALL

SELECT '2000 Concrete Structural','326 ROSWELL ST SE MARIETTA GA 30060',7704200733 UNION ALL

SELECT '2002 PERFORMANCE PARTS','3924 SENTRY WALK MARIETTA GA 30068',7709774923 UNION ALL

SELECT '21i Net Services AG','45 Rockefeller Plz 2071 New York NY 10111',2123322850 UNION ALL

SELECT '21ST CENTURY COMM LEARNING','PO BOX 440 JAMESTOWN KY 42629',2708663071 UNION ALL

SELECT '21st Century Realty','97 WINDY HILL RD SW MARIETTA GA 30060',6782137778 UNION ALL

SELECT '24 Hour 7 Day Emergency Locksm','1136 E COMMONS MARIETTA GA 30062',7704268848 UNION ALL

SELECT '24 Hour Emergency Locksmith','4880 LOWER ROSWELL RD MARIETTA GA 30068',6788040492 UNION ALL

SELECT '24 Hour Emergency Locksmith','903 ROSWELL ST NE MARIETTA GA 30060',7704222625 UNION ALL

SELECT '24 Hour Locksmith Service','1100 JOHNSON FERRY RD MARIETTA GA 30068',7705148989 UNION ALL

SELECT '24 HOURS PROFESSIONAL MOVERS','627 CHEROKEE ST NE MARIETTA GA 30060',7704207003 UNION ALL

SELECT '24 Hours Professional Movers','627 CHEROKEE ST NE MARIETTA GA 30060',7704207003 UNION ALL

SELECT '24 Hr 20 4 Locksmith Marietta','680 S MARIETTA PKWY SE MARIETTA GA 30060',7702500088 UNION ALL

SELECT '24 Hr Fast Locksmith','4101 ROSWELL RD MARIETTA GA 30062',6783030760 UNION ALL

SELECT '250 CLEANERS','4706 LOWER ROSWELL RD MARIETTA GA 30068',7705099600 UNION ALL

SELECT '2961 Assocs','Park Ave New York NY 10022',2127528656 UNION ALL

SELECT '2K TECHNOLOGIES','1165 ALLGOOD RD MARIETTA GA 30062',7703215603 UNION ALL

SELECT '3 BEARS MOVING CORP','14 WHALE SQ dbo. B BROOKLYN NY 11232',7185871161 UNION ALL

SELECT '3 D MANAGEMENT SVC INC','PO BOX 186 MADISON WV 25130',3043699286 UNION ALL

SELECT '3 D Printing Services Inc','246 17 Jamaica Ave Bellerose NY 11426',7183470530 UNION ALL

SELECT '3 Tcm Construction Cleani','1348 WATERFORD GREEN CLOSE MARIETTA GA 30068',7707950234 UNION ALL

SELECT '3 VITAL SOLUTIONS','1083 PRINCETON WALK NE MARIETTA GA 30068',7703648472 UNION ALL

SELECT '3 Vital Solutions LLC','PO BOX 681553 MARIETTA GA 30068',6785287713 UNION ALL

SELECT '3-Rs Movers & Delivery Svc','1805 ROSWELL RD MARIETTA GA 30062',7705652299 UNION ALL

SELECT '321 BATALLION','S INTERSTATE 35 AUSTIN TX 78741',0 UNION ALL

SELECT '333 SOUTH FIRST AVE LLC','61 LENOX AVE 333 SOUTH 1ST AVE NEW YORK NY 10026',0 UNION ALL

SELECT '359 SALTWATER DISPOSAL SYSTEM','1805 CLARK BLVD LAREDO TX 78043',9567247295 UNION ALL

SELECT '360 Corp','3479 MILL BRIDGE DR MARIETTA GA 30062',7704209199 UNION ALL

SELECT '365 Nutrition Inc','1205 JOHNSON FERRY RD MARIETTA GA 30068',7705093644 UNION ALL

SELECT '3b Properties LLC','2100 ROSWELL RD MARIETTA GA 30062',7709776657 UNION ALL

SELECT '3KENMAR PEDIATRICS II','700 CHURCH ST NE MARIETTA GA 30060',6782906831 UNION ALL

SELECT '3p Delivery Inc','1851 W OAK PKWY STE 100 MARIETTA GA 30062',7704244555 UNION ALL

SELECT '3rd Custom Drapery','3292 HOLLY SPRINGS RD MARIETTA GA 30062',7705091197 UNION ALL

SELECT '4 DZINES','3225 SHALLOWFORD RD MARIETTA GA 30062',7709779996 UNION ALL

SELECT '4 Dzines LLC','3225 SHALLOWFORD RD MARIETTA GA 30062',7709779996 UNION ALL

SELECT '4 Luv of Pets','PO BOX 682431 MARIETTA GA 30068',7705659820 UNION ALL

SELECT '4 R SERVICING','1503 PARKAIRE XING MARIETTA GA 30068',7706272958 UNION ALL

SELECT '4 WHEEL PARTS PERFORMANCE CTR','911 COBB PKWY N MARIETTA GA 30062',7704279840 UNION ALL

SELECT '4dnexus Com Inc','9450 Mira Mesa Blvd 615 San Diego CA 92126',8585301964 UNION ALL

SELECT '4r Cleaning Svcs','3203 IVORY TRL SW MARIETTA GA 30060',7704325202 UNION ALL

SELECT '4u2c Detailing LLC','2425 SEWELL MILL RD MARIETTA GA 30062',6785084735 UNION ALL

SELECT '5000 Inc','Coldwater Ter N Hollywood CA 91604',8185066442 UNION ALL

SELECT '553 CSSB','39002 RM E34B KILLEEN TX 76544',0 UNION ALL

SELECT '56 SOUTH STORAGE CTR','56 SIXTH ST DOVER NH 3820',6037424422 UNION ALL

SELECT '5th Generation Painting & Cont','1240 JOHNSON FERRY PL MARIETTA GA 30068',7709736995 UNION ALL

SELECT '5th Generation Roofing','1344 E COBB DR MARIETTA GA 30068',7705092525 UNION ALL

SELECT '64TH MP CO CQ DESK','16003 CQ EAST KILLEEN TX 76544',254287257 UNION ALL

SELECT '7 DAY ALWAYS EMERGENCY LCKSMTH','24930 HORACE HARDING EXPY FLUSHING NY 11362',7185359142 UNION ALL

SELECT '7-ELEVEN','PO BOX 757 MINERAL WELLS WV 26150',3044891255 UNION ALL

SELECT '7-Eleven Inc','131st St N Largo FL 33774',7275967894 UNION ALL

SELECT '790 THE ZONE','4101 ROSWELL RD MARIETTA GA 30062',7709776674 UNION ALL

SELECT '790 Zone','4101 ROSWELL RD MARIETTA GA 30062',7709776844 UNION ALL

SELECT '800 FLOWERS','1000 W ARKANSAS LN ARLINGTON TX 76013',8174613537 UNION ALL

SELECT '808 Surf N Skate','75 5695 Alii Dr Kailua Kona HI 96740',8083291100 UNION ALL

SELECT '84 LUMBER CO','RR 2 BOX 100 WILLIAMSTOWN WV 26187',3043756514 UNION ALL

SELECT '96 TRANSPORTATION CO 1-80 BN','39036 DAYROOM NULL KILLEEN TX 76544',254553174 UNION ALL

SELECT '96 TRANSPORTATION CO 1/80 BN','39036 DAYROOM KILLEEN TX 76544',0 UNION ALL

SELECT '99 Cents Plus LLC','923 19 Jamaica Ave Jamaica NY 11421',7184413033 UNION ALL

SELECT '553 CSSB','39002 RM E34B KILLEEN TX 76544',0 UNION ALL

SELECT 'A & A ALFA DRIVING SCHOOL','675 ROSWELL ST NE MARIETTA GA 30060',7707924404 UNION ALL

SELECT 'A & A Construction & Design','125 10 Queens Blvd Kew Gardens NY 11415',7185447878 UNION ALL

SELECT 'A & A Landscaping','187 CRANFILL RD SE MARIETTA GA 30060',7704992199 UNION ALL

SELECT 'A & A MEAT MARKET & GROCERY','PO BOX 75B MERCEDES TX 78570',9565659448 UNION ALL

SELECT 'A & A MOBILE NOTARY SVC','2255 SEWELL MILL RD STE 110 MARIETTA GA 30062',4044033133 UNION ALL

SELECT 'A & A Remodelers Inc','4270 STONEHAM TER MARIETTA GA 30068',7703216908 UNION ALL

SELECT 'A & A Termite & Pest Control','PO BOX 6506 MARIETTA GA 30065',7705780443 UNION ALL

SELECT 'A & B Flooring','45 934 Kam Hwy Kaneohe HI 96744',8082558090 UNION ALL

SELECT 'A & B Sunshine Taxi Service','1606 LOWER ROSWELL RD MARIETTA GA 30068',7709713100 UNION ALL

SELECT 'A & C Tropical Food Store Inc','316 S FAIRGROUND ST SE MARIETTA GA 30060',7704190025 UNION ALL

SELECT 'A & D Painting Inc','PO BOX 500654 ATLANTA GA 31150',7705095412 UNION ALL

SELECT 'A & E STAFFING','1165 ALLGOOD RD MARIETTA GA 30062',7709778144 UNION ALL

SELECT 'A & G Consulting','4419 DUNMORE RD NE MARIETTA GA 30068',6785609255 UNION ALL

SELECT 'A & G Friction','1830 AIRPORT IND PARK DR SE MARIETTA GA 30060',7709551987 UNION ALL

SELECT 'A & G Heating and AC Svcs','2370 WILLEO RILL RD MARIETTA GA 30062',7706426426 UNION ALL

SELECT 'A & I Petroleum Inc','22777 Main St Crown Point NY 12928',5185974242 UNION ALL

SELECT 'A & M Enterprises Intl','2363 MONTE VILLA CTS MARIETTA GA 30062',7705780468 UNION ALL

SELECT 'A & P Auto Service','1155 S COBB DR SE MARIETTA GA 30060',6782900990 UNION ALL

SELECT 'A & R Valley Radiator','Van Nuys CA 91401 Sherman Oaks CA 91401',8187631369 UNION ALL

SELECT 'A & S AUTO PARTS','PO BOX E MONTROSE PA 18801',5702784322 UNION ALL

SELECT 'A & S Convenience Stores Inc','901 MILFORD CHURCH RD SW MARIETTA GA 30060',7704310517 UNION ALL

SELECT 'A & S Glass & Metal Inc','310 S FAIRGROUND ST SE MARIETTA GA 30060',7704270664 UNION ALL

SELECT 'A & W Electrical Solutions','1805 ROSWELL RD APT 16E MARIETTA GA 30062',6783147525 UNION ALL

SELECT 'A 1 APPLIANCE','1710 HOWARD ST E LIVE OAK FL 32064',3863649305 UNION ALL

SELECT 'A 1 DRYWALL & ACOUSTICS','53 TATUM ST SW MARIETTA GA 30060',6787975599 UNION ALL

SELECT 'A 1 ENGINE PARTS CO','286 S FAIRGROUND ST SE MARIETTA GA 30060',7704274602 UNION ALL

SELECT 'A 1 People Count Inc','PO BOX 6384 MARIETTA GA 30065',6783547930 UNION ALL

SELECT 'A 1-American Plumbing','972 AZALEA CIR MARIETTA GA 30062',7704221450 UNION ALL

SELECT 'A A 24 Hour A A A Locksmith','1844 BISHOPS GREEN DR MARIETTA GA 30062',7702500916 UNION ALL

SELECT 'A A A Insurance Agency','4101 ROSWELL RD STE 301 MARIETTA GA 30062',7705655700 UNION ALL

SELECT 'A A ARROW MOVING & STORAGE INC','14 WHALE SQ BROOKLYN NY 11232',5168270347 UNION ALL

SELECT 'A A ARROW MOVING & STORAGE INC','14 WHALE SQ BROOKLYN NY 11232',7185576683 UNION ALL

SELECT 'A A Drain Cleaning Service','PO BOX 412 SHANNON GA 30172',7709732281 UNION ALL

SELECT 'A A Pet Kennel Inc','3910 WESLEY CHAPEL RD MARIETTA GA 30062',7709775542 UNION ALL

SELECT 'A A PET KENNELS INC','3910 WESLEY CHAPEL RD MARIETTA GA 30062',7709775542 UNION ALL

SELECT 'A A SCREEN PRINTING','1087 S MARIETTA PKWY SE MARIETTA GA 30060',6785815559 UNION ALL

SELECT 'A A TAXI CABS','2022 S COBB DR SE MARIETTA GA 30060',6782140888 UNION ALL

SELECT 'A A TAXI CABS','2022 S COBB DR SE MARIETTA GA 30060',6784372603 UNION ALL

SELECT 'A A Titan Stucco','1103 BAKER LN MARIETTA GA 30062',6787669563 UNION ALL

SELECT 'A A Waterproofing','130 MCLAREN GATES DR MARIETTA GA 30060',7704431155 UNION ALL

SELECT 'A Action Auto Trim','863 ROSWELL ST NE MARIETTA GA 30060',7707940123 UNION ALL

SELECT 'A All County Lock & Key','2754 GEORGIAN TER MARIETTA GA 30068',7705781198 UNION ALL

SELECT 'A AMERICAN SECURITY ALARM','PO BOX 37060 CLEVELAND OH 44137',3305629329 UNION ALL

SELECT 'A AN CTR','414 RIGBY ST NE MARIETTA GA 30060',7704275111 UNION ALL

SELECT 'A and M Grocery','FM 2360 E Side 23 Grulla TX 78548',9564876555 UNION ALL

SELECT 'A Approved Siding & Window Co','2343 PRINCE HOWARD WAY MARIETTA GA 30062',7709731835 UNION ALL

SELECT 'A ARNIES DEPENDABLE APPLIANCE','PO BOX 566 CRYSTAL BEACH FL 34681',7278489749 UNION ALL

SELECT 'A Around Clock Locksmith Inc','3603 SADLERS WALK MARIETTA GA 30068',7709739208 UNION ALL

SELECT 'A Assist Nurse','140 MARBLE MILL RD NW MARIETTA GA 30060',6783550043 UNION ALL

SELECT 'A AUTO INSURANCE WORLD','102 OHIO AVE N LIVE OAK FL 32064',3863627283 UNION ALL

SELECT 'A Awsome Installation','4696 LOWER ROSWELL RD MARIETTA GA 30068',7705657612 UNION ALL

SELECT 'A B & A TOWING & WRECKER SVC','PO BOX 154995 IRVING TX 75015',8175576433 UNION ALL

SELECT 'A B C Taxi Inc','47 N FAIRGROUND ST NE MARIETTA GA 30060',7704222927 UNION ALL

SELECT 'A B Construction','3454 MEADOW CHASE DR MARIETTA GA 30062',7705090301 UNION ALL

SELECT 'A B Duplicating Equipment Co','431 COMMERCE PARK DR SE MARIETTA GA 30060',7709718915 UNION ALL

SELECT 'A B PAINTING','3006 FAVOR PINES CT SW MARIETTA GA 30060',7704339076 UNION ALL

SELECT 'A Bacon Yacht Charter','55 BOAT BASIN NEW YORK NY 10024',2128737558 UNION ALL

SELECT 'A BAILEY FLOWERS','1000 W ARKANSAS LN ARLINGTON TX 76013',8178040038 UNION ALL

SELECT 'A Beautiful Backyard By C Pool','2265 ROSWELL RD STE 100 MARIETTA GA 30062',7709843249 UNION ALL

SELECT 'A Blessed Event Dj & Karaoke','2200 ROSWELL RD MARIETTA GA 30062',7705655113 UNION ALL

SELECT 'A BOX OUTLET','349 COBB PKWY N MARIETTA GA 30062',6789840797 UNION ALL

SELECT 'A BRIGHTER ORLANDO PRESSURE','PO BOX 221 WINTER PARK FL 32790',3216953553 UNION ALL

SELECT 'A Broadway Towing 24 Hrs','6469 Broadway New York NY 10001',7187323953 UNION ALL

SELECT 'A C BAER','4800 BELLINGHAM DR MARIETTA GA 30062',7706455911 UNION ALL

SELECT 'A Champion Kennel','983 F M 20 Bastrop TX 78602',5123211633 UNION ALL

SELECT 'A Charles Mellen & Associates','4076 CHARRWOOD TRCE MARIETTA GA 30062',7706440000 UNION ALL

SELECT 'A CHILDS PLACE OF COBB','57 MERRITT ST SE MARIETTA GA 30060',7704271368 UNION ALL

SELECT 'A Classy Flea','PO BOX 850 MARIETTA GA 30061',7705792555 UNION ALL

SELECT 'A CONSUMERS CHOICE','1706 LOWER ROSWELL RD MARIETTA GA 30068',7709736076 UNION ALL

SELECT 'A Custom Pest Service Inc','152 SOUTH AVE SE STE 3 MARIETTA GA 30060',7704246073 UNION ALL

SELECT 'A Delghtful Bitefull Catrg LLC','2235 SEWELL MILL RD MARIETTA GA 30062',7705917370 UNION ALL

SELECT 'A DIACHISHIN & ASSOC','PO BOX 369 NAPANOCH NY 12458',8456476514 UNION ALL

SELECT 'A G EDWARDS & SONS INC','1 DEPOT ST NE STE 100 MARIETTA GA 30060',7704250104 UNION ALL

SELECT 'A Glass Act','3266 MITSY FOREST WAY NE MARIETTA GA 30068',7705090047 UNION ALL

SELECT 'A Grade Inc','1823 BALDWIN FARMS DR MARIETTA GA 30068',7705874833 UNION ALL

SELECT 'A J Consultants & Associates','3080 BROOKVIEW DR MARIETTA GA 30068',7709771337 UNION ALL

SELECT 'A J R Inc','1225 JOHNSON FERRY RD MARIETTA GA 30068',7705653753 UNION ALL

SELECT 'A J R Inc','3101 ROSWELL RD MARIETTA GA 30062',7705658663 UNION ALL

SELECT 'A J R Inc','4819 LOWER ROSWELL RD MARIETTA GA 30068',7709731125 UNION ALL

SELECT 'A K DESIGN','897 FAWN WAY MARIETTA GA 30068',7703569127 UNION ALL

SELECT 'A LA MODE','71 MAIN ST CHAGRIN FALLS OH 44022',4402476200 UNION ALL

SELECT 'A LADYS COMPUTER MECHANIC','6062 UNIVERSITY AVE SAN DIEGO CA 92115',6195837226 UNION ALL

SELECT 'A Little Enterprise LLC','2972 MONTVIEW DR SW MARIETTA GA 30060',7708030607 UNION ALL

SELECT 'A LOCKSMITH ALWAYES 24 HR','2174 KINRIDGE RD MARIETTA GA 30062',7702500984 UNION ALL

SELECT 'A M F Supply Inc','814 PICKENS INDUSTRIAL DR MARIETTA GA 30062',7708744115 UNION ALL

SELECT 'A Monarch Enterprise','PO BOX 1518 MABLETON GA 30126',7704387094 UNION ALL

SELECT 'A NEW LIFE','1584 ROSWELL RD MARIETTA GA 30062',7703664045 UNION ALL

SELECT 'A O Smith Corporation','4001 Frederick Rd El Paso TX 79905',9156291600 UNION ALL

SELECT 'A OCEAN BLUE','2825 WENDY LN MARIETTA GA 30062',6785609887 UNION ALL

SELECT 'A Oyelere Dr','1486 SOARING POINTE MARIETTA GA 30062',7704995033 UNION ALL

SELECT 'A P BEAUREGARD HARDWOOD & TILE','PO BOX 655 GLEN NH 3838',6033560081 UNION ALL

SELECT 'A Passion For Pets LLC','2900 CREEK PARK DR MARIETTA GA 30062',7709716259 UNION ALL

SELECT 'A Peachy Keen Plumbing Company','2770 WENDY LN MARIETTA GA 30062',7705796689 UNION ALL

SELECT 'A Perfect Party Inc','3101 ROSWELL RD STE H MARIETTA GA 30062',7705655558 UNION ALL

SELECT 'A PLACE OF REFUGE FOR WOMEN','PO BOX 240695 MILWAUKEE WI 53224',4144766333 UNION ALL

SELECT 'A Plus Insurance Agency Inc','3020 ROSWELL RD MARIETTA GA 30062',7705092331 UNION ALL

SELECT 'A PLUS QUALITY REMODELING SVC','3151 BUNKER HILL CIR MARIETTA GA 30062',4042711918 UNION ALL

SELECT 'A Precision Secretarial S','San Diego 92124 San Diego CA 92101',8582927661 UNION ALL

SELECT 'A PRESIDENTIAL LIMOUSINE SVC','4550 WENDEN LN MARIETTA GA 30062',6784097959 UNION ALL

SELECT 'A Priori Solutions Inc','3338 WOODSFIELD DR NE MARIETTA GA 30062',7709730347 UNION ALL

SELECT 'A Psychic Reading','1653 LOWER ROSWELL RD MARIETTA GA 30068',7709711605 UNION ALL

SELECT 'A Quality Pool Products Inc','614 COBB PKWY N MARIETTA GA 30062',7704197119 UNION ALL

SELECT 'A Rembrant Reproduction I','2843 EVA LEE CT NE MARIETTA GA 30062',7709717998 UNION ALL

SELECT 'A SHEAR EDGE','RR 1 BOX 300 INTERVALE NH 3845',6033567734 UNION ALL

SELECT 'A SHEAR THING','RR 3 BOX 16 PARKERSBURG WV 26101',3044288787 UNION ALL

SELECT 'A SOUTHERN SECURITY CO','3186 LASSITER RD MARIETTA GA 30062',7707898886 UNION ALL

SELECT 'A Staffing Solution Inc','732 CHEROKEE ST NE STE A MARIETTA GA 30060',6788870784 UNION ALL

SELECT 'A SUPERIOR CONTRACTING','1523 ROSWELL RD APT 416 MARIETTA GA 30062',6789733825 UNION ALL

SELECT 'A T & T','2370 WAKITA DR SE MARIETTA GA 30060',7704344036 UNION ALL

SELECT 'A T & T','2885 SURREY LN SW MARIETTA GA 30060',7704389234 UNION ALL

SELECT 'A T & T','4250 ROSWELL RD STE 300 MARIETTA GA 30062',7703212220 UNION ALL

SELECT 'A T & T WIRELESS','1197 JOHNSON FERRY RD MARIETTA GA 30068',7703212220 UNION ALL

SELECT 'A T LAWN CARE','17 JUDY DR SW MARIETTA GA 30060',7704328128 UNION ALL

SELECT 'A Team Landscaping','750 WOODMONT DR MARIETTA GA 30062',7709717327 UNION ALL

SELECT 'A THOUSAND THANK YOUS','3655 BRISBANE DR MARIETTA GA 30062',0 UNION ALL

SELECT 'A Top Realty','901 MILL STONE DR MARIETTA GA 30062',7703214757 UNION ALL

SELECT 'A TOWING CO','253 E END AVE NEW YORK NY 10128',2126168675 UNION ALL

SELECT 'A Unique Sleep Shop Inc','220 COBB PKWY N STE 100 MARIETTA GA 30062',7704273382 UNION ALL

SELECT 'A V X Corporation','PO BOX 867 CONWAY SC 29528',8433474627 UNION ALL

SELECT 'A Wealth of Health','3286 HICKORY BLUFF DR MARIETTA GA 30062',7709775596 UNION ALL

SELECT 'A Wise Solution Inc','4612 VILLA CHASE DR NE MARIETTA GA 30068',7705794635 UNION ALL

SELECT 'A Wright Construction','635 BIRCHWOOD LN SW MARIETTA GA 30060',7708018697 UNION ALL

SELECT 'A&J Flowers & Gifts','326 ROSWELL ST SE MARIETTA GA 30060',6783542117 UNION ALL

SELECT 'A&L CONSTRUCTION','3422 WOODRUN TRL MARIETTA GA 30062',0 UNION ALL

SELECT 'A&P Enterprises Inc','1794 JAMES RAY DR SE MARIETTA GA 30060',6785081005 UNION ALL

SELECT 'A&P Landscaping & Lawn Care','2977 KAREN LN MARIETTA GA 30062',7709717572 UNION ALL

SELECT 'A&W Automotive Svc','1710 S COBB DR SE MARIETTA GA 30060',7704248033 UNION ALL

SELECT 'A-1 DUI & DEFENSIVE DRIVING','607 ROSWELL ST NE MARIETTA GA 30060',7704271911 UNION ALL

SELECT 'A-1 KEY & LOCK','819 HOWARD ST W LIVE OAK FL 32064',3863621170 UNION ALL

SELECT 'A-1 Lawn Maintenance','2622 N Beckley Rd De Soto TX 75115',9722241969 UNION ALL

SELECT 'A-1 Tattooing','669 ROSWELL ST NE MARIETTA GA 30060',7704265794 UNION ALL

SELECT 'A-1 TIRE & TOWING','PO BOX 105 DIMOCK PA 18816',5702783111 UNION ALL

SELECT 'A-AMERICAN SECURITY','PO BOX 37060 CLEVELAND OH 44137',4404426161 UNION ALL

SELECT 'A-List Inc','1334 BISON AVE NEWPORT BEACH CA 92660',9497605017 UNION ALL

SELECT 'A-PLUS UPHOLSTERY','2822 FORSYTH RD dbo. 90 WINTER PARK FL 32792',4076788832 UNION ALL

SELECT 'A-TEAM LANDSCAPING','750 WOODMONT DR MARIETTA GA 30062',7703784945 UNION ALL

SELECT 'A/R Lenders Inc','977 BRICKLEBERRY LN MARIETTA GA 30062',7705786504 UNION ALL

SELECT 'A1 Action Cash Inc','431 PAT MELL RD SE MARIETTA GA 30060',7704330990 UNION ALL

SELECT 'A1 Auto Parts & Salvage','US Hgwy 1 Bunnell FL 32110',3864373438 UNION ALL

SELECT 'A1 Drywall & Acoustics','53 TATUM ST SW MARIETTA GA 30060',6787975599 UNION ALL

SELECT 'A1 Japanese Auto','1587 LOWER ROSWELL RD MARIETTA GA 30068',7705780982 UNION ALL

SELECT 'A1 Mini Store Inc','1925 S COBB DR SE MARIETTA GA 30060',7704365545 UNION ALL

SELECT 'A2z Remodeling LLC','701 CREEKWOOD DR MARIETTA GA 30068',7705787676 UNION ALL

SELECT 'AA Atlanta Emergency Locksmith','180 HOLT RD NE MARIETTA GA 30068',7709710348 UNION ALL

SELECT 'AA HOLISTIC HEALTH CARE','PO BOX 174 MABLETON GA 30126',7708817564 UNION ALL

SELECT 'AA Screen Printing Supplier','1087 S MARIETTA PKWY SE MARIETTA GA 30060',7708500110 UNION ALL

SELECT 'AA Taxi Cabs','901 ROSWELL ST NE MARIETTA GA 30060',6782131523 UNION ALL

SELECT 'AAA ACCOUNTING PROFESSIONALS','2095 HARTFORD CT MARIETTA GA 30068',7705792070 UNION ALL

SELECT 'AAA Aiea Pain Relief Chiroprac','99 128 Aiea Heights Dr Aiea HI 96701',8084868585 UNION ALL

SELECT 'AAA ANDERSON HEATING & AIR','2100 ROSWELL RD MARIETTA GA 30062',4044560598 UNION ALL

SELECT 'AAA AUTO ELECTRIC','1302 HOWARD ST E LIVE OAK FL 32064',3863641206 UNION ALL

SELECT 'AAA CONSTRUCTION','214 VALLADOLID AVE LAREDO TX 78046',9567253805 UNION ALL

SELECT 'AAA Digital Imaging Inc','1529 ROSWELL RD MARIETTA GA 30062',7705780331 UNION ALL

SELECT 'AAA Home Buyers Guide','2100 ROSWELL RD STE 200C MARIETTA GA 30062',4045242001 UNION ALL

SELECT 'AAA LANGLEY-ST CLAIR SIGNS','2752 BRIDGEGATE TRCE NE MARIETTA GA 30068',7708279113 UNION ALL

SELECT 'AAA MINI STORAGE','PO BOX 229 SPENCER IN 47460',8128762990 UNION ALL

SELECT 'AAA NON-PROFIT HIV/STD TESTING','140 LACY ST NW STE C MARIETTA GA 30060',7700001111 UNION ALL

SELECT 'AAA NON-PROFIT HIV/STD TESTING','790 CHURCH ST NE STE 200 MARIETTA GA 30060',7700001111 UNION ALL

SELECT 'AAA NORTHEAST PENN','RR 7 BOX 7132 MONTROSE PA 18801',5702781551 UNION ALL

SELECT 'AAA Rolands Coiffures Ltd','Park Rd Shop Ctr Charlotte NC 28209',7045230343 UNION ALL

SELECT 'AAA TRANSMISSIONS','PO BOX 1603 CRAB ORCHARD WV 25827',3042527184 UNION ALL

SELECT 'AAA Viva Moving Inc','5 53rd St B Brooklyn NY 11232',7188360407 UNION ALL

SELECT 'AAAA Automotive Repair Inc','476 COBB PKWY N MARIETTA GA 30062',6785818488 UNION ALL

SELECT 'AAAA Landscaping','201 CHEROKEE ST NE MARIETTA GA 30060',4042852818 UNION ALL

SELECT 'Aaabco Lock & Key Inc','4350 CORNWALLIS CT NE MARIETTA GA 30068',7709719453 UNION ALL

SELECT 'AAFES - GAS STATION','P2140 NASH BLVD FORT DRUM NY 13602',0 UNION ALL

SELECT 'Aagard & Associates Cnstr Co','2081 BISHOP CREEK DR MARIETTA GA 30062',7709926668 UNION ALL

SELECT 'AAMODT INC','PO BOX 1208 BONNERS FERRY ID 83805',2082673269 UNION ALL

SELECT 'Aaron Brothers Inc','1197 JOHNSON FERRY RD MARIETTA GA 30068',6782850800 UNION ALL

SELECT 'AARON COMMUNICATIONS','4381 KARLS GATE DR MARIETTA GA 30068',7703218746 UNION ALL

SELECT 'AARON LAMP','483 SUMNER ST NULL AKRON OH 44304',0 UNION ALL

SELECT 'AARON MARKETING','1824 LOWER ROSWELL RD MARIETTA GA 30068',7709770550 UNION ALL

SELECT 'Aaron Rents Inc','1710 COBB PKWY S MARIETTA GA 30060',7708189416 UNION ALL

SELECT 'Aaron Rents Inc','1736 COBB PKWY S MARIETTA GA 30060',7709556923 UNION ALL

SELECT 'Aaron Spelling Production','Van Nuys CA 91411 Sherman Oaks CA 91411',8187782330 UNION ALL

SELECT 'AARONS SALES & LEASE OWNERSHIP','180 COBB PKWY S MARIETTA GA 30060',7709197668 UNION ALL

SELECT 'AARONS SALES & LEASE OWNERSHIP','905 HIGHWAY 9 BYP E LANCASTER SC 29720',8033135988 UNION ALL

SELECT 'AB GALLERY','156 CHURCH ST NE MARIETTA GA 30060',6782908747 UNION ALL

SELECT 'AB Restaurant Corp','180a Main St Fort Lee NJ 7024',2014615151 UNION ALL

SELECT 'AB Sales Co Inc','PO BOX 6488 MARIETTA GA 30065',7709736243 UNION ALL

SELECT 'Abacus Employment Inc','1800 ROSWELL RD STE 3020 MARIETTA GA 30062',7705092490 UNION ALL

SELECT 'ABBA TOWING','PO BOX 154995 IRVING TX 75015',9727171445 UNION ALL

SELECT 'Abba Towing','PO BOX 154995 IRVING TX 75015',9727171445 UNION ALL

SELECT 'ABBACOR LIMITED','1953 RIVER FOREST DR MARIETTA GA 30068',7705873440 UNION ALL

SELECT 'Abbe General Contractor','San Diego 92117 San Diego CA 92117',6192768133 UNION ALL

SELECT 'Abbey David Design','5320 W BANK DR MARIETTA GA 30068',7706509782 UNION ALL

SELECT 'ABBEY MINI STORAGE','607 GOLDKIST BLVD SW LIVE OAK FL 32064',3863645300 UNION ALL

SELECT 'Abbott C & I LP','605 OAKLEDGE DR NW MARIETTA GA 30060',7704277500 UNION ALL

SELECT 'ABC','RR 6 BOX 6022 MONTROSE PA 18801',5702789824 UNION ALL

SELECT 'ABC Mailing Systems','850 PICKENS INDUSTRIAL DR MARIETTA GA 30062',7704247743 UNION ALL

SELECT 'ABC Recycling','595 COBB PKWY N MARIETTA GA 30062',6782909866 UNION ALL

SELECT 'ABC Wood Products Inc','470 N SESSIONS ST NW MARIETTA GA 30060',7704265747 UNION ALL

SELECT 'ABC-TAXI','47 N FAIRGROUND ST NE STE 4 MARIETTA GA 30060',7704222927 UNION ALL

SELECT 'Abcom Inc','2020 AIRPORT IND PARK DR SE MARIETTA GA 30060',7709569226 UNION ALL

SELECT 'ABCOM INC','2050 AIRPORT INDUSTRIAL PARK D MARIETTA GA 30060',7709569226 UNION ALL

SELECT 'Abconcepts Inc','3020 ROSWELL RD STE 200 MARIETTA GA 30062',7704101191 UNION ALL

SELECT 'ABDULRAHMA ALDOSSARI','142 ELIZABETH PKWY NULL AKRON OH 44304',0 UNION ALL

SELECT 'Abercrombie & Fitch Co','4479 ROSWELL RD RM 800 MARIETTA GA 30062',7709717124 UNION ALL

SELECT 'ABERCROMBIE LAND SVC','3387 SEWELL MILL RD MARIETTA GA 30062',4048639190 UNION ALL

SELECT 'Abernathy Design','3313 EMORY DR MARIETTA GA 30062',7709775007 UNION ALL

SELECT 'ABG CLEANING SVCS','1051 CLUBLAND CT MARIETTA GA 30068',7705793291 UNION ALL

SELECT 'ABISON CO','148 TIMBER CREEK LN SW MARIETTA GA 30060',7704320301 UNION ALL

SELECT 'Abitibi Consolidated Sls Corp','1509 JOHNSON FERRY RD MARIETTA GA 30062',7709733358 UNION ALL

SELECT 'Abl Management','1100 S MARIETTA PKWY SE MARIETTA GA 30060',7704229121 UNION ALL

SELECT 'Able Asphalt & Paving Co','PO BOX 1270 HIRAM GA 30141',7704247937 UNION ALL

SELECT 'Able Construction Inc','15 N MAIN ST FRANKFORT OH 45628',7407755666 UNION ALL

SELECT 'ABLE CONSTRUCTION INC','15 MAIN ST FRANKFORT OH 45628',7407755666 UNION ALL

SELECT 'ABLE DISTRIBUTORS INC','96-1276 WAIHONA ST STE 118 PEARL CITY HI 96782',8084566600 UNION ALL

SELECT 'ABLE FAST PRINTERS','1230 JOHNSON FERRY PL MARIETTA GA 30068',7709719032 UNION ALL

SELECT 'Able Fast Printers','1230 JOHNSON FERRY PL MARIETTA GA 30068',7709719032 UNION ALL

SELECT 'Able Heating Air','2930 LAKEMONT DR SW MARIETTA GA 30060',7704389628 UNION ALL

SELECT 'Able Investigations LLC','1401 JOHNSON FERRY RD MARIETTA GA 30062',7707899250 UNION ALL

SELECT 'Able Plastics Inc','3700 ROSWELL RD MARIETTA GA 30062',7705651522 UNION ALL

SELECT 'Able Real Estate Inc','2100 ROSWELL RD MARIETTA GA 30062',7709777017 UNION ALL

SELECT 'ABPA','PO BOX 819015 DALLAS TX 75381',9724246269 UNION ALL

SELECT 'Abra Inc','1770 COBB PKWY S MARIETTA GA 30060',7709561134 UNION ALL

SELECT 'ABRACADABRA','5184 TALL OAK DR MARIETTA GA 30068',7709929843 UNION ALL

SELECT 'Abracdbra Crses Fmly Vacations','1735 ROSWELL RD STE 100 MARIETTA GA 30062',7705098080 UNION ALL

SELECT 'Abrakadoodle','2663 JOHNSON FERRY RD MARIETTA GA 30062',7705799800 UNION ALL

SELECT 'ABRAMS INDUSTRIES INC','PO BOX 724728 ATLANTA GA 31139',7709530304 UNION ALL

SELECT 'Abrasive Suppliers Company','PO BOX 70052 MARIETTA GA 30007',7709937258 UNION ALL

SELECT 'ABREGO TRUCKING SVC & AUTO','PO BOX 3038 MCALLEN TX 78502',9563160736 UNION ALL

SELECT 'ABREGO TRUCKING SVC & AUTO SLS','PO BOX 3038 MCALLEN TX 78502',9563164409 UNION ALL

SELECT 'ABS PARTNERS REAL ESTATE','915 BROADWAY ABS PARTNERS REAL NEW YORK NY 10010',0 UNION ALL

SELECT 'Absolute Business Works Inc','4558 WENDEN LN MARIETTA GA 30062',7705871565 UNION ALL

SELECT 'Absolute Hair','612 SW 3RD ST STE C LEES SUMMIT MO 64063',8162467467 UNION ALL

SELECT 'ABSTRACT & TITLE','111 HOWARD ST E LIVE OAK FL 32064',3863622717 UNION ALL

SELECT 'Abstract Electric Corp','111 N MARIETTA PKWY NE MARIETTA GA 30060',6784292080 UNION ALL

SELECT 'Abundant Harvst Hme Brewg/Wine','Vestal Plz Binghamton NY 13903',6077294798 UNION ALL

SELECT 'ABUNDANT HEALTH & WELLNESS','2058 LOWER ROSWELL RD MARIETTA GA 30068',6784452746 UNION ALL

SELECT 'Abundant Health & Wellness Ctr','2058 LOWER ROSWELL RD MARIETTA GA 30068',6785608815 UNION ALL

SELECT 'ABUNDANT LIFE MASSAGE & CHIRO','2231 ROBINSON RD NE STE C MARIETTA GA 30068',7709735775 UNION ALL

SELECT 'Abundant Life Wellness Center','2231 ROBINSON RD NE STE C MARIETTA GA 30068',7709735775 UNION ALL

SELECT 'Abundnt Hlth Neuromusclr Thrpy','612 SW 3RD ST STE B LEES SUMMIT MO 64063',8165244230 UNION ALL

SELECT 'AC DC TAVERN','905 HELVENSTON ST SE LIVE OAK FL 32064',3863643291 UNION ALL

SELECT 'AC Help Care Services','445 WINDY HILL RD SE MARIETTA GA 30060',7704344643 UNION ALL

SELECT 'AC Miller Corporation','3251 RUNNING CEDAR DR MARIETTA GA 30062',7705095535 UNION ALL

SELECT 'ACACIA ANALYTICS','3624 HIGH GREEN DR MARIETTA GA 30068',7705657630 UNION ALL

SELECT 'Acacia Jewelry','91 1401 Frt Wver Rd A10 Ewa Beach HI 96706',8086854714 UNION ALL

SELECT 'Academic Solutions Inc','4220 SHALLOWFORD RD MARIETTA GA 30062',7706497874 UNION ALL

SELECT 'ACADEMY FINANCIAL SVC','551 JOHNSON FERRY RD MARIETTA GA 30068',6785600379 UNION ALL

SELECT 'Academy Locksmith','W Sunset Blvd N Los Angeles CA 90028',3234641117 UNION ALL

SELECT 'ACADEMY ROOFING INC','200 COBB PKWY N MARIETTA GA 30062',7704261131 UNION ALL

SELECT 'ACADEMY SPORTS OUTDOORS','N LOOP 1604 W SAN ANTONIO TX 78258',0 UNION ALL

SELECT 'Acadia Coffee Service Inc','1165 ALLGOOD RD STE 17 MARIETTA GA 30062',7704218003 UNION ALL

SELECT 'ACADIA COFFEE SVC INC','1165 ALLGOOD RD MARIETTA GA 30062',7709737207 UNION ALL

SELECT 'ACADIA COFFEE SVC INC','819 PICKENS INDUSTRIAL DR STE 13 MARIETTA GA 30062',7704218003 UNION ALL

SELECT 'ACC Auto Sales','1784 LOWER ROSWELL RD MARIETTA GA 30068',7709738933 UNION ALL

SELECT 'ACCELERATED CLEANING SYSTEMS','1085 COBB PKWY S MARIETTA GA 30060',7705148448 UNION ALL

SELECT 'Accelerated Cleaning Systems I','1085 COBB PKWY S MARIETTA GA 30060',7705148448 UNION ALL

SELECT 'Accent Awnings Inc','508 COMMERCE PARK DR SE MARIETTA GA 30060',7709980222 UNION ALL

SELECT 'Accent Ceramics','712 LAWRENCE ST NE MARIETTA GA 30060',7704245500 UNION ALL

SELECT 'Accent On Health','1501 JOHNSON FERRY RD MARIETTA GA 30062',7703211569 UNION ALL

SELECT 'Accent On Pet Care Inc','1343 GRESHAM RD MARIETTA GA 30062',7709710476 UNION ALL

SELECT 'Accent Painting','2341 MONTEREY DR NE MARIETTA GA 30068',7709733742 UNION ALL

SELECT 'Accentum Tech Partners LLC','PO BOX 681443 MARIETTA GA 30068',6785768140 UNION ALL

SELECT 'ACCESS JAPAN INC','360 WILLOW GLEN DR MARIETTA GA 30068',4042613317 UNION ALL

SELECT 'ACCESS REHABILITATION','50 PLAZA WAY NW MARIETTA GA 30060',7707926562 UNION ALL

SELECT 'Accord Services LLC','127 CHURCH ST NE STE 200 MARIETTA GA 30060',7704210191 UNION ALL

SELECT 'Accounting Consultants Cobb','3901 ROSWELL RD STE 130 MARIETTA GA 30062',7704250518 UNION ALL

SELECT 'ACCOUNTING CONSULTANTS-COBB','3901 ROSWELL RD STE 130 MARIETTA GA 30062',7709735500 UNION ALL

SELECT 'Accounting Management Inc','1744 ROSWELL RD MARIETTA GA 30062',7709731358 UNION ALL

SELECT 'Accumed Home Health','2809 LASSITER RD MARIETTA GA 30062',7705874505 UNION ALL

SELECT 'Accurate Business Service','228 PAT MELL RD SW MARIETTA GA 30060',7704368955 UNION ALL

SELECT 'Accurate Electronics Inc','PO BOX 12076 DURHAM NC 27709',9195582200 UNION ALL

SELECT 'Accurate Insurance Marketing','909 COBB PKWY N STE 106 MARIETTA GA 30062',7709719981 UNION ALL

SELECT 'Accutemp Heating-Cooling Inc','869 PICKENS INDUSTRIAL DR MARIETTA GA 30062',7707951061 UNION ALL

SELECT 'Acd Mine','Hgwy 17 A Moncks Corner SC 29461',8437616269 UNION ALL

SELECT 'Ace Auto Parts Towing & RPS','1550 W OAK DR MARIETTA GA 30062',7704193331 UNION ALL

SELECT 'Ace Commercial Ceaning Sv','2860 MEADOW DR MARIETTA GA 30062',7706420799 UNION ALL

SELECT 'Ace Draperies Company','4948 LOWER ROSWELL RD MARIETTA GA 30068',7703211312 UNION ALL

SELECT 'ACE ELECTRICAL SVC INC','436 WALLACE RD MARIETTA GA 30062',7709718767 UNION ALL

SELECT 'Ace Health Care Training Inst','8 S MORRIS ST DOVER NJ 7801',9733667171 UNION ALL

SELECT 'ACE INA HOLDINGS INC','1601 CHESTNUT ST PHILADELPHIA PA 19103',2156401000 UNION ALL

SELECT 'ACE INSURANCE','903 ROSWELL ST NE MARIETTA GA 30060',6783547930 UNION ALL

SELECT 'ACE MANAGEMENT SVC','1380 FAIR OAKS AVE SE MARIETTA GA 30060',7708423733 UNION ALL

SELECT 'ACE MINI STORAGE','300 WADE ST SILSBEE TX 77656',4093857973 UNION ALL

SELECT 'ACE ROOFING','10242 ARAPAHOE DR INDIANAPOLIS IN 46235',3176266741 UNION ALL

SELECT 'ACE ROOFING','10242 ARAPAHOE DR INDIANAPOLIS IN 46235',3178952964 UNION ALL

SELECT 'Ace Signs Inc','93 BARBER RD SE MARIETTA GA 30060',7704197971 UNION ALL

SELECT 'Ace Special Tours','PO BOX 4982 MARIETTA GA 30061',7704242722 UNION ALL

SELECT 'Aces Design & Build','615d E Abram St 500 Arlington TX 76010',8176897573 UNION ALL

SELECT 'ACG','550 GRAMERCY DR NE MARIETTA GA 30068',7709713722 UNION ALL

SELECT 'Achieve Global Inc','3031 GANT QUARTERS CIR MARIETTA GA 30068',6785604798 UNION ALL

SELECT 'ACKERMAN-JOHNSON SQUARE LLC','1509 JOHNSON FERRY RD MARIETTA GA 30062',6783849270 UNION ALL

SELECT 'ACKUE INTERNATIONAL','1165 ALLGOOD RD MARIETTA GA 30062',7705658557 UNION ALL

SELECT 'ACORDIA','PO BOX 1389 DANVILLE WV 25053',3043697239 UNION ALL

SELECT 'Acousti Interior Contractors','1420 WHITE CIR NW MARIETTA GA 30060',7704259028 UNION ALL

SELECT 'Acreide of Sicily','725 Rte 32 Tillson Rosendale NY 12472',8456583835 UNION ALL

SELECT 'ACROSS ATLANTA INSURANCE','1800 ROSWELL RD MARIETTA GA 30062',6785604663 UNION ALL

SELECT 'Acrsnet Inc','1751 LOWER ROSWELL RD MARIETTA GA 30068',7705781312 UNION ALL

SELECT 'Acsi Web Hosting','28 WINTERS ST SE MARIETTA GA 30060',7704293995 UNION ALL

SELECT 'Act 3 Productions Inc','1810 SHELBURNE RDG MARIETTA GA 30068',7705526670 UNION ALL

SELECT 'ACTION APPRAISALS','3162 JOHNSON FERRY RD MARIETTA GA 30062',7705921112 UNION ALL

SELECT 'ACTION AUTO GLASS','4701 DISTRIBUTION CT STE 5 ORLANDO FL 32822',4075999234 UNION ALL

SELECT 'ACTION CRITTER & BEE CONTROL','3365 CREEK HOLLOW DR MARIETTA GA 30062',7709734414 UNION ALL

SELECT 'Action International','4994 LOWER ROSWELL RD MARIETTA GA 30068',7706496730 UNION ALL

SELECT 'ACTION REAL ESTATE MANAGEMENT','1650 BARNES MILL RD MARIETTA GA 30062',6782909174 UNION ALL

SELECT 'Action Shredding LLC','552 COBB PKWY S STE B MARIETTA GA 30060',7707928131 UNION ALL

SELECT 'ACTION TRANSMISSION','4696 LOWER ROSWELL RD MARIETTA GA 30068',6785606615 UNION ALL

SELECT 'Action Transmission Inc','1603 OLD HUNTERS TRCE MARIETTA GA 30062',6785606615 UNION ALL

SELECT 'ACTION WELDING & FABRICATING','PO BOX 100 PORT O CONNOR TX 77982',3619832984 UNION ALL

SELECT 'Actiontrax Inc','2729 TRITT SPRINGS DR NE MARIETTA GA 30062',7705790322 UNION ALL

SELECT 'ACTIVE AUTO INTL INC','2832 COUNTY ROUTE 78 dbo. 6 MIDDLETOWN NY 10940',0 UNION ALL

SELECT 'ACTIVE XL','1704 BARRINGTON CIR MARIETTA GA 30062',7709735726 UNION ALL

SELECT 'Activecare Health Center','3055 JOHNSON FERRY RD MARIETTA GA 30062',7705527008 UNION ALL

SELECT 'Activelan Development LLC','2116 KINRIDGE RD MARIETTA GA 30062',7703106075 UNION ALL

SELECT 'ACTPENSEL INC','109 ANDERSON ST SE STE 103 MARIETTA GA 30060',7704197007 UNION ALL

SELECT 'Actpensel Inc','111 N MARIETTA PKWY NE MARIETTA GA 30060',7704197007 UNION ALL

SELECT 'Acupuncture & Wellness Ce','1000 JOHNSON FERRY RD MARIETTA GA 30068',6785607978 UNION ALL

SELECT 'Ad & D Consulting R & D Co','1153 COLONY DR MARIETTA GA 30068',7709927515 UNION ALL

SELECT 'Ad Nov Group','519 JOHNSON FERRY RD MARIETTA GA 30068',7703214747 UNION ALL

SELECT 'ADA FRAMING & ART','2931 ROBINSON RD NE MARIETTA GA 30068',7705796744 UNION ALL

SELECT 'ADAM BARDELANG','388 KLING ST NULL AKRON OH 44311',0 UNION ALL

SELECT 'ADAMARK JEWELERS & SILVERSMITH','4400 ROSWELL RD MARIETTA GA 30062',7705656558 UNION ALL

SELECT 'Adamark Jewelers Inc','4400 ROSWELL RD STE 136 MARIETTA GA 30062',7705656558 UNION ALL

SELECT 'Adams Antonia','29 ASHTON WOODS DR MARIETTA GA 30068',7705656791 UNION ALL

SELECT 'Adams Construction Services','519 JOHNSON FERRY RD MARIETTA GA 30068',7703215340 UNION ALL

SELECT 'ADAMS COUNTY SENIOR CITIZENS','210 N WILSON DR NULL WEST UNION OH 45693',0 UNION ALL

SELECT 'ADAMS LAW FIRM','232 ALEXANDER ST SE MARIETTA GA 30060',6785815050 UNION ALL

SELECT 'Adams Painting Wallcove Inc','1195 MOUNT BETHEL DR MARIETTA GA 30068',7703210000 UNION ALL

SELECT 'ADAMS ANTIQUARIAN BOOKS','PO BOX L HOBART NY 13788',6075389080 UNION ALL

SELECT 'Adaptive Learning Cntr Infnts','2509 POST OAK TRITT RD MARIETTA GA 30062',4048431893 UNION ALL

SELECT 'ADAPTIVE LEARNING CTR','2509 POST OAK TRITT RD MARIETTA GA 30062',7705093909 UNION ALL

SELECT 'Adaptive Solutions Inc','3162 JOHNSON FERRY RD MARIETTA GA 30062',7705093206 UNION ALL

SELECT 'Adar Shalva','17 31 SEAGIRT BLVD INWOOD NY 11096',7184713700 UNION ALL

SELECT 'ADB Services Inc','3162 JOHNSON FERRY RD MARIETTA GA 30062',6789905400 UNION ALL

SELECT 'Adco Holdings Inc','4343 SHALLOWFORD RD MARIETTA GA 30062',4048166813 UNION ALL

SELECT 'Add On Energy L L C','1165 ALLGOOD RD STE 6 MARIETTA GA 30062',7709774248 UNION ALL

SELECT 'ADD ONE MARKETING','3207 TEABERRY WAY MARIETTA GA 30068',7703216372 UNION ALL

SELECT 'Add Treatment & Research Ctr','5400 L B Johnson Fwy 93 Dallas TX 75240',9729807488 UNION ALL

SELECT 'ADD VANTAGE COACHING','3339 WOODSFIELD DR NE MARIETTA GA 30062',6785606512 UNION ALL

SELECT 'Added Touch Catering Inc','736 JOHNSON FERRY RD MARIETTA GA 30068',7703219592 UNION ALL

SELECT 'ADDESS CHIROPRACTIC','1000 JOHNSON FERRY RD MARIETTA GA 30068',7703216300 UNION ALL

SELECT 'ADDIAN INC','829 PICKENS INDUSTRIAL DR MARIETTA GA 30062',6783549001 UNION ALL

SELECT 'ADDINGTONS BOAT & CAMPER SLS','PO BOX 340 RICHLANDS VA 24641',2769644927 UNION ALL

SELECT 'Addone Marketing Services LLC','3207 TEABERRY WAY MARIETTA GA 30068',7703219823 UNION ALL

SELECT 'ADE BUILDERS INC','PO BOX 6415 MARIETTA GA 30065',7704223894 UNION ALL

SELECT 'ADEBOYE & ASSOC','244 S FAIRGROUND ST SE MARIETTA GA 30060',6783543554 UNION ALL

SELECT 'Adept Landscaping & Maintance','240 CRANFILL RD SE MARIETTA GA 30060',7704241519 UNION ALL

SELECT 'Adeptmax Corporation','8111 L B Johnson Fwy 65 Dallas TX 75251',9729915000 UNION ALL

SELECT 'Aderhold Properties Inc','111 N MARIETTA PKWY NE MARIETTA GA 30060',7704224344 UNION ALL

SELECT 'ADI Performance Inc','PO BOX 70083 MARIETTA GA 30007',7706400840 UNION ALL

SELECT 'Adirondack Cab Co','Montcalm Rd Ticonderoga NY 12883',5185852222 UNION ALL

SELECT 'ADIRONDACK COMMUNITY COLLEGE','640 BAY RD NULL QUEENSBURY NY 12804',0 UNION ALL

SELECT 'ADIRONDACK CORRECTIONAL FCLTY','PO BOX 110 RAY BROOK NY 12977',5188911343 UNION ALL

SELECT 'ADIRONDACK LIFE MAGAZINE','PO BOX 410 JAY NY 12941',5189462191 UNION ALL

SELECT 'ADIRONDACK PARK AGENCY','PO BOX 99 RAY BROOK NY 12977',5188914050 UNION ALL

SELECT 'ADIRONDACK ROCK & RIVER GUIDE','PO BOX 219 KEENE NY 12942',5185762041 UNION ALL

SELECT 'ADKINS AUTO PART','PO BOX 444 CRAIGSVILLE WV 26205',3047425535 UNION ALL

SELECT 'ADKINS TIRE CO','PO BOX 190 CRAIGSVILLE WV 26205',3047425830 UNION ALL

SELECT 'Adler & Associates','170 11 Beach Blvd Ste 900 Huntingtn Bch CA 92648',7145965632 UNION ALL

SELECT 'Adler Consulting Inc','1401 JOHNSON FERRY RD MARIETTA GA 30062',7706456508 UNION ALL

SELECT 'ADM Group','1251 PARTRIDGE WAY MARIETTA GA 30062',7705651894 UNION ALL

SELECT 'ADMIRALS INN','5651 CYPRESS GARDENS RD WINTER HAVEN FL 33884',8633245950 UNION ALL

SELECT 'Adonai Holdings Inc','1100 JOHNSON FERRY RD MARIETTA GA 30068',7703218928 UNION ALL

SELECT 'ADORABLE KIDS','2100 ROSWELL RD STE 200C MARIETTA GA 30062',7709198775 UNION ALL

SELECT 'ADP Statewide Insurance','10 N SUSSEX ST DOVER NJ 7801',9738911055 UNION ALL

SELECT 'Adr Window & Door Inc','748 LAWRENCE ST NE MARIETTA GA 30060',4042570909 UNION ALL

SELECT 'ADS ROAD SIDE SVC','163 HAMILTON TRCE MARIETTA GA 30068',4044543623 UNION ALL

SELECT 'Adult & Adolescent Psychology','2000 Southbridge Pkwy A Birmingham AL 35209',2058713919 UNION ALL

SELECT 'ADULT MEDICINE OF MARIETTA PC','790 CHURCH ST NE MARIETTA GA 30060',6787978201 UNION ALL

SELECT 'Adult Parole ADM Neb','Folsom & W Prospector Pl Lincoln NE 68509',4024795771 UNION ALL

SELECT 'Adult Probation Parole NC Div','132 RAFTERS LN WARRENTON NC 27589',2522575679 UNION ALL

SELECT 'Aduro Lighting LLC','23 59 Borden Ave New York NY 10101',6465363495 UNION ALL

SELECT 'ADVANCE AUTO PARTS','111 COBB PKWY N MARIETTA GA 30062',7709192480 UNION ALL

SELECT 'ADVANCE AUTO PARTS INC','RR 4 BOX 320 PHILIPPI WV 26416',3044572040 UNION ALL

SELECT 'Advance Digital Inc','4235 MERCHANTS WALK DR MARIETTA GA 30068',7709719005 UNION ALL

SELECT 'Advance Realty Enterprises','109 14 Van Wick Expy S Ozone Park NY 11420',7183222074 UNION ALL

SELECT 'ADVANCE REHAB','702 HIGHWAY 82 W NULL GREENWOOD MS 38930',0 UNION ALL

SELECT 'Advance Srgical Group NW GA PC','800 CANTON RD NE MARIETTA GA 30060',7704244328 UNION ALL

SELECT 'Advance Stores Company Inc','111 COBB PKWY N MARIETTA GA 30062',7702188632 UNION ALL

SELECT 'Advance Stores Company Inc','2850 Sheirden Dr Buffalo NY 14201',7168362751 UNION ALL

SELECT 'Advance Stores Company Inc','1420 S COBB DR SE MARIETTA GA 30060',7709192270 UNION ALL

SELECT 'Advance Stores Company Inc','8270 FM 78 San Antonio TX 78244',2106627889 UNION ALL

SELECT 'ADVANCED AESTHETIC SURGERY PC','711 CANTON RD NE STE 400 MARIETTA GA 30060',7704250118 UNION ALL

SELECT 'Advanced Aesthetic Surgery PC','684 CANTON RD NE MARIETTA GA 30060',7707715151 UNION ALL

SELECT 'ADVANCED BREAST CARE','790 CHURCH ST NE STE 410 MARIETTA GA 30060',7704221988 UNION ALL

SELECT 'Advanced Building Systems','73 62 Remcom Cir El Paso TX 79912',9152252260 UNION ALL

SELECT 'ADVANCED COUNSELING SVC','4343 SHALLOWFORD RD MARIETTA GA 30062',6785859260 UNION ALL

SELECT 'Advanced Custom Cmpt Solutions','2976 SEWELL MILL RD MARIETTA GA 30062',7709714070 UNION ALL

SELECT 'Advanced Digital Systems Inc','PO BOX 12076 DURHAM NC 27709',9194854819 UNION ALL

SELECT 'Advanced Drmtlogy & Dermatlc S','41 61 Kssena Blvd Ste 5a Flushing NY 11355',7188869000 UNION ALL

SELECT 'ADVANCED ENGNRING SOLUTIONS','1468 BRENTWOOD DR MARIETTA GA 30062',7705786490 UNION ALL

SELECT 'ADVANCED FITNESS CTR','702 HIGHWAY 82 W GREENWOOD MS 38930',6624533706 UNION ALL

SELECT 'ADVANCED HOME HEALTH CARE','9370 SW 72ND ST MIAMI FL 33173',3054125553 UNION ALL

SELECT 'Advanced Inst For Analytic Psy','178 10 Wexford Ter Jamaica NY 11432',7186581137 UNION ALL

SELECT 'Advanced Kitchens LLC','2986 JOHNSON FERRY RD MARIETTA GA 30062',7705875722 UNION ALL

SELECT 'Advanced Leasing Bus Ofc','PO BOX 9007 MARIETTA GA 30065',7704200060 UNION ALL

SELECT 'Advanced Logic Solutions Inc','1000 JOHNSON FERRY RD MARIETTA GA 30068',7705786771 UNION ALL

SELECT 'ADVANCED MACHINING TECH CO','1400 HOWARD ST E LIVE OAK FL 32064',3869618441 UNION ALL

SELECT 'Advanced Nurseries Inc','661 S COBB DR SE MARIETTA GA 30060',7708749003 UNION ALL

SELECT 'ADVANCED NURSING SOLUTIONS','220 PINE AVE N OLDSMAR FL 34677',8133410730 UNION ALL

SELECT 'ADVANCED OBESITY SURGERY CTR','780 CANTON RD NE STE 320 MARIETTA GA 30060',7709197050 UNION ALL

SELECT 'ADVANCED PAIN MANAGEMENT','909 COBB PKWY N MARIETTA GA 30062',7707941955 UNION ALL

SELECT 'ADVANCED POWER SOLUTIONS INC','5415 LAKE HOWELL RD WINTER PARK FL 32792',4076449889 UNION ALL

SELECT 'Advanced Pressure & Gutter Clg','1954 ROSWELL RD MARIETTA GA 30062',7709776653 UNION ALL

SELECT 'Advanced Rehab Services Inc','413 INDIAN HILLS TRL MARIETTA GA 30068',7709733466 UNION ALL

SELECT 'Advanced Rehabilitation LLC','702 HIGHWAY 82 W GREENWOOD MS 38930',6624555010 UNION ALL

SELECT 'ADVANCED SERVICES-MEAD ROYAL','1614 LOWER ROSWELL RD MARIETTA GA 30068',7709735152 UNION ALL

SELECT 'Advanced Spt Physcl Therapy PC','176 60 Un Ste 195 Fresh Meadows NY 11366',7188209300 UNION ALL

SELECT 'Advanced Stone Imports Inc','3762 BACCURATE WAY MARIETTA GA 30062',7705524836 UNION ALL

SELECT 'Advanced Storage & Retrieval S','4840 FOX GLN MARIETTA GA 30068',7709739976 UNION ALL

SELECT 'ADVANCED SURGICAL GROUP-NW GA','780 CANTON RD NE MARIETTA GA 30060',7707941995 UNION ALL

SELECT 'Advanced Telephonics Inc','244 W 49th St 250 New York NY 10019',2127642248 UNION ALL

SELECT 'Advanced Theater Solutions','2350 MONTEREY DR NE MARIETTA GA 30068',6783577164 UNION ALL

SELECT 'Advaned Home Inspections','445 GUILFORD CIR MARIETTA GA 30068',7709777116 UNION ALL

SELECT 'Advantage Dental Inc','123 MARBLE MILL RD NW MARIETTA GA 30060',7704997756 UNION ALL

SELECT 'ADVANTAGE HOME MORTGAGE','1838 BISHOPS GREEN DR MARIETTA GA 30062',6782135626 UNION ALL

SELECT 'Advantage Media Services','23250 Stonerdge Dr N 16 Waukesha WI 53188',2625226288 UNION ALL

SELECT 'Advantage One Systems','1735 HOLCOMB LAKE RD MARIETTA GA 30062',7705788595 UNION ALL

SELECT 'Advantage Pest Control Inc','4939 LOWER ROSWELL RD MARIETTA GA 30068',7705783882 UNION ALL

SELECT 'Advantage Real Estate','612 SW 3RD ST STE D LEES SUMMIT MO 64063',8165546700 UNION ALL

SELECT 'Advent Group Inc','2079 KINSMON DR MARIETTA GA 30062',7705872405 UNION ALL

SELECT 'Adventure West Media','5443 WOODBERRY CIR MARIETTA GA 30068',7706456709 UNION ALL

SELECT 'Adventures LP','62 Chelsea Piers 301 New York NY 10011',2123366450 UNION ALL

SELECT 'ADVERTISING GIFT SPECIALTY INC','1698 LOWER ROSWELL RD MARIETTA GA 30068',7705656785 UNION ALL

SELECT 'ADVERTISING IMPACT INC','5693 QUINCE RD MEMPHIS TN 38119',9016851966 UNION ALL

SELECT 'Advertising Insights Inc','3712 BACCURATE WAY MARIETTA GA 30062',7705941466 UNION ALL

SELECT 'Advertising/Marketing Assoc','5280 MILL RUN DR MARIETTA GA 30068',7705940790 UNION ALL

SELECT 'ADVISORS TITLE SVC','9370 SW 72ND ST MIAMI FL 33173',3055967779 UNION ALL

SELECT 'Aegis Holding LP','4103 AUDUBON DR MARIETTA GA 30068',7705653269 UNION ALL

SELECT 'Aegis Partners Inc','332 GREENFIELD CT MARIETTA GA 30068',7705655923 UNION ALL

SELECT 'Aemir Press','200 N FAIRGROUND ST NE MARIETTA GA 30060',7704278973 UNION ALL

SELECT 'Aero Surveys of Georgia Inc','PO BOX 6036 MARIETTA GA 30065',7704221611 UNION ALL

SELECT 'Aero Systems Engineering Inc','PO BOX 4426 MARIETTA GA 30061',7704234200 UNION ALL

SELECT 'AERONAUTICS DEPT','133 STATE ST STE 2 MONTPELIER VT 5633',8028282833 UNION ALL

SELECT 'AEROPOSTALE INC','87 MEDLEY CENTRE PKWY ROCHESTER NY 14622',5854677320 UNION ALL

SELECT 'Aerosoles Shoes','4475 ROSWELL RD MARIETTA GA 30062',6785603311 UNION ALL

SELECT 'AERUS ELECTROLUX','595 ROSWELL ST NE MARIETTA GA 30060',7704246613 UNION ALL

SELECT 'AERUS ELECTROLUX','PO BOX 358 MALONE NY 12953',5184834060 UNION ALL

SELECT 'Aesthetic Orthodontic Care','4939 LOWER ROSWELL RD MARIETTA GA 30068',7705096910 UNION ALL

SELECT 'Aesthetics Atlanta','2155 POST OAK TRITT RD MARIETTA GA 30062',7705791850 UNION ALL

SELECT 'Aet Advisors LLC','4875 OLDE TOWNE PKWY MARIETTA GA 30068',7705786967 UNION ALL

SELECT 'AETNA INSULATED WIRE','2265 ROSWELL RD MARIETTA GA 30062',7705092280 UNION ALL

SELECT 'AETNA LIFE INSURANCE COMPANY','1813 SPRING GARDEN ST DUAL 2 GREENSBORO NC 27403',336379200 UNION ALL

SELECT 'AETNA- PAMELA CARTER','2484 9TH ST NULL CUYAHOGA FALLS OH 44221',0 UNION ALL

SELECT 'Affek Locksmith','95 W 9TH ST NEW YORK NY 10011',9175912054 UNION ALL

SELECT 'Affiliated Marketing Inc','1232 WOODLAWN DR NE MARIETTA GA 30068',7709715191 UNION ALL

SELECT 'AFFINIA','2265 ROSWELL RD MARIETTA GA 30062',7705094874 UNION ALL

SELECT 'AFFINITY LOGISTICS CORP','533 JOHNSON FERRY RD STE 400 MARIETTA GA 30068',7705795652 UNION ALL

SELECT 'Affinity Logistics Corporation','533 JOHNSON FERRY RD MARIETTA GA 30068',7705795652 UNION ALL

SELECT 'Affordable Blinds and More','3760 RIVARIDGE DR MARIETTA GA 30062',4043768820 UNION ALL

SELECT 'Affordable Cnstr Fin LLC','2959 CHRISTOPHERS CT MARIETTA GA 30062',4044276290 UNION ALL

SELECT 'AFFORDABLE HOME FUNDING','533 JOHNSON FERRY RD MARIETTA GA 30068',7705651288 UNION ALL

SELECT 'AFFORDABLE LAWNS','396 CRANFILL RD SE MARIETTA GA 30060',7704364590 UNION ALL

SELECT 'Affordable Lawns','396 CRANFILL RD SE MARIETTA GA 30060',7704364590 UNION ALL

SELECT 'Affordable Medical Resources','1159 MONTE DR MARIETTA GA 30062',7703216142 UNION ALL

SELECT 'Affordable Office Solutions','1841 BISHOPS GREEN DR MARIETTA GA 30062',7709718095 UNION ALL

SELECT 'AFFORDABLE PIANOS','22 E MAIN ST MC GRAW NY 13101',6078368600 UNION ALL

SELECT 'Affordable Printing','Alapa St Ste 1 Kailua Kona HI 96740',8083298100 UNION ALL

SELECT 'AFGE','PO BOX 27077 NAS/JRB TX 76127',8173770447 UNION ALL

SELECT 'AFGE LOCAL 2367','667 RUGER RD AFGE LOCAL 2367 WEST POINT NY 10996',0 UNION ALL

SELECT 'AFI GY STUDIOS','4075 AUDUBON DR MARIETTA GA 30068',4045209232 UNION ALL

SELECT 'AFJ LANDSCAPE & MAINTENANCE','2105 WINDSTREAM TRCE SW MARIETTA GA 30060',7704345107 UNION ALL

SELECT 'Afk Enterprises Inc','86 N FAIRGROUND ST NE MARIETTA GA 30060',6782909455 UNION ALL

SELECT 'AFRICAN GRADE EXPRESS','N BECKLEY AVE DESOTO TX 75115',0 UNION ALL

SELECT 'AFRICAN IMPORTS','2309 JOMARC WAY MARIETTA GA 30062',4045368115 UNION ALL

SELECT 'Afrida Deli Grocery Inc','120 3 Jamaica Ave St Jamaica NY 11418',7188461020 UNION ALL

SELECT 'Aftermarket Partners Inc','San Diego 92131 San Diego CA 92101',8585499808 UNION ALL

SELECT 'AFTON JEWELERS','PO BOX 8194 CORPUS CHRISTI TX 78468',3619928786 UNION ALL

SELECT 'AG Brown & Sons Inc','3289 CHESTNUT OAKS DR MARIETTA GA 30062',7709710582 UNION ALL

SELECT 'AGA VENTUE V','488 KENNESAW AVE NW MARIETTA GA 30060',7704206587 UNION ALL

SELECT 'Agape Home Health','520 W ATLANTA ST SE MARIETTA GA 30060',7704290088 UNION ALL

SELECT 'Agape Mortgage Service','1531 ROSWELL RD MARIETTA GA 30062',7703218673 UNION ALL

SELECT 'AGENT INC','3606 43RD AVE LONG ISLAND CITY NY 11101',7183612072 UNION ALL

SELECT 'Agi Home Inspections LLC','5485 LOWER ROSWELL RD MARIETTA GA 30068',7709925455 UNION ALL

SELECT 'Agi Marketing Group','PO BOX 5329 ATLANTA GA 31107',6783618136 UNION ALL

SELECT 'AGI SCHUTZ MERCHANDISING','3823 SENTRY XING MARIETTA GA 30068',7705651252 UNION ALL

SELECT 'Agl 4 Enterprises','2679 TRITT SPRINGS TRCE NE MARIETTA GA 30062',6783628163 UNION ALL

SELECT 'AGM','2255 PINE WARBLER WAY MARIETTA GA 30062',7705095371 UNION ALL

SELECT 'Agnt Insurance & Fincl Svcs','347 N MARIETTA PKWY NE MARIETTA GA 30060',6782907777 UNION ALL

SELECT 'Agricultural Systems Co Inc','PO BOX 271 MESILLA NM 88046',5052334813 UNION ALL

SELECT 'Agrotain','11163 STONEWOOD DR GERMANTOWN WI 53022',2622570870 UNION ALL

SELECT 'AGUA DULCE BAPTIST CHURCH','PO BOX 296 AGUA DULCE TX 78330',3619982561 UNION ALL

SELECT 'Agudelo Alvaro Ins','2200 ROSWELL RD MARIETTA GA 30062',7705798868 UNION ALL

SELECT 'Agurkis Northington & Rains','1916 WICKS RIDGE LN MARIETTA GA 30062',7703950608 UNION ALL

SELECT 'AGWAY ENERGY PRODUCTS','E MAIN MALONE NY 12953',5184832710 UNION ALL

SELECT 'Ah Painting','570 FAVORWOOD DR SW MARIETTA GA 30060',7703199752 UNION ALL

SELECT 'Ahl Group Inc','37 SPRING DR SE MARIETTA GA 30060',7707951444 UNION ALL

SELECT 'Ahlberg Engineering Inc','525 WEBB INDUSTRIAL DR MARIETTA GA 30062',7709199968 UNION ALL

SELECT 'Aho and Barbat Advg & Mktg','163 SOUTH AVE SE MARIETTA GA 30060',7704255598 UNION ALL

SELECT 'Aiea Dental Associates','99 128 Aiea Hts 203 Aiea HI 96701',8084876451 UNION ALL

SELECT 'AIG FINANCIAL ADVISORS','3086 ABERDEEN CT MARIETTA GA 30062',4049440526 UNION ALL

SELECT 'Aiken-Wilson & Co','PO BOX 13715 ATLANTA GA 30324',4046681138 UNION ALL

SELECT 'Aikonhome Properties Group','3667 WYNTERING TRL MARIETTA GA 30068',6785602334 UNION ALL

SELECT 'Aim Marble & Granite LLC','1819 LOWER ROSWELL RD MARIETTA GA 30068',7705792466 UNION ALL

SELECT 'Aim Services Inc','Medical Dr San Antonio TX 78229',2105689721 UNION ALL

SELECT 'Aimco Properties L P','1650 BARNES MILL RD MARIETTA GA 30062',7704230271 UNION ALL

SELECT 'AIMEE T CASSINELLI DDS','810 CANTON RD NE STE D MARIETTA GA 30060',7704228264 UNION ALL

SELECT 'Ainokea Hawaii LLC','98 1005 Mnalua Rd Ste 823 Aiea HI 96701',8084865214 UNION ALL

SELECT 'Air Conditioning Htg Appl Svcs','5415 Lake Howell Rd 200 Winter Park FL 32792',4075799734 UNION ALL

SELECT 'Air Conditioning Unlimite','98 2013 Kaahumanu St Honolulu HI 96819',8085909266 UNION ALL

SELECT 'Air Express Atlanta','1155 ALLGOOD RD STE 5 MARIETTA GA 30062',6785940014 UNION ALL

SELECT 'AIR NATIONAL GUARD-ATLANTA','1388 FIRST ST MARIETTA GA 30060',7709194766 UNION ALL

SELECT 'Air Serv Group','1155 ALLGOOD RD STE 6 MARIETTA GA 30062',6785603633 UNION ALL

SELECT 'Air Span Wireless LLC','PO BOX 70784 MARIETTA GA 30007',7709772593 UNION ALL

SELECT 'Air Specialists Inc','PO BOX 4185 MARIETTA GA 30061',7704261722 UNION ALL

SELECT 'AIR SPECIALISTS INC','598 KIRK RD NW MARIETTA GA 30060',7704261813 UNION ALL

SELECT 'Air Techniques Inc','2999 JOHNSON FERRY RD MARIETTA GA 30062',7705187200 UNION ALL

SELECT 'AIR TECHNIQUES INC SAMPLING','1724 NEKOMA ST MARIETTA GA 30068',7709777525 UNION ALL

SELECT 'AIR WELD INC','PO BOX 3095 LAREDO TX 78044',9567221960 UNION ALL

SELECT 'Airbrush Tans By Sun Spray','3000 JOHNSON FERRY RD MARIETTA GA 30062',7709264460 UNION ALL

SELECT 'Aircraft Mint Lgstics Svcs LLC','3345 KEENLAND RD MARIETTA GA 30062',7709773085 UNION ALL

SELECT 'Aircrew Taxes','58 S PARK SQ NE MARIETTA GA 30060',7707959799 UNION ALL

SELECT 'Airforce Air Conditioning Inc','Chelsea Pier 60 Ste 6013 New York NY 10011',2123367777 UNION ALL

SELECT 'AIRGAS SOUTH','1088 ATLANTA RD SE MARIETTA GA 30060',7704221544 UNION ALL

SELECT 'Airline Ticket Counter Inc','4005 CHADDS WALK MARIETTA GA 30062',7709738424 UNION ALL

SELECT 'Airline Ticket Counter Inc','1255 JOHNSON FERRY RD MARIETTA GA 30068',7709778788 UNION ALL

SELECT 'Airmax International Inc','PO BOX 300053 JAMAICA NY 11430',9172085137 UNION ALL

SELECT 'Airport Shuttle Inc','3608 DYER PARKE LN SW MARIETTA GA 30060',7704852733 UNION ALL

SELECT 'AIRPORT WEATHER INFO','07776 STATE ROUTE 219 NEW KNOXVILLE OH 45871',4197532821 UNION ALL

SELECT 'Airport Weather Infoo','07776 STATE ROUTE 219 NEW KNOXVILLE OH 45871',4197532821 UNION ALL

SELECT 'Airtime Resellers Group','5008 MEADOW LN MARIETTA GA 30068',7705091085 UNION ALL

SELECT 'Ais Contracting Inc','240 CRANFILL RD SE MARIETTA GA 30060',7704299036 UNION ALL

SELECT 'Aisc Marketing Inc','1976 RIVER FOREST DR MARIETTA GA 30068',7706429707 UNION ALL

SELECT 'AJ Builders Inc','889 WATERFORD GRN MARIETTA GA 30068',7709988427 UNION ALL

SELECT 'Aj Taxi Service','77 6425 Kuakini Hwy Keaau HI 96749',8086401804 UNION ALL

SELECT 'AJS Auto Inc','1511 S COBB DR SE MARIETTA GA 30060',7707949447 UNION ALL

SELECT 'AJW Services Inc','1540 HEATH LN MARIETTA GA 30062',7705657522 UNION ALL

SELECT 'Akamai Fincl Entrepreneur MGT','74 5565 Luhia St Ste CD Kailua Kona HI 96740',8083318681 UNION ALL

SELECT 'AKIMA CONSTRUCTION SERVICES','36044 KILLEEN TX 76544',9802972831 UNION ALL

SELECT 'AKRON AIRPORT-CHRISTIAN AIRMEN','PO BOX 126 AKRON NY 14001',7165424607 UNION ALL

SELECT 'AL JOHNSON ATTORNEYS AT LAW','261 WASHINGTON AVE NE MARIETTA GA 30060',7704225494 UNION ALL

SELECT 'Al Stark','4260 CREEK HAVEN DR MARIETTA GA 30062',6785609180 UNION ALL

SELECT 'Al Tacos Carbon','234 WINDY HILL RD SE MARIETTA GA 30060',7704330733 UNION ALL

SELECT 'Al Tilley Auto Sales','Pennsylvania Route 29 Montrose PA 18801',5702784129 UNION ALL

SELECT 'ALS AIR CONDITIONING SVC','PO BOX 8103 MISSION TX 78572',9566301486 UNION ALL

SELECT 'Alain Pressure Washing','1726 KINSMON CV MARIETTA GA 30062',7705875505 UNION ALL

SELECT 'ALAMO AUTO CTR','RR 1 BOX 107CC ALAMO TX 78516',9567818552 UNION ALL

SELECT 'ALAMO AUTO SALES','RR 3 BOX 26 LAREDO TX 78043',9567255944 UNION ALL

SELECT 'ALAMO BARBER SHOP','1828 LOWER ROSWELL RD MARIETTA GA 30068',7709732865 UNION ALL

SELECT 'Alamo Rotary','8275 FM 78 San Antonio TX 78244',2106627557 UNION ALL

SELECT 'Alamo Tile','3539 CHESTATEE DR MARIETTA GA 30062',7705784359 UNION ALL

SELECT 'ALAN C POPE HIGH SCHOOL','3001 HEMBREE RD NE MARIETTA GA 30062',7705787900 UNION ALL

SELECT 'Alan Davidson and Associates','4813 FERNIE CT NE MARIETTA GA 30068',7705180054 UNION ALL

SELECT 'Alan F Herman','5033 LAKELAND DR MARIETTA GA 30068',7709736748 UNION ALL

SELECT 'ALAN MALOON MD','780 CANTON RD NE STE 400 MARIETTA GA 30060',7704250483 UNION ALL

SELECT 'Alan Manheim PC','25 ALEXANDER ST SE MARIETTA GA 30060',7704232222 UNION ALL

SELECT 'Alan Podrid/Co Inc','3410 STILLBROOK WAY MARIETTA GA 30062',7709732315 UNION ALL

SELECT 'Alaneo Appliance Parts','77-6425 Kuakini Hwy 102 Kailua Kona HI 96740',8083312252 UNION ALL

SELECT 'ALANI PRODUCTIONS','HC 2 BOX 6435 KEAAU HI 96749',8089658655 UNION ALL

SELECT 'ALANI PRODUCTIONS','PAHOA VILLAGE RD PAHOA HI 96778',0 UNION ALL

SELECT 'ALARMING RESULTS','1577 GREYSON RDG MARIETTA GA 30062',7709775262 UNION ALL

SELECT 'Alarming Results Inc','1050 E PIEDMONT RD MARIETTA GA 30062',7709775262 UNION ALL

SELECT 'Alarming Solutions Inc','1401 JOHNSON FERRY RD MARIETTA GA 30062',7705658786 UNION ALL

SELECT 'ALBAN ELECTRIC','PO BOX 6104 LIVE OAK FL 32064',3863624246 UNION ALL

SELECT 'Albanese Development Co','70 LITTLE WEST ST NEW YORK NY 10004',2129648944 UNION ALL

SELECT 'ALBANOS ITALIAN MARKET INC','1950 ROSWELL RD MARIETTA GA 30068',7709776778 UNION ALL

SELECT 'Albany Crowne Plaza Hotel Inc','80 State and Lodge St Albany NY 12207',5184626611 UNION ALL

SELECT 'ALBEMARLE DANCE CTR','425 N MCARTHUR ST STE D ELIZABETH CITY NC 27909',2523389838 UNION ALL

SELECT 'ALBENS GROUP','3900 N 10TH ST STE ALGR MCALLEN TX 78501',0 UNION ALL

SELECT 'Albert Demaria Consult','3857 RUNNING FOX DR MARIETTA GA 30062',6785603279 UNION ALL

SELECT 'ALBERT S MILLS TRACTOR SVC','540 20 MILE RD LOT H PONTE VEDRA BEACH FL 32081',9042198483 UNION ALL

SELECT 'ALBION SCACCIA ENTERPRISE','4817 OLD TIMBER RIDGE RD MARIETTA GA 30068',6786794000 UNION ALL

SELECT 'Albion Scaccia Enterprises LLC','4817 OLD TIMBER RIDGE RD MARIETTA GA 30068',6783255900 UNION ALL

SELECT 'Alchemy Solutions Group','1609 EXETER CT NE MARIETTA GA 30068',7706400075 UNION ALL

SELECT 'Alcohol & DRG Trtmnt Ctr of 1s','2200 ROSWELL RD MARIETTA GA 30062',7705786862 UNION ALL

SELECT 'ALCOHOLIC BEVERAGES','501 DEMOREST ST SE LIVE OAK FL 32064',3863622501 UNION ALL

SELECT 'ALCOHOLIC BEVERAGES','813 OHIO AVE S LIVE OAK FL 32064',3863622501 UNION ALL

SELECT 'ALCON BUILDERS','553 WATERMAN ST SE MARIETTA GA 30060',7704202340 UNION ALL

SELECT 'ALDEBARAN ASSOCIATES INTL','1958 HITCHING POST LN MARIETTA GA 30068',7706407317 UNION ALL

SELECT 'Alderman Hockaday & Assoc','809 MUIRFIELD TRL MARIETTA GA 30068',7705784376 UNION ALL

SELECT 'ALDERSON MAINTENANCE SHOP','202 MONROE ST ALDERSON WV 24910',3044452996 UNION ALL

SELECT 'Aldgia Arbardgi','5415 LAKE HOWELL RD WINTER PARK FL 32792',8135035055 UNION ALL

SELECT 'Aldridge Grading & Trucki','512 DELTA PL MARIETTA GA 30062',7702186067 UNION ALL

SELECT 'Aleah Morrow LPC','800 KENNESAW AVE NW MARIETTA GA 30060',7704999392 UNION ALL

SELECT 'ALEC & COMPANY LLC','22-01 BROADWAY FAIR LAWN NJ 7410',2017970900 UNION ALL

SELECT 'ALEKSA DESIGN','1255 JOHNSON FERRY RD MARIETTA GA 30068',7705797097 UNION ALL

SELECT 'ALERT LOCK & KEY','PO BOX 791383 SAN ANTONIO TX 78279',2106964066 UNION ALL

SELECT 'ALEX ENERGY INC','PO BOX 857 SUMMERSVILLE WV 26651',3048725898 UNION ALL

SELECT 'ALEX HORMICK','RR 1 BOX 41P BRIDGEPORT WV 26330',3040000000 UNION ALL

SELECT 'ALEX S MCARTHUR','282 1/2 E EXCHANGE ST APT 6 AKRON OH 44304',0 UNION ALL

SELECT 'ALEX STAKLEFF','2552 BRICE RD NULL AKRON OH 44313',0 UNION ALL

SELECT 'Alex Tires','1570 S COBB DR SE MARIETTA GA 30060',6783556682 UNION ALL

SELECT 'Alex Web Design','1503 Albemarle Rd Charlotte NC 28227',7049419999 UNION ALL

SELECT 'ALEXANDER CHIROPRACTIC','4343 SHALLOWFORD RD MARIETTA GA 30062',7705179993 UNION ALL

SELECT 'Alexander Michael Group Inc','301 MILLBROOK FARM CT MARIETTA GA 30068',7703211600 UNION ALL

SELECT 'Alexander Properties Group','2751 HAMMONDTON RD SE MARIETTA GA 30060',7704340980 UNION ALL

SELECT 'Alexas Design','1255 JOHNSON FERRY RD MARIETTA GA 30068',7705797097 UNION ALL

SELECT 'Alexdiamond','3310 CREEK HOLLOW DR MARIETTA GA 30062',7703214068 UNION ALL

SELECT 'Alexis Boutique','461 WINDY HILL RD SE MARIETTA GA 30060',6783093833 UNION ALL

SELECT 'ALFA AUTO CENTER','51 S FAIRGROUND ST SE MARIETTA GA 30060',7702181220 UNION ALL

SELECT 'ALFRED SMITH MASONRY','426 JOHNSON AVE SW LIVE OAK FL 32064',3863622463 UNION ALL

SELECT 'ALFRED WAINWRIGHT','834 MENTOR RD NULL AKRON OH 44303',0 UNION ALL

SELECT 'Algonquin Products Company','1165 ALLGOOD RD STE 13 MARIETTA GA 30062',7705784240 UNION ALL

SELECT 'ALHAMBRA PON','5351 E AIRPORT DR CELL TOWER 5 ONTARIO CA 91761',0 UNION ALL

SELECT 'ALHAMBRA STATION CAFE','255 ALHAMBRA CIR STE 170 CORAL GABLES FL 33134',3054412676 UNION ALL

SELECT 'Ali Baba Restaurants Inc','2259 HILL CREEK WAY MARIETTA GA 30062',7709987173 UNION ALL

SELECT 'ALIS COOKIES','1255 JOHNSON FERRY RD MARIETTA GA 30068',7709718566 UNION ALL

SELECT 'Alianza Latina Services','737 ROSWELL ST NE MARIETTA GA 30060',7704247979 UNION ALL

SELECT 'Alibi Marketing','4470 SILVERSMITH CT MARIETTA GA 30062',7706452661 UNION ALL

SELECT 'ALICE HUFFMAN','1 FOUNTAIN SQ CHATTANOOGA TN 37402',0 UNION ALL

SELECT 'Alice Stgermain Succulent GL','4366 DUNMORE RD NE MARIETTA GA 30068',7705099998 UNION ALL

SELECT 'All 10 Inc','800 KENNESAW AVE NW MARIETTA GA 30060',7704209855 UNION ALL

SELECT 'ALL ABOUT EMMA','2372 CHESTNUT SPRINGS TRL MARIETTA GA 30062',6785606164 UNION ALL

SELECT 'All About Mailboxes Inc','4371 ROSWELL RD MARIETTA GA 30062',7709730081 UNION ALL

SELECT 'All About Padre','1004 Padre Blvd G1-114 S Padre Isle TX 78597',9563713339 UNION ALL

SELECT 'ALL ABOUT SIGNS INC','4371 ROSWELL RD MARIETTA GA 30062',7709770408 UNION ALL

SELECT 'All About Signs N Print Inc','4261 GREEN RIDGE DR MARIETTA GA 30062',7703216446 UNION ALL

SELECT 'All About You Design Center','76 INDIAN TRL MARIETTA GA 30068',7705795143 UNION ALL

SELECT 'All American Consulting','PO BOX 732 MARIETTA GA 30061',7704332396 UNION ALL

SELECT 'All American Exports Inc','819 FOX HOLLOW PKWY MARIETTA GA 30068',7706334123 UNION ALL

SELECT 'All American Exteriors Inc','2822 FORSYTH RD STE 106 WINTER PARK FL 32792',4078307004 UNION ALL

SELECT 'All American Quality Foods','681 S MARIETTA PKWY SE MARIETTA GA 30060',7704990919 UNION ALL

SELECT 'ALL ATLANTA REALTY','3225 SHALLOWFORD RD STE 100 MARIETTA GA 30062',7705657505 UNION ALL

SELECT 'All Atlanta Realty LLC','3225 SHALLOWFORD RD MARIETTA GA 30062',7709714400 UNION ALL

SELECT 'ALL BETTER SPEECH LANGUAGE','N LOOP 1604 W SAN ANTONIO TX 78258',0 UNION ALL

SELECT 'All Budget Mechanical Services','152 W W LEE CT NE MARIETTA GA 30060',7704219977 UNION ALL

SELECT 'ALL CHECKS CASHED','461 WINDY HILL RD SE MARIETTA GA 30060',7704388497 UNION ALL

SELECT 'All Cities Construction Co','8306 Wilshire Blvd 1099 Los Angeles CA 90010',3237593588 UNION ALL

SELECT 'ALL COUNTY CONSTRUCTION CO','PONY FARM RD ONEONTA NY 13820',6074326822 UNION ALL

SELECT 'ALL DAY EMERGENCY LOCKSMITH','4026 UNION ST FLUSHING NY 11354',7188872125 UNION ALL

SELECT 'All Day Emergency Locksmith','1913 E PIEDMONT RD MARIETTA GA 30062',6783030399 UNION ALL

SELECT 'All Day Emergency Locksmith','4026 UNION ST FLUSHING NY 11354',7188872125 UNION ALL

SELECT 'All Decked Out','3430 DEVOE CT MARIETTA GA 30062',7705970819 UNION ALL

SELECT 'All E-Scrap Recycling','4880 LOWER ROSWELL RD MARIETTA GA 30068',7706849555 UNION ALL

SELECT 'ALL ELECTRIC','PO BOX 1773 COPPERAS COVE TX 76522',2545428050 UNION ALL

SELECT 'All Emergency Peachtree City L','2350 MITCHELL RD NE MARIETTA GA 30062',7705654490 UNION ALL

SELECT 'All Green Landscape','1445 BROOKCLIFF PL MARIETTA GA 30062',7705651643 UNION ALL

SELECT 'ALL ISLAND AUTOMOTIVE','96-1272 WAIHONA ST UNIT 1 PEARL CITY HI 96782',8084559692 UNION ALL

SELECT 'All Island Porter Service','Ke Ahole Airprt Kailua Kona HI 96739',8083267242 UNION ALL

SELECT 'All My Sons Moving & Storage','2862 CLEARBROOK DR MARIETTA GA 30068',7704331400 UNION ALL

SELECT 'All Nations Design Studio','3034 COACH LN MARIETTA GA 30062',6784682825 UNION ALL

SELECT 'ALL OCCASIONS PARTY PLATTERS','PO BOX 397532 DALLAS TX 75339',2149239097 UNION ALL

SELECT 'All Out Auto USA LLC','503 COMMERCE PARK DR SE MARIETTA GA 30060',7705903711 UNION ALL

SELECT 'All Out Green','3630 CHERBOURG WAY MARIETTA GA 30062',7709717582 UNION ALL

SELECT 'All Pro Flooring Inc','1000 COBB PKWY N STE A2 MARIETTA GA 30062',7704266776 UNION ALL

SELECT 'All Pro Fncl Svc Merrietta LLC','797 ROSWELL ST NE MARIETTA GA 30060',7704269998 UNION ALL

SELECT 'All Pro Landscaping','2458 TIMBERLY DR SE MARIETTA GA 30060',7703191918 UNION ALL

SELECT 'All Pro Towing','San Diego 92111 San Diego CA 92111',8582775102 UNION ALL

SELECT 'All Seasons Auto School','41 Bell Blvd Bayside NY 11361',7184458800 UNION ALL

SELECT 'All Services Realty Corp','5959 Main St Hunter NY 12442',5182634286 UNION ALL

SELECT 'All Shades Salon Air Brush','3000 JOHNSON FERRY RD MARIETTA GA 30062',7709929466 UNION ALL

SELECT 'ALL SKILL ELECTRIC','171 SUMMER LAKE DR SW MARIETTA GA 30060',7708639411 UNION ALL

SELECT 'All Square Profession Remodel','3267 HICKORY BLUFF DR MARIETTA GA 30062',7705796797 UNION ALL

SELECT 'All Star Communications Inc','4939 LOWER ROSWELL RD MARIETTA GA 30068',7705651415 UNION ALL

SELECT 'ALL STAR CONTRACTING','STATE HIGHWAY 3 WATERTOWN NY 13601',0 UNION ALL

SELECT 'All Star Financial','280 COBB PKWY S MARIETTA GA 30060',7708992705 UNION ALL

SELECT 'ALL STAR GROCERY','PO BOX 212 REYNOLDSVILLE WV 26422',3046246364 UNION ALL

SELECT 'ALL STAR PEST CONTROL & SVC','PO BOX 163843 FORT WORTH TX 76161',8174983900 UNION ALL

SELECT 'All Star Pizza & More Inc','2060 LOWER ROSWELL RD MARIETTA GA 30068',7709772220 UNION ALL

SELECT 'ALL STAR REMODELING','1754 ARROWHEAD CT MARIETTA GA 30062',4049256555 UNION ALL

SELECT 'ALL SURF GLASSING','PO BOX 1209 HALEIWA HI 96712',8086378787 UNION ALL

SELECT 'ALL THAT MATTERS','3100 ALLISON BONNETT MEMORIAL DR HUEYTOWN AL 35023',2054916775 UNION ALL

SELECT 'All That Matters Inc','3100 Allson Bnnett Mem Dr Bessemer AL 35023',2054916775 UNION ALL

SELECT 'ALL THROUGH THE HOUSE','4015 MANOR HOUSE DR MARIETTA GA 30062',7709927564 UNION ALL

SELECT 'ALL VALLEY PLUMBING','PO BOX 4142 MCALLEN TX 78502',9566866656 UNION ALL

SELECT 'ALL-IN-ONE UPHOLSTERY','2822 FORSYTH RD dbo. 2870 WINTER PARK FL 32792',4076788282 UNION ALL

SELECT 'All-Tech Heating & Cooling','1461 WHITE CIR NW MARIETTA GA 30060',7704210081 UNION ALL

SELECT 'ALLBRITTONS PONTIAC-GMC INC','500 HOWARD ST W LIVE OAK FL 32064',3863624012 UNION ALL

SELECT 'ALLEGANY ALLEGANY JAIL','4484 STATE RT 19 N BELMONT NY 14813',0 UNION ALL

SELECT 'Allegro Airlines','JFK Airport Jamaica NY 11411',7185657454 UNION ALL

SELECT 'ALLEN & SONS REFRIGERATION','556 S FAIR OAKS AVE PASADENA CA 91105',6267917157 UNION ALL

SELECT 'ALLEN BRYANT','PO BOX 913 MONCKS CORNER SC 29461',8438997822 UNION ALL

SELECT 'Allen David Cabinetry','157 HOUSTON RD TROUTMAN NC 28166',7045280424 UNION ALL

SELECT 'ALLEN FINANCIAL SVC','732 KENNESAW AVE NW MARIETTA GA 30060',7704203333 UNION ALL

SELECT 'Allen Investigative Services','PO BOX 723813 ATLANTA GA 31139',7709770404 UNION ALL

SELECT 'Allen Locksmith','2925 CAROLYN ST MARIETTA GA 30062',7705523656 UNION ALL

SELECT 'ALLERGEN RESPONSE RESEARCH CTR','1155 ALLGOOD RD MARIETTA GA 30062',7709719976 UNION ALL

SELECT 'ALLFAME INC','505 COMMERCE PARK DR SE STE F MARIETTA GA 30060',7704286589 UNION ALL

SELECT 'Allgood Food Mart','373 ALLGOOD RD NE MARIETTA GA 30060',6782905750 UNION ALL

SELECT 'Allgood Road Coin Laundry','788 ALLGOOD RD MARIETTA GA 30062',7704222720 UNION ALL

SELECT 'Allgood Services of Georgia','1095 MARIETTA INDUSTRIAL DR MARIETTA GA 30062',7709266280 UNION ALL

SELECT 'Alliance Bank NA','120 Madison St 18th Syracuse NY 13202',3154757534 UNION ALL

SELECT 'Alliance Business Products','2501 E PIEDMONT RD MARIETTA GA 30062',7705755730 UNION ALL

SELECT 'ALLIANCE JANITORIAL SVCS','500 BIRCHWOOD RD SW MARIETTA GA 30060',7704342407 UNION ALL

SELECT 'Alliance Systems Ltd','2265 ROSWELL RD MARIETTA GA 30062',7705094864 UNION ALL

SELECT 'Allied Aviation Fueling Inc','PO BOX 81686 SAN DIEGO CA 92138',6195747808 UNION ALL

SELECT 'Allied Business Group Inc','2640 HAMPTON PARK DR MARIETTA GA 30062',7704248083 UNION ALL

SELECT 'ALLIED COMMUNITY TRUST INC','406 DUVAL ST NE LIVE OAK FL 32064',3863300144 UNION ALL

SELECT 'Allied Electrical Contractors','PO BOX 647 MARIETTA GA 30061',7704241989 UNION ALL

SELECT 'Allied Health Consultants Inc','5123 SANDLEWOOD CT MARIETTA GA 30068',7706401110 UNION ALL

SELECT 'ALLIED HOME MORTGAGE CAPITAL','2265 ROSWELL RD MARIETTA GA 30062',7705917727 UNION ALL

SELECT 'Allied Waste Industries Inc','323 MARBLE MILL RD NW MARIETTA GA 30060',7705142910 UNION ALL

SELECT 'ALLIED WASTE SVC','PO BOX 668 DONNA TX 78537',9564647871 UNION ALL

SELECT 'ALLISON DOWLING','1 FOUNTAIN SQ CHATTANOOGA TN 37402',0 UNION ALL

SELECT 'ALLMERICA FINANCIAL','1875 WICKS VALLEY DR MARIETTA GA 30062',7703212750 UNION ALL

SELECT 'Allpro Parking','325 S WARREN ST SYRACUSE NY 13202',3154257275 UNION ALL

SELECT 'ALLSHADES SALON & AIRBRUSH','3000 JOHNSON FERRY RD MARIETTA GA 30062',7709929466 UNION ALL

SELECT 'Allsouth Pntg & Wallcovering','1059 TRIAD CT STE 12 MARIETTA GA 30062',7705289960 UNION ALL

SELECT 'ALLSTAR HAIR STUDIO','2800 JOHNSON FERRY RD MARIETTA GA 30062',7708170252 UNION ALL

SELECT 'ALLSTATE INSURANCE CO','180 COBB PKWY S MARIETTA GA 30060',7704998061 UNION ALL

SELECT 'ALLSTATE INSURANCE CO','3535 ROSWELL RD STE 34 MARIETTA GA 30062',7709734848 UNION ALL

SELECT 'ALLSTATE INSURANCE CO','4343 SHALLOWFORD RD MARIETTA GA 30062',6787959696 UNION ALL

SELECT 'ALLSTATE INSURANCE CO','4994 LOWER ROSWELL RD STE 26 MARIETTA GA 30068',7709719814 UNION ALL

SELECT 'Allstate Insurance Company','1011 S MARIETTA PKWY SE MARIETTA GA 30060',7704264582 UNION ALL

SELECT 'Allstate Insurance Company','950 COBB PKWY S MARIETTA GA 30060',7704229544 UNION ALL

SELECT 'ALLTEL FLORIDA','206 WHITE AVE SE LIVE OAK FL 32064',3863628000 UNION ALL

SELECT 'ALLYSON RUSSELL-BLAIR PC','216 ALEXANDER ST SE MARIETTA GA 30060',6782901243 UNION ALL

SELECT 'ALMIND CONSULTING INC','2020 BARAMORE OAKS DR MARIETTA GA 30062',7709738833 UNION ALL

SELECT 'Almo Auto Sales','591 LAWRENCE ST NE MARIETTA GA 30060',6783541926 UNION ALL

SELECT 'ALMO AUTOSALES','591 LAWRENCE ST NE MARIETTA GA 30060',6783541926 UNION ALL

SELECT 'Alno Group','8111 L B Johnson Fwy 65 Dallas TX 75251',2145803880 UNION ALL

SELECT 'ALOETTE OF METRO ATLANTA','3214 TEABERRY WAY MARIETTA GA 30068',7704276777 UNION ALL

SELECT 'Aloha Acupuncture & Sport','78 6831 Alii Dr Kailua Kona HI 96740',8083244545 UNION ALL

SELECT 'Aloha Billiards','77 6425 Kuakini Hwy Kailua Kona HI 96740',8083274567 UNION ALL

SELECT 'Aloha Ceramics','98 021 Kam Hwy Aiea HI 96701',8084889722 UNION ALL

SELECT 'Aloha Home Health Care','94 547 Ukee St Ste 117 Waipahu HI 96797',8086772298 UNION ALL

SELECT 'Aloha Sun Tanning Center','3101 ROSWELL RD STE E MARIETTA GA 30062',7703211300 UNION ALL

SELECT 'ALP INDUSTRIES-WEB PRODUCTS','PO BOX 127 ABERDEEN NC 28315',9109447616 UNION ALL

SELECT 'Alph Web Tech','2520 E PIEDMONT RD STE C MARIETTA GA 30062',6785602077 UNION ALL

SELECT 'ALPHA GROOMING','290 YORK ST APT E YORK ME 3909',2073329929 UNION ALL

SELECT 'ALPHA LIST MARKETING','PO BOX 921293 NORCROSS GA 30010',4049957049 UNION ALL

SELECT 'Alpha Omega Project','201B STILLWATER STE 6 WIMBERLEY TX 78676',5128476970 UNION ALL

SELECT 'Alpha PHI Omega - Rio PI Chptr','9500 GILMAN DR A21 LA JOLLA CA 92093',3105612620 UNION ALL

SELECT 'ALPHA REMODELING INC','3356 HUNTERS LODGE RD MARIETTA GA 30062',7709733938 UNION ALL

SELECT 'Alpine Communications','1125 PROMONTORY DR MARIETTA GA 30062',7703216386 UNION ALL

SELECT 'Alpine Delivery Systems','Van Nuys CA 91411 Sherman Oaks CA 91411',8189012141 UNION ALL

SELECT 'Alpine Granite & Marble','157 HOUSTON RD TROUTMAN NC 28166',7045289952 UNION ALL

SELECT 'Alr Co Inc','98 20 Kamhemaha Hwy Aiea HI 96701',8084844508 UNION ALL

SELECT 'Als Graphics','4020 OAK FOREST CIR MARIETTA GA 30062',6785604122 UNION ALL

SELECT 'ALTA FINANCIAL CORP','531 ROSELANE ST NW MARIETTA GA 30060',7704265626 UNION ALL

SELECT 'ALTADONNA RESTAURANT','24930 HORACE HARDING EXPY FLUSHING NY 11362',7182245474 UNION ALL

SELECT 'Altai Corporation','1093 Cobb Pkwy SE Marietta GA 30062',7709198670 UNION ALL

SELECT 'Altamoda Technologies LLC','4084 TRITT HOMESTEAD DR MARIETTA GA 30062',6786122181 UNION ALL

SELECT 'Altamonte Mall Venture A Flor','451e Altamnte Dr 2165 Altamnte Spgs FL 32701',4078304422 UNION ALL

SELECT 'Altamonte Pet Center','451 E Altamonte Dr 475 Altamonte Spg FL 32701',4078315443 UNION ALL

SELECT 'Altec Systems Inc','200 COBB PKWY N STE 402 MARIETTA GA 30062',7704200055 UNION ALL

SELECT 'ALTER','140 FRANKLIN ST ALTER BROOKLYN NY 11222',0 UNION ALL

SELECT 'Alterations By Lee Inc','1205 JOHNSON FERRY RD MARIETTA GA 30068',7709735156 UNION ALL

SELECT 'Altered Imges Hair Styling Stn','567 ROSWELL ST NE MARIETTA GA 30060',7704242482 UNION ALL

SELECT 'ALTERMAN & ASSOC','2039 DAYRON CT MARIETTA GA 30062',4046888400 UNION ALL

SELECT 'Alternative Electronic Svcs','1436 BROOKCLIFF DR MARIETTA GA 30062',7705780268 UNION ALL

SELECT 'ALTERNATIVE SENTENCING','PO BOX 218 WAYNE WV 25570',3042726377 UNION ALL

SELECT 'Althea Caces LLC','240 CHEROKEE ST NE MARIETTA GA 30060',7704249141 UNION ALL

SELECT 'Altoplex Import','329 COBB PKWY N MARIETTA GA 30062',7707921100 UNION ALL

SELECT 'Altria Client Services','1420 LAKESIDE PKWY FLOWER MOUND TX 75028',9727245406 UNION ALL

SELECT 'Alvares Nasario','951 S MARIETTA PKWY SE MARIETTA GA 30060',7707959888 UNION ALL

SELECT 'Alvin Fouts Cars Inc','1700 S COBB DR SE MARIETTA GA 30060',7704251475 UNION ALL

SELECT 'Alvin L Atkins','27w72 Central Parkw New York NY 10023',2125951456 UNION ALL

SELECT 'ALVINS FOOD STORE','PO BOX 97 PORT O CONNOR TX 77982',3619832397 UNION ALL

SELECT 'Alvins Liquor Store Inc','PO BOX 97 PORT O CONNOR TX 77982',3619834733 UNION ALL

SELECT 'Alvis Weatherly Inc','1362 SHEFFIELD PKWY MARIETTA GA 30062',7709712968 UNION ALL

SELECT 'Always 24 Hour Emrgncy Lsmith','1280 JOHNSON FERRY RD MARIETTA GA 30068',6783032439 UNION ALL

SELECT 'Always Superior Book','3940 CLUBLAND DR MARIETTA GA 30068',7709772378 UNION ALL

SELECT 'Alzafar Shrine Center','901 N 1604 W San Antonio TX 78232',2104961625 UNION ALL

SELECT 'Am S Enterprises','4880 LOWER ROSWELL RD MARIETTA GA 30068',7709518478 UNION ALL

SELECT 'AM SOUTH BANK','5679 QUINCE RD MEMPHIS TN 38119',9017625980 UNION ALL

SELECT 'AMADEUS STRING ENSEMBLE INC','2968 GANT QUARTERS DR MARIETTA GA 30068',7709713176 UNION ALL

SELECT 'AMANA','1765 W OAK PKWY MARIETTA GA 30062',7704256001 UNION ALL

SELECT 'AMAVIS ENTERPRISES','291 PAT MELL RD SE MARIETTA GA 30060',7704449010 UNION ALL

SELECT 'Amavis Enterprises','122 LAROSE CIR SE MARIETTA GA 30060',6787688413 UNION ALL

SELECT 'AMAZING CABINETS','189 COBB PKWY N MARIETTA GA 30062',7703548118 UNION ALL

SELECT 'AMAZING CARS','468 COBB PKWY S MARIETTA GA 30060',7704253500 UNION ALL

SELECT 'Amazing Cars Inc','468 COBB PKWY S MARIETTA GA 30060',7707949008 UNION ALL

SELECT 'AMAZONIA','1355 ROSWELL RD MARIETTA GA 30062',7705796773 UNION ALL

SELECT 'Amber Financial Group LLC','91 590 Farrington Hwy Kapolei HI 96707',8086744449 UNION ALL

SELECT 'AMBERLY MASTER PROPERTY OWNERS','1075 RESIDENCE CLUB DR CARY NC 27519',0 UNION ALL

SELECT 'Ambiance Designs','PO BOX 6355 MARIETTA GA 30065',7705655543 UNION ALL

SELECT 'Amego Furniture','809 ROSWELL ST NE MARIETTA GA 30060',6787979001 UNION ALL

SELECT 'Amencon Construction Inc','1 New York Phizi New York NY 10001',2127429689 UNION ALL

SELECT 'Amenique Community Relations','275 TIMBER CREEK LN SW MARIETTA GA 30060',4046413786 UNION ALL

SELECT 'AMER MUSEUM/NAT HISTORY','200 CENTRAL PARK W AMER MUSEUM NEW YORK NY 10024',0 UNION ALL

SELECT 'AMER MUSEUM/NAT HISTORY','200 CENTRAL PARK W IT-NETWORK NEW YORK NY 10024',0 UNION ALL

SELECT 'AMER MUSEUM/NAT HISTORY','200 CENTRAL PARK W SUPPORT SER NEW YORK NY 10024',0 UNION ALL

SELECT 'Amer Property Specialists','2265 ROSWELL RD MARIETTA GA 30062',7705094884 UNION ALL

SELECT 'AMERI GAS INC','PO BOX 367 CATSKILL NY 12414',5189433680 UNION ALL

SELECT 'America On Wheels Inc','210 BLAIR VALLEY DR NE MARIETTA GA 30060',6787979994 UNION ALL

SELECT 'AMERICAS CLEANING & CONSTR','377 GLOVER ST SE MARIETTA GA 30060',7704229277 UNION ALL

SELECT 'American Academy of Mind & Bdy','PO BOX 174 MABLETON GA 30126',6785817880 UNION ALL

SELECT 'AMERICAN ANIMAL HOSPITAL ASSN','ARSENAL STREET RD WATERTOWN NY 13601',3157859505 UNION ALL

SELECT 'American Association','51 GOODMAN DR CINCINNATI OH 45221',5135585103 UNION ALL

SELECT 'AMERICAN BANK INSTITUTE','1046 S COBB DR SE MARIETTA GA 30060',7704269584 UNION ALL

SELECT 'AMERICAN BANKERS INSURANCE CO','255 ALHAMBRA CIR CORAL GABLES FL 33134',3054429348 UNION ALL

SELECT 'American Benefits Company','400 LOCKHEED AVE SE MARIETTA GA 30060',6785811114 UNION ALL

SELECT 'American Boatbuilders Assn','127 CHURCH ST NE STE 210 MARIETTA GA 30060',7707923070 UNION ALL

SELECT 'AMERICAN BODY SHOP','523 GLOVER ST SE MARIETTA GA 30060',7704229497 UNION ALL

SELECT 'American Brake Services','1310 JOHNSON FERRY RD MARIETTA GA 30068',7709774117 UNION ALL

SELECT 'American Broadband Inc./Broadb','821 INDUSTRIAL BLVD DEL RIO TX 78840',0 UNION ALL

SELECT 'American Broadband Inc./Granit','5518 LIPES BLVD APT 218 CORPUS CHRISTI TX 78413',0 UNION ALL

SELECT 'American Broadband Inc./USPS','124 N Maple Street XYZ WAVERLY KY 42462',0 UNION ALL

SELECT 'AMERICAN BROAND USPS','18 E CLARK ST PINEWOOD SC 29125',0 UNION ALL

SELECT 'American Builder Surplus LLC','1205 JOHNSON FERRY RD MARIETTA GA 30068',6782779335 UNION ALL

SELECT 'American Capital Insur Assoc','367 PAT MELL RD SE MARIETTA GA 30060',7708018001 UNION ALL

SELECT 'American Ceo LLC','Time Sq New York NY 10036',6467441386 UNION ALL

SELECT 'American Cnsrvtion Asssciation','30 Rockefeller Plz 5600 New York NY 10112',2126495819 UNION ALL

SELECT 'American Collection Systems','PO BOX 466 CLIFTON PARK NY 12065',5188776126 UNION ALL

SELECT 'American Color Graphics Inc','3879 WINNERS CT MARIETTA GA 30062',7709713705 UNION ALL

SELECT 'American Containment Svcs Inc','60 COVINGTON AVE NE MARIETTA GA 30060',7704279777 UNION ALL

SELECT 'American Credit Financing','16310 Nthrn Blvd Ste 201 Flushing NY 11358',7184619444 UNION ALL

SELECT 'AMERICAN DELI','180 COBB PKWY S MARIETTA GA 30060',7705901178 UNION ALL

SELECT 'AMERICAN DELI','2100 ROSWELL RD MARIETTA GA 30062',7705093800 UNION ALL

SELECT 'American Deli','2100 ROSWELL RD MARIETTA GA 30062',7705093800 UNION ALL

SELECT 'American Direct Mortgage Inc','4019 BRAMBLE CT MARIETTA GA 30062',7709737899 UNION ALL

SELECT 'American Drive Shaft Service','765 S COBB DR SE MARIETTA GA 30060',7704999804 UNION ALL

SELECT 'American Eagle Outfitters Inc','4475 ROSWELL RD STE 310 MARIETTA GA 30062',7705654111 UNION ALL

SELECT 'American Engine Installations','999 MARIETTA INDUSTRIAL DR MARIETTA GA 30062',7704286440 UNION ALL

SELECT 'AMERICAN EXPRE AMEX TRAVEL','3131 W PARK BLVD APT COMM174 PLANO TX 75075',0 UNION ALL

SELECT 'American Express Travel','901 SAWYER RD FL 3 MARIETTA GA 30062',7705785835 UNION ALL

SELECT 'AMERICAN FILTECO MACHINERY','1165 ALLGOOD RD MARIETTA GA 30062',7705793811 UNION ALL

SELECT 'American Financial Advisors','2551 ROSWELL RD STE 310 MARIETTA GA 30062',7709772434 UNION ALL

SELECT 'American Friends of The Hebrew','1 Battery Park Plz 25 New York NY 10004',2128094430 UNION ALL

SELECT 'AMERICAN FUNDING','1225 JOHNSON FERRY RD MARIETTA GA 30068',6785607171 UNION ALL

SELECT 'American General Finance Corp','2141 ROSWELL RD STE B MARIETTA GA 30062',7705099450 UNION ALL

SELECT 'AMERICAN GENERAL SECURITIES','909 OHIO AVE N LIVE OAK FL 32064',3863627101 UNION ALL

SELECT 'AMERICAN GLASS SOLUTIONS','35 PIONEER TRL MARIETTA GA 30068',4044252907 UNION ALL

SELECT 'American HM Surfaces Group Inc','4944 LOWER ROSWELL RD MARIETTA GA 30068',7709738284 UNION ALL

SELECT 'American Home Inspection Inc','3313 ELLSMERE TRCE MARIETTA GA 30062',7709730655 UNION ALL

SELECT 'AMERICAN HOME KEY','1000 JOHNSON FERRY RD MARIETTA GA 30068',7705656585 UNION ALL

SELECT 'AMERICAN HOME SURFACES GROUP','4994 LOWER ROSWELL RD STE 16 MARIETTA GA 30068',7709738284 UNION ALL

SELECT 'AMERICAN INTEGRATED ACCE','26 SAINT MARKS PL AMERICAN INT STATEN ISLAND NY 10301',0 UNION ALL

SELECT 'AMERICAN INTERPRETER ASSOC','2721 SUDBURY TRCE MARIETTA GA 30062',7704192020 UNION ALL

SELECT 'American Intl Resources','98 718 Mnlua Rd Ste A018 Pearl City HI 96782',8084884426 UNION ALL

SELECT 'AMERICAN LASER CTR MARIETTA','1163 JOHNSON FERRY RD STE 120 MARIETTA GA 30068',7703218687 UNION ALL

SELECT 'American Learning Foundation','355 BRIARWOOD CT MARIETTA GA 30068',7703219905 UNION ALL

SELECT 'AMERICAN LEGION','STATE BETTSVILLE OH 44815',4199865926 UNION ALL

SELECT 'AMERICAN LEGION POST 154','ELY LAKE RD MONTROSE PA 18801',0 UNION ALL

SELECT 'American Legion Post 42','PO BOX 268 DAMARISCOTTA ME 4543',2075633738 UNION ALL

SELECT 'AMERICAN LEGION PST154','ELY LAKE RD MONTROSE PA 18801',5702781649 UNION ALL

SELECT 'American Liberty Mortgage','2475 E PIEDMONT RD MARIETTA GA 30062',7705790359 UNION ALL

SELECT 'American Limousine','166182 San Pedro Ave San Antonio TX 78232',2108239088 UNION ALL

SELECT 'AMERICAN LINES INC','120 S PARK SQ NE STE 201 MARIETTA GA 30060',6785811951 UNION ALL

SELECT 'AMERICAN LOCATORS','1531 ROSWELL RD MARIETTA GA 30062',7705786400 UNION ALL

SELECT 'American Maglev Technology','30 S PARK SQ NE STE 201 MARIETTA GA 30060',4043864036 UNION ALL

SELECT 'American Management Svcs Inc','950 HUDSON RD SE MARIETTA GA 30060',7704258193 UNION ALL

SELECT 'AMERICAN MEDICAL ACCOUNTING','2870 JOHNSON FERRY RD MARIETTA GA 30062',7705097750 UNION ALL

SELECT 'American Medical Accounting &','PO BOX 72543 MARIETTA GA 30007',7706932622 UNION ALL

SELECT 'AMERICAN MEDICAL ACCT/CONSLT','2864 JOHNSON FERRY RD STE 150 MARIETTA GA 30062',7706936022 UNION ALL

SELECT 'American Medical Response Inc','595 ARMSTRONG ST SE MARIETTA GA 30060',7705131767 UNION ALL

SELECT 'AMERICAN MORTGAGE SVC INC','3115 ROSWELL RD MARIETTA GA 30062',7706153931 UNION ALL

SELECT 'American Mseum of Ntral Hstory','79th St At Central Pk St New York NY 10024',2127695656 UNION ALL

SELECT 'American Mseum of Ntral Hstory','Central Park W 79th St New York NY 10024',2127695000 UNION ALL

SELECT 'AMERICAN MUSEUM NATURAL','200 CENTRAL PARK W AMERICAN MU NEW YORK NY 10024',0 UNION ALL

SELECT 'American Museum of Natural His','79th St Central Prk W New York NY 10024',2127695000 UNION ALL

SELECT 'AMERICAN MUSEUM-NATRL HIST LIB','200 CENTRAL PARK W NEW YORK NY 10024',2127695400 UNION ALL

SELECT 'AMERICAN NATIONAL INSURANCE CO','3162 JOHNSON FERRY RD STE 260 MARIETTA GA 30062',6785609180 UNION ALL

SELECT 'American National Insurance Co','1230 JOHNSON FERRY PL MARIETTA GA 30068',7709715002 UNION ALL

SELECT 'American National Insurance Co','2862 JOHNSON FERRY RD MARIETTA GA 30062',7706429552 UNION ALL

SELECT 'AMERICAN PAWN & JEWELRY','1055 S COBB DR SE MARIETTA GA 30060',7705140356 UNION ALL

SELECT 'AMERICAN PEDIATRIC CONSULTANTS','2215 ROSWELL RD MARIETTA GA 30062',7703211773 UNION ALL

SELECT 'American Petroleum Institute','Toll 50 Broadway Ste 3701 New York NY 10001',2129476147 UNION ALL

SELECT 'American Petuary Group Inc','240 TIMBER CREEK LN SW MARIETTA GA 30060',7703333332 UNION ALL

SELECT 'AMERICAN POWER EQUIPMENT','1359 GRESHAM RD MARIETTA GA 30062',7709718118 UNION ALL

SELECT 'American Power Equipment','1359 GRESHAM RD MARIETTA GA 30062',7709718118 UNION ALL

SELECT 'American Prepaid Telephone Ser','2866 JOHNSON FERRY RD MARIETTA GA 30062',6788220550 UNION ALL

SELECT 'AMERICAN PRINTING INK','1050 TRIAD CT MARIETTA GA 30062',6785947698 UNION ALL

SELECT 'American Printing Ink','1050 TRIAD CT MARIETTA GA 30062',7705947698 UNION ALL

SELECT 'American Pro Credit Inc','1240 JOHNSON FERRY PL MARIETTA GA 30068',7703211772 UNION ALL

SELECT 'AMERICAN RED CROSS','2143 ROSWELL RD MARIETTA GA 30062',7703218461 UNION ALL

SELECT 'AMERICAN RED CROSS','324 VICTORY DR SE MARIETTA GA 30060',7704282695 UNION ALL

SELECT 'American Red Cross','2179 ROSWELL RD STE 251 MARIETTA GA 30062',7705781977 UNION ALL

SELECT 'AMERICAN RED CROSS VALLEY CHAP','37 N CHEMUNG ST WAVERLY NY 14892',0 UNION ALL

SELECT 'American Reserves LLC','1923 FIELDS POND GLN MARIETTA GA 30068',7708465490 UNION ALL

SELECT 'American Roofing Sales Inc','3535 ROSWELL RD MARIETTA GA 30062',7705659575 UNION ALL

SELECT 'AMERICAN SCREEN','319 CHURCH ST NE MARIETTA GA 30060',7704273229 UNION ALL

SELECT 'AMERICAN SECURITY ALARM & LOCK','PO BOX 37060 CLEVELAND OH 44137',3305629329 UNION ALL

SELECT 'American Specialty Systems Inc','1000 JOHNSON FERRY RD MARIETTA GA 30068',8002864254 UNION ALL

SELECT 'American Sports Co Inc','3307 WOODSFIELD DR NE MARIETTA GA 30062',7705097000 UNION ALL

SELECT 'AMERICAN STANDARD APPEARAL','BROADWAY NEW YORK NY 10018',0 UNION ALL

SELECT 'American Stone and Tile Inc','1759 AIRCRAFT DR SE MARIETTA GA 30060',4045134519 UNION ALL

SELECT 'AMERICAN SYMBOL','4343 SHALLOWFORD RD STE D2 MARIETTA GA 30062',6784615751 UNION ALL

SELECT 'American Telephone Supply Inc','1968 FIELDS POND DR MARIETTA GA 30068',7706422252 UNION ALL

SELECT 'American Thunder Cycles Inc','1608 S COBB DR SE MARIETTA GA 30060',7704299887 UNION ALL

SELECT 'American Tower Corporation','1165 ALLGOOD RD STE 21 MARIETTA GA 30062',7703216657 UNION ALL

SELECT 'American Tower Corporation','829 PICKENS INDUSTRIAL DR MARIETTA GA 30062',7709199003 UNION ALL

SELECT 'AMERICAN TREE SVC','1949 MOZELLE DR MARIETTA GA 30062',7709719459 UNION ALL

SELECT 'AMERICAN VAN RENTAL','614 COBB PKWY S MARIETTA GA 30060',7707959510 UNION ALL

SELECT 'American Ventures Realty Corp','255 ALHAMBRA CIR STE 1100 CORAL GABLES FL 33134',3055699500 UNION ALL

SELECT 'American Vigilance','201 PARKAIRE XING MARIETTA GA 30068',7709731493 UNION ALL

SELECT 'AMERICAN WARRANTY GROUP','2820 LASSITER RD MARIETTA GA 30062',7705180063 UNION ALL

SELECT 'AMERICAN WOOD SPECIALISTS','1675 AIRCRAFT DR SE MARIETTA GA 30060',7706568020 UNION ALL

SELECT 'Americana Healthcare Corp GA','4360 JOHNSON FERRY PL MARIETTA GA 30068',7709715870 UNION ALL

SELECT 'Americas Best Contacts &','2200 ROSWELL RD MARIETTA GA 30062',7705656200 UNION ALL

SELECT 'Americas Finest LLC','121 HUNTING CREEK DR MARIETTA GA 30068',7705752388 UNION ALL

SELECT 'Americas First Home Mrtg Co','3939 ROSWELL RD STE 10 MARIETTA GA 30062',7709713882 UNION ALL

SELECT 'Americas Mattress','2135 ROSWELL RD MARIETTA GA 30062',7705653100 UNION ALL

SELECT 'AMERICAS MORTGAGE BROKER','1380 MURDOCK RD MARIETTA GA 30062',7703213402 UNION ALL

SELECT 'Americas Mortgage Brokers Inc','533 JOHNSON FERRY RD MARIETTA GA 30068',7705656315 UNION ALL

SELECT 'AMERICATANINA HOTEL','1701 BROADWAY NEW VDH dbo. 2 NEW YORK NY 10019',0 UNION ALL

SELECT 'Americorp Financial Inc','4343 SHALLOWFORD RD MARIETTA GA 30062',7709987796 UNION ALL

SELECT 'AMERICTANINA HOTEL','1701 BROADWAY NEW VDH dbo. 4 NEW YORK NY 10019',0 UNION ALL

SELECT 'AMERICU CREDIT UNION/ SPOKE AC','7785 N STATE ST APT SPOKE LOWVILLE NY 13367',0 UNION ALL

SELECT 'AMERICU CREDIT UNION/SPOKE ACC','219 GENESEE ST APT SPOKE ONEIDA NY 13421',0 UNION ALL

SELECT 'Amerifiber Incorporated','1962 WILLEO CREEK PT MARIETTA GA 30068',7705185858 UNION ALL

SELECT 'Amerilat Real Estate','9330 L B JOHNSON FWY 90 DALLAS TX 75243',9729512535 UNION ALL

SELECT 'Amerilimo','185 2 Union Tpke Flushing NY 11366',7184541551 UNION ALL

SELECT 'AMERIPRISE FINANCIAL','1000 JOHNSON FERRY RD STE D125 MARIETTA GA 30068',7705791466 UNION ALL

SELECT 'Ameritaliano Pizza Co','140 VANN ST NE MARIETTA GA 30060',7702182707 UNION ALL

SELECT 'Ameron International Corp','PO BOX 29968 HONOLULU HI 96820',8082662640 UNION ALL

SELECT 'AMERSON ENGRAVING','PO BOX 3184 HUEYTOWN AL 35023',2054914901 UNION ALL

SELECT 'Ames Industrial Sales','3031 PATHVIEW LN MARIETTA GA 30062',7705653704 UNION ALL

SELECT 'AMES TAPING TOOLS INC','1080 COBB PKWY N STE A MARIETTA GA 30062',7704273767 UNION ALL

SELECT 'AMETA TEXTILES INC','4880 LOWER ROSWELL RD MARIETTA GA 30068',7706490363 UNION ALL

SELECT 'Amex','2439 N FOREST DR MARIETTA GA 30062',4043883820 UNION ALL

SELECT 'AMEX INTERNATIONAL CO','PO BOX 1615 LAREDO TX 78044',9567231052 UNION ALL

SELECT 'Amie Hair Braiding','445 WINDY HILL RD SE MARIETTA GA 30060',7708639301 UNION ALL

SELECT 'Amigo','1977 S COBB DR SE MARIETTA GA 30060',6785569400 UNION ALL

SELECT 'AMIGO AUTO SALES','1310 S COBB DR SE MARIETTA GA 30060',6785947613 UNION ALL

SELECT 'Amigo Auto Sales Inc','1941 S COBB DR SE MARIETTA GA 30060',7704361760 UNION ALL

SELECT 'AMIGO CONCRETE CONTRACTOR','1746 OAK ST SE MARIETTA GA 30060',6785946588 UNION ALL

SELECT 'Amigo Wheels & Tires','727 ROSWELL ST NE MARIETTA GA 30060',4043791197 UNION ALL

SELECT 'AMIGOS & FRIENDS USED CARS','1177 HAGOOD CIR MARIETTA GA 30062',6785811444 UNION ALL

SELECT 'AMIGOS & FRIENDS USED CARS','980 ROSWELL ST SE MARIETTA GA 30060',7704247923 UNION ALL

SELECT 'Amigos & Friends Used Cars & T','980 ROSWELL ST SE MARIETTA GA 30060',7705147701 UNION ALL

SELECT 'Amigos Friends U Cars & Trcks','1177 HAGOOD CIR MARIETTA GA 30062',6785810470 UNION ALL

SELECT 'Amigos Painting','3020 ROSWELL RD STE 200 MARIETTA GA 30062',6785318292 UNION ALL

SELECT 'AMIGOS Y MAS','343 PAT MELL RD SE MARIETTA GA 30060',7704326565 UNION ALL

SELECT 'Aminpour & Assoc','SAN DIEGO 92124 SAN DIEGO CA 92101',6194357247

;

PRINT 'Duration = ' + CONVERT(CHAR(12),GETDATE()-@StartTime,114) --hh:mi:ss:mmm(24h)

;

GO

--=====================================================================================================================

RAISERROR('--===== Populating the test table with an additional 22 million rows of unique test data...',0,0) WITH NOWAIT

;

GO

DECLARE @StartTime DATETIME;

SELECT @StartTime = GETDATE()

;

INSERT INTO dbo.TestBusiness

(BusinessName, Address, Phone)

SELECT TOP 1000000

CONVERT(VARCHAR(200),NEWID())

,CONVERT(VARCHAR(200),NEWID())

,ABS(CHECKSUM(NEWID()))%99999999999

FROM sys.all_columns ac1 --This "table" always has at least 4,000 rows in it

CROSS JOIN sys.all_columns ac2 --4,000^2 = 16 million, which is more than enough.

;

PRINT 'Duration = ' + CONVERT(CHAR(12),GETDATE()-@StartTime,114) --hh:mi:ss:mmm(24h)

;

GO 22 --22 Batches of 1 million run a bit more quickly than a single batch of 10 million

--================================

RAISERROR('--===== Creating the composite index',0,0) WITH NOWAIT

;

DECLARE @StartTime DATETIME;

SELECT @StartTime = GETDATE()

;

IF EXISTS(SELECT 1 FROM sys.Indexes WHERE name = 'IX_Composite_01' AND OBJECT_ID('dbo.TestBusiness') IS NOT NULL)

DROP INDEX IX_Composite_01 ON dbo.TestBusiness

;

CREATE NONCLUSTERED INDEX IX_Composite_01

ON dbo.TestBusiness (BusinessName, Address, Phone)

;

PRINT 'Duration = ' + CONVERT(CHAR(12),GETDATE()-@StartTime,114) --hh:mi:ss:mmm(24h)

;

PRINT '--===== TEST SETUP COMPLETE =================================================================================='

GO

Here's the test harness that includes only the code from this thread that comes close to what the OP asked for. That will be followed by the run results on my box. Ostensibly, all of the data is supposed to be available in memory for it to work so I "primed the pump" by running all of this code first and then reran it. What you're looking at are the results from that second run.

I also added my own rendition, which includes the optional but desired "dupe group name" in the form of a number.

Here's the code... Note that each method is executed 3 times in succession just to make sure that the first run isn't penalized for being the first run.

RAISERROR('

--============================================================================================================

-- Method 1 by sqlslacker

-- Produces correct output in table but no "Group Name".

--============================================================================================================

',0,0) WITH NOWAIT

;

--===== Start the timers

SET STATISTICS TIME,IO ON

;

--===== Execute the code

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

);

--===== Housekeeping

SET STATISTICS TIME,IO OFF

;

DROP TABLE dbo.PossibleDuplicateBusinesses

;

GO 3

RAISERROR('

--============================================================================================================

-- Method 1 by ChrisM@Work

-- Produces correct output in table but no "Group Name".

-- Note that code was modified to create result table using INTO dbo.MyHead to meet end goal.

--============================================================================================================

',0,0) WITH NOWAIT

;

--===== Start the timers

SET STATISTICS TIME,IO ON

;

--===== Execute the code

WITH Dups AS (

SELECT BusinessName, [Address], Phone

FROM dbo.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

INTO dbo.MyHead

FROM Dups b

INNER JOIN dbo.TestBusiness a

ON a.BusinessName = b.BusinessName

AND a.Address = b.Address

AND a.Phone = b.Phone;

--===== Housekeeping

SET STATISTICS TIME,IO OFF

;

DROP TABLE dbo.MyHead

;

GO 3

RAISERROR('

--============================================================================================================

-- Method 2 by ChrisM@Work

-- Produces correct output in table but no "Group Name".

-- Note that code was modified to create result table using INTO dbo.MyHead to meet end goal.

-- Uses FORCESEEK

--============================================================================================================

',0,0) WITH NOWAIT

;

--===== Start the timers

SET STATISTICS TIME,IO ON

;

WITH Dups AS (

SELECT BusinessName, [Address], Phone

FROM dbo.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

INTO dbo.MyHead

FROM Dups b

INNER JOIN dbo.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;

--===== Housekeeping

SET STATISTICS TIME,IO OFF

;

DROP TABLE dbo.MyHead

;

GO 3

RAISERROR('

--============================================================================================================

-- Method 1 by Jeff Moden

-- Produces correct output in table including the optional "Group Name".

-- Outputs to table like everyone else''s

--============================================================================================================

',0,0) WITH NOWAIT

;

--===== Start the timers

SET STATISTICS TIME,IO ON

;

--===== Execute the code

WITH

cteUnique AS

(

SELECT DupeGroupNumber = ROW_NUMBER() OVER(ORDER BY BusinessName,Address,Phone)

,BusinessName, Address, Phone

FROM dbo.TestBusiness

GROUP BY BusinessName, Address, Phone

HAVING COUNT(*) > 1

)

SELECT u.DupeGroupNumber

,DupeGroupSequence = ROW_NUMBER() OVER (PARTITION BY u.DupeGroupNumber ORDER BY b.Business_PK)

,b.*

INTO dbo.MyHead

FROM dbo.TestBusiness b

JOIN cteUnique u

ON b.BusinessName = u.BusinessName

AND b.Address = u.Address

AND b.Phone = u.Phone

;

--===== Housekeeping

SET STATISTICS TIME,IO OFF

;

DROP TABLE dbo.MyHead

;

GO 3

Here are the results...

Beginning execution loop

--============================================================================================================

-- Method 1 by sqlslacker

-- Produces correct output in table but no "Group Name".

--============================================================================================================

Table 'TestBusiness'. Scan count 10, logical reads 541577, physical reads 2, read-ahead reads 6, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 81450 ms, elapsed time = 305843 ms.

(48 row(s) affected)

--============================================================================================================

-- Method 1 by sqlslacker

-- Produces correct output in table but no "Group Name".

--============================================================================================================

Table 'TestBusiness'. Scan count 10, logical reads 540917, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 88860 ms, elapsed time = 293828 ms.

(48 row(s) affected)

--============================================================================================================

-- Method 1 by sqlslacker

-- Produces correct output in table but no "Group Name".

--============================================================================================================

Table 'TestBusiness'. Scan count 10, logical reads 541957, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 81585 ms, elapsed time = 272478 ms.

(48 row(s) affected)

Batch execution completed 3 times.

Beginning execution loop

--============================================================================================================

-- Method 1 by ChrisM@Work

-- Produces correct output in table but no "Group Name".

-- Note that code was modified to create result table using INTO dbo.MyHead to meet end goal.

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 268447, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 17425 ms, elapsed time = 17427 ms.

(48 row(s) affected)

--============================================================================================================

-- Method 1 by ChrisM@Work

-- Produces correct output in table but no "Group Name".

-- Note that code was modified to create result table using INTO dbo.MyHead to meet end goal.

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 268447, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 17239 ms, elapsed time = 17249 ms.

(48 row(s) affected)

--============================================================================================================

-- Method 1 by ChrisM@Work

-- Produces correct output in table but no "Group Name".

-- Note that code was modified to create result table using INTO dbo.MyHead to meet end goal.

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 268447, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 17269 ms, elapsed time = 17272 ms.

(48 row(s) affected)

Batch execution completed 3 times.

Beginning execution loop

--============================================================================================================

-- Method 2 by ChrisM@Work

-- Produces correct output in table but no "Group Name".

-- Note that code was modified to create result table using INTO dbo.MyHead to meet end goal.

-- Uses FORCESEEK

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 268447, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 17316 ms, elapsed time = 17312 ms.

(48 row(s) affected)

--============================================================================================================

-- Method 2 by ChrisM@Work

-- Produces correct output in table but no "Group Name".

-- Note that code was modified to create result table using INTO dbo.MyHead to meet end goal.

-- Uses FORCESEEK

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 268447, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 17285 ms, elapsed time = 17305 ms.

(48 row(s) affected)

--============================================================================================================

-- Method 2 by ChrisM@Work

-- Produces correct output in table but no "Group Name".

-- Note that code was modified to create result table using INTO dbo.MyHead to meet end goal.

-- Uses FORCESEEK

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 268447, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 17285 ms, elapsed time = 17290 ms.

(48 row(s) affected)

Batch execution completed 3 times.

Beginning execution loop

--============================================================================================================

-- Method 1 by Jeff Moden

-- Produces correct output in table including the optional "Group Name".

-- Outputs to table like everyone else's

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 268640, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 17269 ms, elapsed time = 17319 ms.

(48 row(s) affected)

--============================================================================================================

-- Method 1 by Jeff Moden

-- Produces correct output in table including the optional "Group Name".

-- Outputs to table like everyone else's

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 268640, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 17347 ms, elapsed time = 17349 ms.

(48 row(s) affected)

--============================================================================================================

-- Method 1 by Jeff Moden

-- Produces correct output in table including the optional "Group Name".

-- Outputs to table like everyone else's

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 268640, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 17207 ms, elapsed time = 17301 ms.

(48 row(s) affected)

Batch execution completed 3 times.

Looking forward to additional input. And I don't believe Paul White's excellent method for finding a lot of dupes will work here. The hash-bytes method returned too many false positives for it to be a contender.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 9

Quick note, if the ROW_NUMBER function has a satisfying index to work on it is not expensive at all, consider the code below which only does one index scan and doesn't need a sort as it's working on the order of the index

😎

USE Test;

GO

SET NOCOUNT ON;

;WITH ROW_NUM_SET AS

(

SELECT

TB.Business_pk

,ROW_NUMBER() OVER

(

PARTITION BY TB.BusinessName, TB.Address, TB.Phone

ORDER BY TB.BusinessName, TB.Address, TB.Phone

) AS TB_RID

FROM dbo.TestBusiness TB

)

SELECT

RNS.Business_pk

FROM ROW_NUM_SET RNS

WHERE RNS.TB_RID > 1;

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 10

Chipping in a little more, another method is a computed column and an index on that column, here is a script adapted to fit Jeff's test harness, append it at the end of the setup. Haven't had a chance to test this properly on this harness but given the output of the test runs in Jeff's post it should be more than competitive. The SHA1 is slightly more expensive than CHECKSUM but it doesn't suffer the same collision rate which produces false positives.

😎

GO

RAISERROR('--===== Creating a Computed HASHBYTE Column',0,0) WITH NOWAIT

;

DECLARE @StartTime DATETIME;

SELECT @StartTime = GETDATE()

;

ALTER TABLE dbo.TestBusiness ADD GROUP_NAME AS (CONVERT(VARBINARY(20),HASHBYTES(N'SHA1',UPPER(BusinessName) + UPPER(Address) + UPPER(Phone)),0)) PERSISTED NOT NULL;

PRINT 'Duration = ' + CONVERT(CHAR(12),GETDATE()-@StartTime,114) --hh:mi:ss:mmm(24h)

;

GO

RAISERROR('--===== Creating a HASHBYTE Index',0,0) WITH NOWAIT

;

DECLARE @StartTime DATETIME;

SELECT @StartTime = GETDATE()

;

IF EXISTS(SELECT 1 FROM sys.Indexes WHERE name = 'IX_HASHBYTE_SHA1_01' AND OBJECT_ID('dbo.TestBusiness') IS NOT NULL)

DROP INDEX IX_Composite_01 ON dbo.TestBusiness

;

CREATE NONCLUSTERED INDEX IX_HASHBYTE_SHA1_01

ON dbo.TestBusiness (GROUP_NAME ASC) INCLUDE (Business_pk)

;

PRINT 'Duration = ' + CONVERT(CHAR(12),GETDATE()-@StartTime,114) --hh:mi:ss:mmm(24h)

;

And then the query

RAISERROR('

--============================================================================================================

-- HASHBYTES and ROW_NUMBER (EE)

-- Produces correct output in table including the optional "Group Name".

-- Outputs to table like everyone else''s

--============================================================================================================

',0,0) WITH NOWAIT

;

--===== Start the timers

SET STATISTICS TIME,IO ON

;

--===== Execute the code

SELECT

TX.*

INTO dbo.MyHead

FROM dbo.TestBusiness TX

WHERE TX.GROUP_NAME IN (SELECT GROUP_NAME FROM (

SELECT

TB.GROUP_NAME

,ROW_NUMBER() OVER

(

PARTITION BY TB.GROUP_NAME

ORDER BY TB.GROUP_NAME

) AS TB_RID

FROM dbo.TestBusiness TB

) AS X WHERE X.TB_RID = 2);

;

--===== Housekeeping

SET STATISTICS TIME,IO OFF

;

DROP TABLE dbo.MyHead

;

GO 3

Will add the test results as soon as I have a chance to run this.

sqlslacker SSChasing Mays Points: 657 More actions · Answer 11

Eirikur Eiriksson (10/26/2014)
Quick note, if the ROW_NUMBER function has a satisfying index to work on it is not expensive at all, consider the code below which only does one index scan and doesn't need a sort as it's working on the order of the index
😎
USE Test;
GO
SET NOCOUNT ON;
;WITH ROW_NUM_SET AS
(
SELECT
TB.Business_pk
,ROW_NUMBER() OVER
(
PARTITION BY TB.BusinessName, TB.Address, TB.Phone
ORDER BY TB.BusinessName, TB.Address, TB.Phone
) AS TB_RID
FROM dbo.TestBusiness TB
)
SELECT
RNS.Business_pk
FROM ROW_NUM_SET RNS
WHERE RNS.TB_RID > 1;

I should have mentioned this in my solution. Anything is going to perform poorly without satisfactory indexing! I saw all the replies and was scratching my head - in my experience, ROW_NUMBER() isn't very expensive at all.

NOTE: I didn't actually test any of the proposed solutions.

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 12

sqldriver (10/24/2014)
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

The merge join operator works best with two roughly equally-sized streams of data sorted in the correct order. Nested loops works by picking up one row at a time from the inner input, which is best achieved with single seeks. The optimiser calculates that the inner input in this case is about the same number of rows as the outer input and since they are both sorted in the same order, picks a merge join even though only 1 row in 50 or so is a match. Forcing the optimiser to use seeks changes the join operator from merge or hash which both scan the inner input, to nested loops.

^{“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

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 13

Like Jeff I set up a scaled-up dataset to test against but ran out of time over the weekend to post it up. After reading Jeff's post I've added the missing output column to my two queries and a placeholder for it in sqldriver's modified IBG query.

Here's the scale-up code, which results in a 999999-row table where only the dupes in the OP's original data exist - in other words, it's very heavily skewed:

^{“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

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 14

There appears to be a severe problem with posting at present.

^{“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

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 15

Some test results, looks like the computed column method is roughly 4 times faster than the next one

😎

Beginning execution loop

--============================================================================================================

-- Method 1 by sqlslacker

-- Produces correct output in table but no "Group Name".

--============================================================================================================

Table 'TestBusiness'. Scan count 10, logical reads 553984, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 162661 ms, elapsed time = 258353 ms.

--============================================================================================================

-- Method 1 by sqlslacker

-- Produces correct output in table but no "Group Name".

--============================================================================================================

Table 'TestBusiness'. Scan count 10, logical reads 553844, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 160573 ms, elapsed time = 249733 ms.

--============================================================================================================

-- Method 1 by sqlslacker

-- Produces correct output in table but no "Group Name".

--============================================================================================================

Table 'TestBusiness'. Scan count 10, logical reads 553854, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 161258 ms, elapsed time = 246465 ms.

Batch execution completed 3 times.

Beginning execution loop

--============================================================================================================

-- Method 1 by ChrisM@Work

-- Produces correct output in table but no "Group Name".

-- Note that code was modified to create result table using INTO dbo.MyHead to meet end goal.

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 275324, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 31122 ms, elapsed time = 31197 ms.

--============================================================================================================

-- Method 1 by ChrisM@Work

-- Produces correct output in table but no "Group Name".

-- Note that code was modified to create result table using INTO dbo.MyHead to meet end goal.

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 275324, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 30951 ms, elapsed time = 31037 ms.

--============================================================================================================

-- Method 1 by ChrisM@Work

-- Produces correct output in table but no "Group Name".

-- Note that code was modified to create result table using INTO dbo.MyHead to meet end goal.

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 275324, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 30825 ms, elapsed time = 30910 ms.

Batch execution completed 3 times.

Beginning execution loop

--============================================================================================================

-- Method 2 by ChrisM@Work

-- Produces correct output in table but no "Group Name".

-- Note that code was modified to create result table using INTO dbo.MyHead to meet end goal.

-- Uses FORCESEEK

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 275324, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 30904 ms, elapsed time = 30933 ms.

--============================================================================================================

-- Method 2 by ChrisM@Work

-- Produces correct output in table but no "Group Name".

-- Note that code was modified to create result table using INTO dbo.MyHead to meet end goal.

-- Uses FORCESEEK

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 275324, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 30904 ms, elapsed time = 30947 ms.

--============================================================================================================

-- Method 2 by ChrisM@Work

-- Produces correct output in table but no "Group Name".

-- Note that code was modified to create result table using INTO dbo.MyHead to meet end goal.

-- Uses FORCESEEK

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 275324, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 30888 ms, elapsed time = 30927 ms.

Batch execution completed 3 times.

Beginning execution loop

--============================================================================================================

-- Method 1 by Jeff Moden

-- Produces correct output in table including the optional "Group Name".

-- Outputs to table like everyone else's

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 275516, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 30920 ms, elapsed time = 31033 ms.

--============================================================================================================

-- Method 1 by Jeff Moden

-- Produces correct output in table including the optional "Group Name".

-- Outputs to table like everyone else's

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 275516, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 30903 ms, elapsed time = 30985 ms.

--============================================================================================================

-- Method 1 by Jeff Moden

-- Produces correct output in table including the optional "Group Name".

-- Outputs to table like everyone else's

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 275516, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 30842 ms, elapsed time = 30915 ms.

Batch execution completed 3 times.

Beginning execution loop

--============================================================================================================

-- HASHBYTES and ROW_NUMBER (EE)

-- Produces correct output in table including the optional "Group Name".

-- Outputs to table like everyone else's

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 93188, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 6505 ms, elapsed time = 6503 ms.

--============================================================================================================

-- HASHBYTES and ROW_NUMBER (EE)

-- Produces correct output in table including the optional "Group Name".

-- Outputs to table like everyone else's

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 93188, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 6427 ms, elapsed time = 6426 ms.

--============================================================================================================

-- HASHBYTES and ROW_NUMBER (EE)

-- Produces correct output in table including the optional "Group Name".

-- Outputs to table like everyone else's

--============================================================================================================

Table 'TestBusiness'. Scan count 21, logical reads 93188, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

SQL Server Execution Times:

CPU time = 6459 ms, elapsed time = 6450 ms.

Batch execution completed 3 times.