The cursor is not a very elegant solution though...

😛

My try at providing a solution:

First I have this function that I use a lot:

create function [SplitString] (

@String varchar(8000),

@Delimeter char(1) = ',') returns...

How 'bout:

;with

ValidParts(partnbr) as(

select partnbr from Parts

except

select partnbr from ExclusionList)

select count(1)...

Have a look at this article by Jeff Moden:

http://www.sqlservercentral.com/articles/T-SQL/63681/

I'm using Visual Studio to create reports. There is a property called "HideDuplicates" that can be switched on that will give the results you are looking for.

with RawData (EmpRow, ShiftID, TableID, StationID, EmployeeID, MusselCount, CounterDateTimeStamp) as (

select

row_number() over (partition by EmployeeID order by ShiftID, TableID, StationID),

ShiftID,

...