CREATE PROCEDURE getDetailsAgeWise
@FirstAge int,
@SecondAge int
AS
BEGIN
declare @FirstDate datetime,@SecondDate datetime
set @Firstage=0-@Firstage
set @Secondage=0-@SecondAge
set @Firstdate=(select dateadd(year,@Firstage,getdate()))
set @SecondDate=(select dateadd(year,@Secondage,getdate()))
select * from TableName where ColDob between @SecondDate and @Firstdate
END
It may be your proper store procedure