Extracting Specific Data from a table

[jconway]

I have a table with about 20,000 rows that has a random number and employee id in each record, among other fields. We have about 100 employees, and I want to pull the top 3 records (of the random number generation) for each employee into a table. I'm stumped as to how to do this in SSIS. Any ideas? Should I just use T-SQL?

 

[RiverGuy]

Yes, use a T-SQL query. Something to the effect of this:

SELECT * 
FROM Employee A
WHERE RandomNumberColumn IN 
	(SELECT TOP 3 RandomNumberColumn
	FROM Employee B
	WHERE a.EmployeeID = B.EmployeeID
	ORDER BY RandomNumberColumn DESC)
ORDER BY EmployeeID, RandomNumberColumn DESC