Here's the query straight from profiler for those interested

INSERT INTO @ClaimLines

SELECT DISTINCT R.ClaimNo, R.ClaimLineNo, Amount = -1 *...