Top Operator Example
Code:
Highlight
CREATE PROCEDURE dbo.sp_Get_ResellerReferringURL @ResellerID int AS SELECT TOP 10 ReferringURL, COUNT(*) AS URLCount FROM ResellerHits WHERE ResellerID = @ResellerID GROUP BY ReferringURL ORDER BY URLCount DESC