I created a view in my database from a query which returns Week #, Week Started On, Media Type, Media Type Report Count. Usually I have about 10-15 rows for each week.

What I need to do is select the top 5 for each Week # but if I use top 5 it obviously only returns one week and I need it for all weeks. I know I need to use a self join somewhere but I'm new to SQL and need help!

Can you post your code for the view created. It sounds like you may need a group by clause with ties

CREATE VIEW dbo.media_type_count_by_week
AS
SELECT TOP 100 PERCENT [Week #], [Week Starting On], name AS [Media Type], SUM(enrollment_count) AS [Media Type Report Count]
FROM
(SELECT datediff(d, '6/22/2003', date_created) / 7 AS [Week #], dateadd(d, floor(datediff(d, '6/22/2003', date_created) / 7) * 7, '6/22/2003')
AS [Week Starting On], media_type.name, COUNT(dbo.enrollment_info_real.id) AS enrollment_count
FROM dbo.enrollment_info_real
JOIN dbo.enrollment_info_media_type ON (enrollment_info_id = dbo.enrollment_info_real.id)
JOIN
dbo.media_type ON (media_type_id = dbo.media_type.id)
GROUP BY datediff(d, '6/22/2003', date_created) / 7, dateadd(d, floor(datediff(d, '6/22/2003', date_created) / 7) * 7, '6/22/2003'),
dbo.media_type.name

UNION

SELECT datediff(d, '6/22/2003', date_created) / 7 AS [Week #], dateadd(d, floor(datediff(d, '6/22/2003', date_created) / 7) * 7, '6/22/2003')
AS [Week Starting On], media_type_other, COUNT(dbo.enrollment_info_real.id)
FROM dbo.enrollment_info_real
WHERE (media_type_other IS NOT NULL) AND media_type_other NOT IN ('`')
GROUP BY datediff(d, '6/22/2003', date_created) / 7, dateadd(d, floor(datediff(d, '6/22/2003', date_created) / 7) * 7, '6/22/2003'), media_type_other), media_type_count
WHERE (name IS NOT NULL) AND (name <> 'null') AND (name <> 'Other')
GROUP BY [Week #], [Week Starting On], name
ORDER BY [Week #] DESC, [Media Type Report Count] DESC, name