MIN Function Example
Code:
Highlight
CREATE PROCEDURE dbo.sp_Get_ResellerHitsCount @ResellerID int AS SELECT MIN(DateAdded)AS BeginDate, COUNT(*) AS ResellerHitsCount FROM ResellerHits WHERE ResellerID = @ResellerID