Problem:

Before deleting duplicates you have to find them.
Duplicates are identified using a CTE on the Order table.
Click here for details on Duplicates.
 
 7 Records
FirstName LastName OrderDate RowNumber
Elizabeth Lincoln 1/10/2013 12:00:00 AM 2
Philip Cramer 2/25/2013 12:00:00 AM 2
Howard Snyder 7/31/2013 12:00:00 AM 2
Jose Pavarotti 10/22/2013 12:00:00 AM 2
Felipe Izquierdo 1/19/2014 12:00:00 AM 2
Daniel Tonini 3/24/2014 12:00:00 AM 2
Jose Pavarotti 4/17/2014 12:00:00 AM 2
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas.      Vsn 1.3.0