--retrieve one TrimWgt from MR#s--
SELECT *
FROM
(SELECT ID, MR#, R#, MrWgt, TrimWgt,
rn = ROW_NUMBER() OVER (PARTITION BY MrWgt ORDER BY TrimWgt)
FROM masterscale3) orderedSlice
WHERE orderedSlice.rn = 1 

Thank you very much. I created a script to create and insert, now we can finally get somewhere!

i posted create and insert data, please review my problem, i have no idea where to start besides using excel

I am trying to retrieve the blue-highlighted based on MR#.

-if MR# is different from last (5 to 6), retrieve 16.30, if MR# is different from last, retrieve 16.85, and repeat

--create masterscale2 table--
Create table masterscale2
(      ID varchar(50)
      ,MR# int
      ,R# int
 ...

Our process:

1. We have masterRolls#
2. We cut into 5 slices per that roll, but it could be 2 slices, could be up to 6 based on different jobs
3. I need...