So you agree with me now. Just wondering if the (age - @Diff) and (age + @Diff) version is sargable (since you both used it).

HTH.

I'd really go with that tool... Takes 1 minute to download/install and another minute to make the tranfer... really a nice tool.

That sums is up... unless I missed something too .

I think that it's an understatement. Time to use the word needs to be done last year .

Yeah I still type fast, don't mention it . Not sure that this is exactly what's needed but I guess we'll know...

First you should be keeping the date of birth instead of the age.

2nd :

Select whatever from dbo.Employees where ABS(@WantedAge - Age) = @MaxAgeDifference

order by ABS(@WantedAge - Age), Age, Name

We can't help you if you don't provide the details of the problem.

And we do it for free .

Ya forgot to mention. You still have to handle the err handling, the new ids to link the tables. Other than that don't forget to tell me what...

First of all, here's the corrected version (had 25-30 compile errors).

Are you using asp.net or asp on the web pages?

create procedure dbo.sp_biginsert

@SRrequestDate varchar(50),

@SRschoolNameFirst varchar(150),

@SRschoolNameLast varchar(150),

@SRschoolCompany...

Now that could be an interesting trio .

I didn't finish 1st in my class, 30% over class average for nothing . That's what actually got me the job. ...

Do we have a Star Trek fan here???

Nice line .

I know... don't want you to forget .

Anyways maybe I should fill those forms for my passport (God knows how long it takes...

Then it'll be great working for you. So when's that junior job opening?