Removing Duplicate Transactions From VinSUITE DesktopPOS

select webordernumber
INTO #DUPETRANS
from [Transaction]
WHERE WebORderNumber <> ''
group by webordernumber
having count(webordernumber) > 1

select max(t.transactionnumber) as TransNum1, t.webordernumber, MIN(t.transactionnumber) as TransNum2
INTO #DupeTrans2
from [transaction] t
JOIN #DUPETRANS dt on t.WebOrderNumber=dt.WebOrderNumber
Group By t.WebOrderNumber

SELECT * FROM #DupeTrans2
(Use the total row count to validate that your deletes are accurate.)

delete from TenderEntry where transactionnumber in (select TransNum2 from #DupeTrans2);
delete from TransactionEntry where transactionnumber in (select TransNum2 from #DupeTrans2);
delete from NVP_SalesTaxTransaction where transactionnumber in (select TransNum2 from #DupeTrans2);
delete from Shipping where transactionnumber in (select TransNum2 from #DupeTrans2);
Delete from NVP_ShippingTransaction where transactionnumber in (select TransNum2 from #DupeTrans2);
Delete from [Transaction] where transactionnumber in (select TransNum2 from #DupeTrans2);