...12345678),
('AcmeTools', 20000, '1/15/2018', 'Credit', 12345678),
('AcmeTools', 20000, '1/15/2018', 'Credit', 12345679)
;WITH t AS (
SELECT *,
COUNT(*) OVER (PARTITION BY Name, Number, SomeDate, Type, BiggerNumber) DupKeyValues,
ROW_NUMBER() OVER (PARTITION BY Name, Number, SomeDate...