TopN Stored Procedure

example1.sql

SELECT TOP 5 description, hit_count

example2.sql

CREATE PROCEDURE dbo.media_TopNCategories
(
    @category varchar(300),
    @TopN int
)

as

CREATE TABLE #top_results (
    id [int] IDENTITY(1, 1),
    description [varchar] (300),
    hit_count [int]
)

INSERT #top_results (description, hit_count)
SELECT m.description, m.hit_count
FROM dbo.media m
JOIN dbo.media_categories mc
    on mc.id = m.category_id
WHERE mc.description = @category
ORDER BY m.hit_count DESC

SELECT id, description, hit_count
FROM #top_results
WHERE id < = @TopN